ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
public.notifications_(table)
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | public.notifications |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | textmsg | varchar(4000) | not null | | |- valign="top" | subject | varchar(256) | null | | |- valign="top" | numericmsg | varchar(256) | null | | |- valign="top" | notifyid | integer | not null | | |- valign="top" | pagetime | timestamp with time zone | null | | |- valign="top" | respondtime | timestamp with time zone | null | | |- valign="top" | answeredby | varchar(256) | null | | |- valign="top" | nodeid | integer | null | | |- valign="top" | interfaceid | varchar(16) | null | | |- valign="top" | serviceid | integer | null | | |- valign="top" | queueid | varchar(256) | null | | |- valign="top" | eventid | integer | null | | |- valign="top" | eventuei | varchar(256) | not null | | |- valign="top" | notifconfigname | varchar(63) | null | | |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | pk_notifyid | notifyid |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | notifications_answeredby_idx | | answeredby |- valign="top" | notifications_eventid_idx | | eventid |- valign="top" | notifications_eventuei_idx | | eventuei |- valign="top" | notifications_ipaddr_idx | | interfaceid |- valign="top" | notifications_nodeid_idx | | nodeid |- valign="top" | notifications_respondtime_idx | | respondtime |- valign="top" | notifications_serviceid_idx | | serviceid |} === Foreign Keys === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Relation''' | '''Column''' | '''Referenced Column''' |- valign="top" | [[public.events_(table)|public.events]] | eventid | eventid |- valign="top" | [[public.node_(table)|public.node]] | nodeid | nodeid |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[public.usersnotified_(table)|public.usersnotified]] | notifyid | notifyid |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.