sched_staff

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
sched_scheduling_group_member.staff_oid sched_scheduling_group_member_staff_oid_fkeyC
sched_staff_assignment.staff_oid staff_assignment_staff_oidN
sched_staff_assignment.unpublished_staff_oid staff_assignment_unpub_staff_oidN
sched_staffing_limit.staff_oid sched_staffing_limit_staff_oid_fkeyC
person_oid int8 19 null
person.obj_oid sched_staff_person_oid_fkeyC
staffed_location_oid int8 19 null
sched_staffed_location.obj_oid sched_staff_staffed_location_oid_fkeyC
manager bool 1 √ null

Indexes

Constraint Name Type Sort Column(s)
sched_staff_pkey Primary key Asc obj_oid
sched_staff_unique_person_and_staffed_location Must be unique Asc/Asc person_oid + staffed_location_oid

Relationships

Close relationships within degrees of separation