tbl_cost_centre

10 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cost_centre varchar 50 null
ManAccs_Comments.branch ManAccs_Comments_cost_centre_fkeyR
tbl_charge_groups.cost_centre tbl_charge_groups_cost_center_fkeyC
tbl_finance_project.cost_centre tbl_finance_project_cost_centre_fkeyR
tbl_invoice.cost_centre tbl_invoice_cost_centre_fkeyR
tbl_orders.cost_centre tbl_orders_cost_centre_fkeyR
tbl_sales.cost_centre tbl_sales_cost_centre_fkeyR
tbl_slip_exp.cost_centre tbl_slip_exp_cost_centre_fkeyR
tbl_slip_exp.payroll_centre tbl_slip_exp_payroll_centre_fkeyR
tbl_staff_cost_centre.cost_centre tbl_staff_cost_centre_cost_centre_fkeyR
tbl_staff_lookup.cost_centre Implied ConstraintR
tbl_subs.cost_centre tbl_subs_cost_centre_fkeyR
tbl_subs.payroll_centre tbl_subs_payroll_centre_fkeyR
tbl_view_time_sheets_by_day.cost_centre Implied ConstraintR
tbl_view_time_sheets_by_week.cost_centre Implied ConstraintR
tbl_work_in_progress.cost_centre tbl_work_in_progress_cost_centre_fkeyR
view_project_details_admin.cost_centre Implied ConstraintR
view_project_monitor_report_details.cost_centre Implied ConstraintR
view_project_monitor_reports.cost_centre Implied ConstraintR
view_projects.cost_centre Implied ConstraintR
view_projects_summaries.cost_centre Implied ConstraintR
view_staff_positions.cost_centre Implied ConstraintR
view_time_sheets_by_day.cost_centre Implied ConstraintR
view_time_sheets_by_day_part_one.cost_centre Implied ConstraintR
view_time_sheets_by_day_part_two.cost_centre Implied ConstraintR
view_time_sheets_by_week.cost_centre Implied ConstraintR
view_time_sheets_by_week_part_one.cost_centre Implied ConstraintR
view_time_sheets_by_week_part_two.cost_centre Implied ConstraintR
view_wip_summaries.cost_centre Implied ConstraintR
branch_name varchar 100 √ null
hidden bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_cost_centres_pkey Primary key Asc cost_centre
tbl_cost_centre_branch_name_key Must be unique Asc branch_name

Relationships

Close relationships within degrees of separation