tbl_cost_rates

11455 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_cost_rates_refid_seq'::regclass)
cost numeric 6,2 √ null
date_entered date 13 √ ('now'::text)::date
entered_by int4 10 √ null
tbl_staff_lookup.refid tbl_cost_rates_entered_by_fkeyR
staff_refid int4 10 √ null
tbl_staff_lookup.refid tbl_cost_rates_staff_refid_fkeyR
currency int4 10 √ null
tbl_currency.currency tbl_cost_rates_currency_fkeyR
date_commencing date 13 √ null

Indexes

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

Relationships

Close relationships within degrees of separation