tbl_staff_lookup

2579 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid int4 10 null
tbl_charge_groups.entered_by tbl_charge_rates_entered_by_fkeyR
tbl_cost_rates.entered_by tbl_cost_rates_entered_by_fkeyR
tbl_cost_rates.staff_refid tbl_cost_rates_staff_refid_fkeyR
tbl_exchange_reference.entered_by tbl_exchange_reference_entered_by_fkeyR
tbl_finance_project.manager tbl_finance_project_manager_fkeyR
tbl_financial_details.entered_by tbl_financial_details_entered_by_fkeyR
tbl_financial_details.staff_refid tbl_financial_details_staff_refid_fkeyR
tbl_markup_values.entered_by tbl_markup_values_entered_by_fkeyR
tbl_percentage_markup.entered_by tbl_percentage_markup_entered_by_fkeyR
tbl_project_defer_income.entered_by tbl_project_defer_income_entered_by_fkeyR
tbl_project_monitor_reports.entered_by tbl_project_monitor_reports_entered_by_fkeyR
tbl_project_monitor_subscriptions.staff_refid tbl_finance_project_monitor_subscriptions_staff_refid_fkeyC
tbl_slip_exp.staff_refid tbl_slip_exp_staff_refid_fkeyR
tbl_staff_cost_centre.staff_refid tbl_staff_cost_centre_staff_refid_fkeyR
tbl_staff_location.staff_refid tbl_staff_location_staff_refid_fkeyR
tbl_staff_payroll_centre.staff_refid tbl_staff_payroll_centre_staff_refid_fkeyR
tbl_staff_positions.staff_refid tbl_staff_positions_staff_refid_fkeyR
tbl_subs.staff_refid tbl_subs_staff_refid_fkeyR
tbl_subs_hist.staff_refid tbl_subs_hist_staff_refid_fkeyR
tbl_subs_input.staff_refid tbl_subs_input_staff_refid_fkeyR
tbl_weighted_markup.entered_by tbl_weighted_markup_entered_by_fkeyR
fname varchar 50 √ null
lname varchar 50 √ null
legacy_name varchar 100 √ null
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre Implied ConstraintR
payroll_centre varchar 50 √ null
location varchar 50 √ null
tbl_location.location Implied ConstraintR
report bool 1 √ null
pension bool 1 √ false
spinal_type varchar 10 √ null
user_name varchar 100 √ NULL::character varying

Indexes

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

Relationships

Close relationships within degrees of separation