Table sale
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
sale_item.sale_id fkf9f6880b95d2b2e8 R
store_harvest_info.sale_id fk8149b26295d2b2e8 R
creation_date timestamp 29,6
currency varchar 10
customer_reference varchar 40
data text 2147483647  √  null
paid_date timestamp 29,6  √  null
paid_status int4 10
payment_gateway_uuid varchar 40  √  null
price int8 19
receipt varchar 255  √  null
tax int8 19
tax_code varchar 10  √  null
tax_percent numeric 9,4  √  null
uuid varchar 40
institution_id int8 19
institution.id fk35c047bc711081 R
storefront_id int8 19
store_front.id fk35c047b1d1b0a8 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc sale_pkey
customer_reference Performance Asc salecustrefindex
institution_id Performance Asc saleinstitutionindex
storefront_id Performance Asc salestorefrontindex
uuid Performance Asc saleuuidindex

Close relationships  within of separation: