Table webco_5.0.public.sched_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_staff_assignment.shift_oid staff_assignment_shift_oid
staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_shift_staffed_location_oid_fkey
name varchar 2147483647  √  null
notes varchar 2147483647  √  null
start_time timestamptz 35,6  √  null
end_time timestamptz 35,6  √  null
unpublished_name varchar 2147483647  √  null
unpublished_notes varchar 2147483647  √  null
unpublished_start_time timestamptz 35,6  √  null
unpublished_end_time timestamptz 35,6  √  null
deleted bool 1  √  null
unpublished_edits bool 1  √  null
published bool 1  √  null

Table contained 0 rows at Thu Feb 14 09:10 CST 2019

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

Close relationships  within of separation: