Table webco_4.1.0.public.allocation_staffing Generated by
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
allocation_oid int8 19
allocation.obj_oid fkallocation_staffing_allocation_oid
role_oid int8 19
role.obj_oid fkallocation_staffing_role_oid
required_staff int4 10
assigned_staff int4 10
filled bool 1  √  null

Table contained 0 rows at Wed Nov 05 15:04 EST 2014

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

Close relationships  within of separation: