tbl_staff_lookup

2580 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid int4 10 null
tbl_invoice_code_lookup.projectmanager tbl_invoice_code_lookup_projectmanager_fkeyR
tbl_invoice_code_lookup.supervisor tbl_invoice_code_lookup_supervisor_fkeyR
tbl_office_time_sheet.staffrefid tbl_office_time_sheet_staffrefid_fkeyR
tbl_staff_hols_adjustment.added_by tbl_staff_hols_adjustment_added_by_fkeyR
tbl_staff_hols_adjustment.staff_refid tbl_staff_hols_adjustment_staff_refid_fkeyR
tbl_staff_lookup.linemanager tbl_staff_lookup_linemanager_fkeyR
tbl_staff_preferences.staff_refid tbl_staff_preferences_staff_refid_fkeyC
tbl_staff_toil_adjustment.added_by tbl_staff_toil_adjustment_added_by_fkeyR
tbl_staff_toil_adjustment.staff_refid tbl_staff_toil_adjustment_staff_refid_fkeyR
tbl_staff_toil_adjustment_log.author_refid tbl_staff_toil_adjustment_log_author_refid_fkeyN
tbl_staff_toil_adjustment_log.staff_refid tbl_staff_toil_adjustment_log_staff_refid_fkeyC
fname varchar 50 √ null
lname varchar 50 √ null
linemanager int4 10 √ null
tbl_staff_lookup.refid tbl_staff_lookup_linemanager_fkeyR
username varchar 50 √ null
email varchar 100 √ null
employed bool 1 √ false
minhours numeric 4,2 √ null
variable bool 1 √ false
passphrase bpchar 32 √ md5('default'::text)
old_username varchar 50 √ null
legacy_name varchar 100 √ null
cost_centre varchar 50 √ null
location varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_staff_lookup_pkey Primary key Asc refid
ids_tbl_staff_lookup Performance Asc/Asc/Asc fname + lname + username

Relationships

Close relationships within degrees of separation