From dbscript Online Help
wikibot
| Table
|
public.notifications
|
| Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
| textmsg
|
varchar(4000)
|
not null
|
|
|
|
| subject
|
varchar(256)
|
null
|
|
|
|
| numericmsg
|
varchar(256)
|
null
|
|
|
|
| notifyid
|
integer
|
not null
|
|
pk_notifyid
|
|
| pagetime
|
timestamp with time zone
|
null
|
|
|
|
| respondtime
|
timestamp with time zone
|
null
|
|
|
notifications_respondtime_idx
|
| answeredby
|
varchar(256)
|
null
|
|
|
notifications_answeredby_idx
|
| nodeid
|
integer
|
null
|
|
|
notifications_nodeid_idx
|
| interfaceid
|
varchar(16)
|
null
|
|
|
notifications_ipaddr_idx
|
| serviceid
|
integer
|
null
|
|
|
notifications_serviceid_idx
|
| queueid
|
varchar(256)
|
null
|
|
|
|
| eventid
|
integer
|
null
|
|
|
notifications_eventid_idx
|
| eventuei
|
varchar(256)
|
not null
|
|
|
notifications_eventuei_idx
|
| notifconfigname
|
varchar(63)
|
null
|
|
|
|
