tbl_staff_preferences

2580 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staff_refid int4 10 null
tbl_staff_lookup.refid tbl_staff_preferences_staff_refid_fkeyC
resolution float4 8,8 √ null
starttime varchar 5 √ null
stoptime varchar 5 √ null
showweekend bool 1 √ null
authorizes_subordinates bool 1 √ false
authorizes_invoice_codes bool 1 √ false
user_type numeric 131089 √ 0
enrolled bool 1 √ false
temprefid int4 10 √ null
cost_centre varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_staff_preferences_pkey Primary key Asc staff_refid

Relationships

Close relationships within degrees of separation