Table testsql_comments.tmp_holdsqueue 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
biblionumber int 10  √  null
deletedbiblio.biblionumber Implied Constraint R
itemnumber int 10  √  null
hold_fill_targets.itemnumber Implied Constraint R
barcode varchar 20  √  null
surname mediumtext 16777215
firstname text 65535  √  null
phone text 65535  √  null
borrowernumber int 10
patronimage.borrowernumber Implied Constraint R
cardnumber varchar 16  √  null
reservedate date 10  √  null
title mediumtext 16777215  √  null
itemcallnumber varchar 255  √  null
holdingbranch varchar 10  √  null
pickbranch varchar 10  √  null
notes text 65535  √  null
item_level_request tinyint 3 0

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016


Close relationships: