Table webco_3.6.1.public.pir_allocation Generated by
SchemaSpy
Legend: SourceForge.net
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
pir_item.pir_allocation_oid fkcpir_item_pir_alloc_oid
version int8 19  √  null
patron_oid int8 19  √  null
person.obj_oid fkcpir_allocation_patron_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkcpir_allocation_alloc_oid
location_oid int8 19  √  null
location.obj_oid fkcpir_allocation_location_oid
pickup_option varchar 2147483647  √  null
deliver_to_string varchar 2147483647  √  null
start_time timestamp 29,6  √  null
end_time timestamp 29,6  √  null

Table contained 0 rows at Wed May 11 15:14 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc pir_allocation_pkey

Close relationships  within of separation: