tbl_staff_positions

6033 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
staff_refid int4 10 √ null
tbl_staff.refid tbl_staff_positions_staff_refid_fkeyR
position varchar 100 √ null
tbl_positions.position tbl_staff_positions_position_fkeyR
date_entered date 13 √ ('now'::text)::date
entered_by int4 10 √ null
tbl_staff.refid tbl_staff_positions_entered_by_fkeyR
spinal_point int4 10 √ null
refid serial 10 √ nextval('tbl_staff_positions_refid_seq'::regclass)
date_commencing date 13 √ ('now'::text)::date

Indexes

Constraint Name Type Sort Column(s)
tbl_staff_positions_pkey Primary key Asc refid
tbl_staff_positions_staff_refid_date_commencing_idx Performance Asc/Asc staff_refid + date_commencing
tbl_staff_positions_staff_refid_idx Performance Asc staff_refid

Relationships

Close relationships within degrees of separation