Table webco_3.5.5.public.allocation_item 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 fkcallocation_item_allocation_oid
action varchar 2147483647  √  null
by_type bool 1  √  null
requested_resource_oid int8 19  √  null
proposed_resource_oid int8 19  √  null
resource_schedule_oid int8 19  √  null

Table contained 0 rows at Mon Mar 15 14:58 EDT 2010

Column(s) Type Sort Constraint Name Anomalies
obj_oid Primary key Asc allocation_item_pkey  
allocation_oid Performance Asc allocation_item_alloc_idx  
by_type Performance Asc allocation_item_by_type_idx  
proposed_resource_oid Performance Asc allocation_item_proposed_idx  
requested_resource_oid Performance Asc allocation_item_requested_idx  
resource_schedule_oid Performance Asc allocation_item_resource_idx  
resource_schedule_oid Must be unique Asc allocation_item_resource_schedule_oid_key This unique column is also nullable

Close relationships  within of separation: