tbl_orders

28756 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_orders_refid_seq'::regclass)
tbl_orders_currency_translation.refid tbl_orders_currency_translation_refid_fkeyC
order_number varchar 20 √ null
invoice_code varchar 20 √ null
dated date 13 √ null
supplier varchar 500 √ null
net_value numeric 20,4 √ 0
tl_currency int4 10 √ null
tbl_currency.currency tbl_orders_tl_currency_fkeyR
ordered_by varchar 50 √ null
description text 2147483647 √ null
outstanding bool 1 √ false
authorized_by varchar 50 √ null
cost_centre varchar 100 √ null
tbl_cost_centre.cost_centre tbl_orders_cost_centre_fkeyR
exchange_reference int4 10 √ null
tbl_exchange_reference.exchange_reference tbl_orders_exchange_rate_fkeyR

Indexes

Constraint Name Type Sort Column(s)
tbl_orders_pkey Primary key Asc refid

Relationships

Close relationships within degrees of separation