Table order_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
added_date timestamp 29,6  √  null
cat_uuid varchar 40
currency varchar 10  √  null
item_uuid varchar 40
item_version int4 10
name text 2147483647  √  null
per_user bool 1  √  null
period_uuid varchar 40  √  null
price int8 19
purchase_tier_uuid varchar 40  √  null
subscription_start_date timestamp 29,6  √  null
subscription_tier_uuid varchar 40  √  null
tax int8 19
tax_code varchar 10  √  null
unit_price int8 19
unit_tax int8 19
users int4 10
uuid varchar 40
order_store_part_id int8 19
order_store_part.id fk2d110d6430fc83c0 R
orderitempos int4 10
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc order_item_pkey
order_store_part_id Performance Asc orderitemorderstoreindex
uuid Performance Asc orderitemuuidindex

Close relationships  within of separation: