tbl_employment_history

1186 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_employment_history_refid_seq'::regclass)
date_started date 13 √ null
date_finished date 13 √ null
entered_by int4 10 √ null
tbl_staff.refid tbl_employment_history_entered_by_fkeyR
entered_on date 13 √ ('now'::text)::date
leaving_reason text 2147483647 √ null
staff_refid int4 10 √ null
tbl_staff.refid tbl_employment_history_staff_refid_fkeyR
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_employment_history_cost_centre_fkeyR
payroll_centre varchar 50 √ null
tbl_cost_centre.cost_centre tbl_employment_history_payroll_centre_fkeyR
department varchar 100 √ null
tbl_departments.department Implied ConstraintR

Indexes

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

Relationships

Close relationships within degrees of separation