Table purchase_item
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
catalogue_uuid varchar 40
price int8 19
source_item_uuid varchar 40
source_item_version int4 10
subscription_end_date timestamp 29,6  √  null
subscription_start_date timestamp 29,6  √  null
tax int8 19
tax_code varchar 10  √  null
unit_price int8 19
users int4 10
uuid varchar 40
purchase_id int8 19
purchase.id fkb113279170ddb63c R
purchitempos int4 10
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc purchase_item_pkey
purchase_id Performance Asc purchitempurchaseindex
uuid Performance Asc purchitemuuidindex

Close relationships  within of separation: