tbl_cost_centre

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
branch_name varchar 100 null
address_line_one varchar 100 √ null
address_line_two varchar 100 √ null
locale varchar 100 √ null
county varchar 50 √ null
country varchar 50 √ null
post_code varchar 10 √ null
main_number varchar 20 √ null
fax_number varchar 20 √ null
cost_centre varchar 50 null
tbl_employment_history.cost_centre tbl_employment_history_cost_centre_fkeyR
tbl_employment_history.payroll_centre tbl_employment_history_payroll_centre_fkeyR
tbl_staff_cost_centre.cost_centre tbl_staff_cost_centre_cost_centre_fkeyR
view_staff.cost_centre Implied ConstraintR
view_staff_details.cost_centre Implied ConstraintR
hidden bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
tbl_cost_centre_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