tbl_slip_exp

2727591 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staff_refid int4 10 √ null
tbl_staff_lookup.refid tbl_slip_exp_staff_refid_fkeyR
invoice_code varchar 20 √ null
task_code varchar 20 √ null
date_worked date 13 √ null
hours numeric 131089 √ 0
accessdbname varchar 50 √ null
cost numeric 6,2 √ null
transferred bool 1 √ false
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_slip_exp_cost_centre_fkeyR
currency int4 10 √ null
tbl_currency.currency tbl_slip_exp_currency_fkeyR
exchange_reference int4 10 √ null
tbl_exchange_reference.exchange_reference tbl_slip_exp_exchange_reference_fkeyR
payroll_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_slip_exp_payroll_centre_fkeyR
rate_type int2 5 √ null
refid serial 10 √ nextval('tbl_slip_exp_refid_seq'::regclass)
tbl_slip_exp_currency_translation.refid tbl_slip_exp_currency_translation_refid_fkeyC
tbl_slip_exp_currency_translation_charge_rates.refid tbl_slip_exp_currency_translation_charge_rates_refid_fkeyC
work_day numeric 4,2 √ null
charge_cost numeric 6,2 √ null
location varchar 50 √ null
tbl_location.location tbl_slip_exp_location_fkeyR
processed bool 1 √ false
lan_staff_need_charge_rate bool 1 √ false
translated bool 1 √ false
replaced bool 1 √ false
staff_position varchar 100 √ null
tbl_positions.position Implied ConstraintR

Indexes

Constraint Name Type Sort Column(s)
tbl_slip_exp_pkey Primary key Asc refid
idx_slip_exp_date_worked Performance Asc date_worked
idx_slip_exp_invoice_code Performance Asc invoice_code
idx_slip_exp_invoice_date Performance Asc/Asc invoice_code + date_worked
idx_slip_exp_translated Performance Asc translated

Relationships

Close relationships within degrees of separation