Table relation
Maps various relations between items

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
first_resource varchar 255  √  null
relation_type varchar 40  √  null
second_resource varchar 255  √  null
first_item_id int8 19
item.id fkdef3f9fc65f7e40d R
second_item_id int8 19
item.id fkdef3f9fcf78851d1 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc relation_pkey
first_item_id Performance Asc relationfirstitem
second_item_id Performance Asc relationseconditem

Close relationships  within of separation: