Table webco_4.0.public.sched_unpublished_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
published_shift_oid int8 19  √  null
sched_published_shift.obj_oid unpub_shift_staffed_loc_oid
staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_unpublished_shift_staffed_location_oid_fkey
name varchar 2147483647  √  null
notes varchar 2147483647  √  null
scheduling_group_oid int8 19  √  null
sched_scheduling_group.obj_oid unpub_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 unpub_shift_staff_oid
deleted bool 1  √  null

Table contained 0 rows at Fri Aug 01 13:08 EDT 2014

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

Close relationships  within of separation: