| Table webco_3.6.1.public.allocation_item | Generated by SchemaSpy |
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 0 rows at Wed May 11 15:14 EDT 2011 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| 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 |
|