Public.usersnotified (table)

From dbscript Online Help
Jump to: navigation, search

wikibot[edit]

Table public.usersnotified

Columns[edit]

Column Data Type Nullable Default Description
id integer not null
userid varchar(256) not null
notifyid integer null
notifytime timestamp with time zone null
media varchar(32) null
contactinfo varchar(64) null
autonotify char(1) null

Primary Key[edit]

Primary Key Columns
pk_usernotificationid id

Indexes[edit]

Index Type Columns
userid_notifyid_idx userid, notifyid

Foreign Keys[edit]

Relation Column Referenced Column
public.notifications notifyid notifyid