Table webco_3.6.1.public.holding 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
bibliographic_record_oid int8 19
bibliographic_record.obj_oid fkholding_bibliographic_record
resource_oid int8 19
resource.obj_oid fkholding_resource
call_number varchar 2147483647  √  null
restrictions varchar 2147483647  √  null
distributor varchar 2147483647  √  null
shelf_location varchar 2147483647  √  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 holding_pkey
bibliographic_record_oid Performance Asc holding_bibliographic_record
resource_oid Performance Asc holding_resource_idx
resource_oid Must be unique Asc holding_resource_oid_key

Close relationships  within of separation: