Table sale_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
item_uuid varchar 40
item_version int4 10
price int8 19
pricing_tier_uuid varchar 40  √  null
quantity 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
unit_tax int8 19
uuid varchar 40
period_id int8 19  √  null
subscription_period.id fkf9f6880bea92b3a5 R
sale_id int8 19
sale.id fkf9f6880b95d2b2e8 R
saleitempos int4 10
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc sale_item_pkey
catalogue_uuid Performance Asc saleitemcatalogueuuidindex
item_uuid Performance Asc saleitemitemuuidindex
sale_id Performance Asc saleitemsaleindex
uuid Performance Asc saleitemuuidindex
period_id Performance Asc si_period

Close relationships  within of separation: