notifications

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('okr.notifications_id_seq'::regclass)
changes text 2147483647 null
changes_params _text 2147483647 √ null
already_read bool 1 false
organization_id int8 19 null
organizations.id fk_notifications_organization_idC
user_id int8 19 null
users.id fk_notifications_user_idC
triggered_user_id int8 19 null
users.id fk_notifications_triggered_user_idC
objective_id int8 19 √ null
objectives.id fk_notifications_objective_idC
key_result_id int8 19 √ null
key_results.id fk_notifications_key_result_idC
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null
note_id int8 19 √ null
notes.id fk_notifications_note_idC

Indexes

Constraint Name Type Sort Column(s)
notifications_pkey Primary key Asc id
idx_notifications_on_key_result_id Performance Asc key_result_id
idx_notifications_on_note_id Performance Asc note_id
idx_notifications_on_objective_id Performance Asc objective_id
idx_notifications_on_organization_id Performance Asc organization_id
idx_notifications_on_triggered_user_id Performance Asc triggered_user_id
idx_notifications_on_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation