Table purchase
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
purchase_item.purchase_id fkb113279170ddb63c R
checkout_by varchar 255
checkout_date timestamp 29,6
currency varchar 10
paid bool 1
paid_date timestamp 29,6  √  null
paid_for_by varchar 255  √  null
price int8 19
receipt varchar 255  √  null
tax int8 19
tax_code varchar 10  √  null
transaction_uuid varchar 255
uuid varchar 40
institution_id int8 19
institution.id fk67e90501bc711081 R
store_id int8 19
store.id fk67e90501e2678d38 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc purchase_pkey
checkout_by Performance Asc purchasebuyerindex
institution_id Performance Asc purchaseinstitutionindex
store_id Performance Asc purchasestoreindex
uuid Performance Asc purchaseuuidindex

Close relationships  within of separation: