SchemaSpy - Table webco_4.2.1.1.public.allocation

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

allocation_oid

int8

allocation.obj_oid

fkallocation_staffing_allocation_oid

role_oid

int8

role.obj_oid

fkallocation_staffing_role_oid

required_staff

int4

assigned_staff

int4

filled

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	allocation_staffing_pkey
allocation_oid	Performance	Asc	allocation_staffing_allocation_idx
allocation_oid + role_oid	Must be unique	Asc/Asc	allocation_staffing_allocation_role_uidx
filled	Performance	Asc	allocation_staffing_filled_idx
role_oid	Performance	Asc	allocation_staffing_role_idx