notification_user_states


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
notification_id uuid 2147483647 null
notifications.id notification_user_states_notification_id_fkey C
user_id text 2147483647 null
schema_migrations.id Implied Constraint R
read_at timestamptz 35,6 √ null
dismissed_at timestamptz 35,6 √ null
actioned_at timestamptz 35,6 √ null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
notification_user_states_pkey Primary key Asc id
notification_user_states_notification_id_user_id_key Must be unique Asc/Asc notification_id + user_id
notification_user_states_user_idx Performance Asc/Asc/Asc user_id + dismissed_at + read_at

Relationships

Close relationships within degrees of separation