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_nodeid_idx		nodeid
notifications_serviceid_idx		serviceid
notifications_answeredby_idx		answeredby
notifications_eventid_idx		eventid
notifications_eventuei_idx		eventuei
notifications_ipaddr_idx		interfaceid
notifications_respondtime_idx		respondtime

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