Table webco_4.3.1.public.sched_staff_assignment Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
shift_oid int8 19  √  null
sched_shift.obj_oid staff_assignment_shift_oid
scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_sched_group_oid
staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_staff_oid
unpublished_scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid staff_assignment_unppublished_sched_group_oid
unpublished_staff_oid int8 19  √  null
sched_staff.obj_oid staff_assignment_unpub_staff_oid
deleted bool 1  √  null
unpublished_edits bool 1  √  null
published bool 1  √  null

Table contained 0 rows at Tue Jun 21 07:45 CDT 2016

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc sched_staff_assignment_pkey

Close relationships  within of separation: