tbl_subs

11954 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_subs_refid_seq'::regclass)
tbl_subs_currency_translation.refid tbl_subs_currency_translation_refid_fkeyC
invoice_code varchar 50 √ null
number_of_days numeric 3,1 √ 0
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_subs_cost_centre_fkeyR
week_ending date 13 √ null
transferred bool 1 √ false
cost numeric 5,2 √ null
staff_refid int4 10 √ null
tbl_staff_lookup.refid tbl_subs_staff_refid_fkeyR
exchange_reference int4 10 √ null
tbl_exchange_reference.exchange_reference tbl_subs_exchange_reference_fkeyR
currency int4 10 √ null
tbl_currency.currency tbl_subs_currency_fkeyR
payroll_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_subs_payroll_centre_fkeyR
location varchar 50 √ null
tbl_location.location tbl_subs_location_fkeyR
legacy_name text 2147483647 √ null
processed bool 1 √ false
translated bool 1 √ null

Indexes

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

Relationships

Close relationships within degrees of separation