public notifications (table)

wikibot ¶

Table

public.notifications

Columns ¶

Column	Data Type	Nullable	Default	Description
textmsg	varchar(4000)	not null
subject	varchar(256)	null
numericmsg	varchar(256)	null
notifyid	integer	not null
pagetime	timestamp with time zone	null
respondtime	timestamp with time zone	null
answeredby	varchar(256)	null
nodeid	integer	null
interfaceid	varchar(16)	null
serviceid	integer	null
queueid	varchar(256)	null
eventid	integer	null
eventuei	varchar(256)	not null
notifconfigname	varchar(63)	null

Primary Key ¶

Primary Key	Columns
pk_notifyid	notifyid

Indexes ¶

Index	Type	Columns
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 ¶

Relation	Column	Referenced Column
public.events	eventid	eventid
public.node	nodeid	nodeid

Detail Tables ¶

Detail Table	Column	Referencing Column
public.usersnotified	notifyid	notifyid