notification_preference

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
notification_preference_id uuid 2147483647 null
user_id uuid 2147483647 null
user_account.user_id fk_notification_preference_user_company C
company_id uuid 2147483647 null
user_account.company_id fk_notification_preference_user_company C
pref_key varchar 60 null
enabled bool 1 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
pk_notification_preference Primary key Asc notification_preference_id
idx_notification_preference_user Performance Asc/Asc user_id + company_id
uq_notification_preference_user_key Must be unique Asc/Asc/Asc user_id + company_id + pref_key

Check Constraints

Constraint Name Constraint
ck_notification_preference_key_not_blank ((char_length(TRIM(BOTH FROM pref_key)) > 0))

Relationships

Close relationships within degrees of separation