public notifications (table)

wikibot

Tablepublic.notifications

Columns

ColumnData TypeNullableDefaultDescription
textmsgvarchar(4000)not null  
subjectvarchar(256)null  
numericmsgvarchar(256)null  
notifyidintegernot null  
pagetimetimestamp with time zonenull  
respondtimetimestamp with time zonenull  
answeredbyvarchar(256)null  
nodeidintegernull  
interfaceidvarchar(16)null  
serviceidintegernull  
queueidvarchar(256)null  
eventidintegernull  
eventueivarchar(256)not null  
notifconfignamevarchar(63)null  

Primary Key

Primary KeyColumns
pk_notifyidnotifyid

Indexes

IndexTypeColumns
notifications_answeredby_idx answeredby
notifications_eventid_idx eventid
notifications_eventuei_idx eventuei
notifications_ipaddr_idx interfaceid
notifications_nodeid_idx nodeid
notifications_respondtime_idx respondtime
notifications_serviceid_idx serviceid

Foreign Keys

RelationColumnReferenced Column
public.eventseventideventid
public.nodenodeidnodeid

Detail Tables

Detail TableColumnReferencing Column
public.usersnotifiednotifyidnotifyid