view_staff_details

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
refid int4 10 √ null
fname varchar 50 √ null
lname varchar 50 √ null
other_name varchar 50 √ null
known_as varchar 50 √ null
username varchar 100 √ null
email varchar 100 √ null
email_personal varchar 100 √ null
line_manager_name text 2147483647 √ null
legacy_name varchar 100 √ null
minimum_hours numeric 4,2 √ null
line_manager int4 10 √ null
variable_hours bool 1 √ null
report bool 1 √ null
pension bool 1 √ null
department varchar 100 √ null
tbl_departments.department Implied ConstraintR
extension_number numeric 10 √ null
has_company_mobile bool 1 √ null
company_mobile_number bpchar 15 √ null
telephone varchar 25 √ null
IMEI bpchar 18 √ null
driver bool 1 √ null
employed bool 1 √ null
onwebsite bool 1 √ null
car_registration varchar 20 √ null
spinal_type varchar 10 √ null
tbl_spinal_type.spinal_type Implied ConstraintR
job_title varchar 2147483647 √ null
modified timestamp 22 √ null
position varchar 100 √ null
tbl_positions.position Implied ConstraintR
spinal_point int4 10 √ null
position_date date 13 √ null
location varchar 50 √ null
tbl_location.location Implied ConstraintR
location_date date 13 √ null
cost_centre varchar 50 √ null
tbl_cost_centre.cost_centre Implied ConstraintR
cost_centre_date date 13 √ null
payroll_centre varchar 50 √ null
payroll_centre_date date 13 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views