Table webco_4.3.1.public.sched_scheduling_group 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_scheduling_group_member.scheduling_group_oid sched_scheduling_group_member_scheduling_group_oid_fkey
sched_staff_assignment.scheduling_group_oid staff_assignment_sched_group_oid
sched_staff_assignment.unpublished_scheduling_group_oid staff_assignment_unppublished_sched_group_oid
name varchar 2147483647
description varchar 2147483647  √  null
staffed_location_oid int8 19
sched_staffed_location.obj_oid sched_scheduling_group_staffed_location_oid_fkey

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_scheduling_group_pkey
name + staffed_location_oid Must be unique Asc/Asc sched_scheduling_group_unique_name_per_location

Close relationships  within of separation: