Table notification
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
attempt_id varchar 36  √  null
batched bool 1
date timestamp 29,6
itemid varchar 255
itemid_only varchar 50
last_attempt timestamp 29,6  √  null
processed bool 1
reason varchar 8
user_to varchar 255
institution_id int8 19
institution.id fk237a88ebbc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc notification_pkey
attempt_id Performance Asc attempt_idx
batched Performance Asc batched_idx
institution_id Performance Asc inst_idx
itemid Performance Asc itemid_idx
itemid_only Performance Asc itemidonly_idx
last_attempt Performance Asc lastattempt_idx
institution_id + itemid + reason + user_to Must be unique Asc/Asc/Asc/Asc notification_institution_id_itemid_reason_user_to_key
processed Performance Asc processed_idx
user_to Performance Asc userto_idx

Close relationships  within of separation: