SchemaSpy - Table webco_4.2.1.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_published_shift.staff_oid	shift_staff_oid
sched_scheduling_group_member.staff_oid	sched_scheduling_group_member_staff_oid_fkey
sched_staffing_limit.staff_oid	sched_staffing_limit_staff_oid_fkey
sched_unpublished_shift.staff_oid	unpub_shift_staff_oid

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 Thu Jun 18 10:20 CDT 2015

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