SchemaSpy - Table webco_4.4.1.public.sched

Generated by
SchemaSpy

Legend:

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

sched_scheduling_group_member.staff_oid	sched_scheduling_group_member_staff_oid_fkey
sched_staff_assignment.staff_oid	staff_assignment_staff_oid
sched_staff_assignment.unpublished_staff_oid	staff_assignment_unpub_staff_oid
sched_staffing_limit.staff_oid	sched_staffing_limit_staff_oid_fkey

person_oid

int8

person.obj_oid

sched_staff_person_oid_fkey

staffed_location_oid

int8

sched_staff_staffed_location_oid_fkey

manager

bool

√

null

Table contained 0 rows at Fri Mar 24 10:48 CDT 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
obj_oid	Primary key	Asc	sched_staff_pkey
person_oid + staffed_location_oid	Must be unique	Asc/Asc	sched_staff_unique_person_and_staffed_location