Table webco_4.2.1.1.public.sched_published_shift 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
sched_unpublished_shift.published_shift_oid unpub_shift_staffed_loc_oid
staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_published_shift_staffed_location_oid_fkey
name varchar 2147483647  √  null
notes varchar 2147483647  √  null
scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid published_sched_sched_group_oid
start_time timestamptz 35,6  √  null
end_time timestamptz 35,6  √  null
staff_oid int8 19  √  null
sched_staff.obj_oid shift_staff_oid

Table contained 0 rows at Thu Jun 18 10:20 CDT 2015

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

Close relationships  within of separation: