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 longtext 2147483647
firstname mediumtext 16777215  √  null
phone mediumtext 16777215  √  null
borrowernumber int 10
borrowers.borrowernumber Implied Constraint R
cardnumber varchar 32  √  null
reservedate date 10  √  null
title longtext 2147483647  √  null
itemcallnumber varchar 255  √  null
holdingbranch varchar 10  √  null
pickbranch varchar 10  √  null
notes mediumtext 16777215  √  null
item_level_request tinyint 3 0

Table contained 0 rows at Mon Jul 16 08:16 NZST 2018


Close relationships: