tbl_exchange_reference

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
exchange_reference serial 10 √ nextval('tbl_exchange_rates_refid_seq'::regclass)
tbl_exchange_rates.exchange_reference tbl_exchange_rates_exchange_reference_fkeyR
tbl_finance_project.exchange_reference tbl_finance_project_exchange_reference_fkeyR
tbl_invoice_exchange_lookup.exchange_reference tbl_invoice_exchange_lookup_exchange_reference_fkeyR
tbl_orders.exchange_reference tbl_orders_exchange_rate_fkeyR
tbl_sales_exchange_lookup.exchange_reference tbl_sales_exchange_lookup_exchange_reference_fkeyR
tbl_slip_exp.exchange_reference tbl_slip_exp_exchange_reference_fkeyR
tbl_subs.exchange_reference tbl_subs_exchange_reference_fkeyR
tbl_work_in_progress.exchange_reference tbl_work_in_progress_exchange_rate_fkeyR
date_entered date 13 √ ('now'::text)::date
entered_by int4 10 √ null
tbl_staff_lookup.refid tbl_exchange_reference_entered_by_fkeyR

Indexes

Constraint Name Type Sort Column(s)
tbl_exchange_rates_pkey Primary key Asc exchange_reference

Relationships

Close relationships within degrees of separation