notificationpolicy


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.notificationpolicy_id_seq'::regclass)
notificationsubscription.notificationpolicy_id fk_nsubscription_policy R
name text 2147483647 √ null
message text 2147483647 √ null
event text 2147483647 √ null
category text 2147483647 √ null
isdefault bool 1 √ false
notification_type text 2147483647 √ null
priority text 2147483647 √ null
regexpolicy text 2147483647 √ null
querypolicy text 2147483647 √ null

Table contained 36 rows

Indexes

Constraint Name Type Sort Column(s)
pk_notificationpolicy_id Primary key Asc id
idx_notification_policy_isdefault Performance Asc isdefault
idx_notification_policy_name Performance Asc name
idx_notification_policy_notificationtype Performance Asc notification_type

Relationships

Close relationships within degrees of separation