notificationsubscription


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.notificationsubscription_id_seq'::regclass)
user_id int4 10 √ null
user.id fk_nsubscription_user C
notificationpolicy_id int4 10 null
notificationpolicy.id fk_nsubscription_policy R
zone_id int4 10 √ null
zone.id fk_nsubscription_zone C
name text 2147483647 √ null
priority text 2147483647 √ null
subscribed bool 1 true
subscriptiontype text 2147483647 √ null
email text 2147483647 √ null

Table contained 31 rows

Indexes

Constraint Name Type Sort Column(s)
pk_nsubscription_notificationpolicy_id Primary key Asc id
idx_notificationsubscription_npolicy_id Performance Asc notificationpolicy_id
idx_notificationsubscription_subscribed Performance Asc subscribed
idx_notificationsubscription_user_id Performance Asc user_id
idx_notificationsubscription_zone_id Performance Asc zone_id

Relationships

Close relationships within degrees of separation