Table purchased_content
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
deleted bool 1  √  null
item_uuid varchar 40
item_version int4 10
source_item_uuid varchar 40
source_item_version int4 10
institution_id int8 19
institution.id fk81b843bdbc711081 R
store_id int8 19  √  null
store.id fk81b843bde2678d38 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc purchased_content_pkey
institution_id Performance Asc pcinstitutionindex
item_uuid Performance Asc pcitemuuidindex
item_version Performance Asc pcitemversionindex
source_item_uuid Performance Asc pcsrcitemuuidindex
source_item_version Performance Asc pcsrcitemversionindex
store_id Performance Asc pcstoreindex

Close relationships  within of separation: