tbl_staff

2563 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid serial 10 √ nextval('tbl_staff_refid_seq'::regclass)
tbl_contact_details.staff_refid tbl_contact_details_staff_refid_fkeyR
tbl_employment_history.entered_by tbl_employment_history_entered_by_fkeyR
tbl_employment_history.staff_refid tbl_employment_history_staff_refid_fkeyR
tbl_foreign_experience.staff_refid tbl_foreign_experience_staff_refid_fkeyR
tbl_hr_details.staff_refid tbl_hr_details_staff_refid_fkeyR
tbl_skills_entry.entered_by tbl_skills_entry_entered_by_fkeyR
tbl_skills_entry.staff_refid tbl_skills_entry_staff_refid_fkeyR
tbl_staff.line_manager tbl_staff_line_manager_fkeyR
tbl_staff_cost_centre.entered_by tbl_staff_cost_centre_entered_by_fkeyR
tbl_staff_cost_centre.staff_refid tbl_staff_cost_centre_staff_refid_fkeyR
tbl_staff_location.entered_by tbl_staff_location_entered_by_fkeyR
tbl_staff_location.staff_refid tbl_staff_location_staff_refid_fkeyR
tbl_staff_payroll_centre.entered_by tbl_staff_payroll_centre_entered_by_fkeyR
tbl_staff_payroll_centre.staff_refid tbl_staff_payroll_centre_staff_refid_fkeyR
tbl_staff_positions.entered_by tbl_staff_positions_entered_by_fkeyR
tbl_staff_positions.staff_refid tbl_staff_positions_staff_refid_fkeyR
fname varchar 50 √ null
lname varchar 50 √ null
line_manager int4 10 √ null
tbl_staff.refid tbl_staff_line_manager_fkeyR
legacy_name varchar 100 √ null
email varchar 100 √ '@oxfordarchaeology.com'::character varying
skillsrefid int4 10 √ null
minimum_hours numeric 4,2 √ null
variable_hours bool 1 √ false
username varchar 100 √ null
report bool 1 √ true
department varchar 100 √ null
tbl_departments.department tbl_staff_department_fkeyR
pension bool 1 √ false
date_added date 13 √ ('now'::text)::date
spinal_type varchar 10 √ 'company'::character varying
tbl_spinal_type.spinal_type tbl_staff_spinal_type_fkeyR
extension_number numeric 10 √ null
has_company_mobile bool 1 √ false
company_mobile_number bpchar 15 √ null
IMEI bpchar 18 √ null
driver bool 1 √ false
other_name varchar 50 √ null
known_as varchar 50 √ null
onwebsite bool 1 √ false
modified timestamp 22 √ now()
telephone varchar 25 √ null
car_registration varchar 20 √ null
job_title varchar 2147483647 √ null
people_hr_employed bool 1 √ null
email_personal varchar 100 √ null

Indexes

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

Relationships

Close relationships within degrees of separation