Table webco_3.9.1.public.pir_request_log 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
sessionid varchar 2147483647  √  null
time_stamp timestamp 29,6  √  null
location_oid int8 19  √  null
location.obj_oid fkcpir_request_log_location_oid
patron_oid int8 19  √  null
person.obj_oid fkpir_request_log_patron_oid
allocation_oid int8 19  √  null
allocation.obj_oid fkpir_request_log_allocation_oid
unsaved_allocation_oid int8 19  √  null
allocation.obj_oid fkpir_request_log_unsaved_allocation_oid
editing bool 1  √  null
webmethod varchar 2147483647  √  null
get_parameters varchar 2147483647  √  null
post_parameters varchar 2147483647  √  null

Table contained 0 rows at Tue Feb 04 14:58 EST 2014

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

Close relationships  within of separation: