Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
Table
testsql_comments
.
tmp_holdsqueue
Generated by
SchemaSpy
Implied relationships
Related columns
Constraints
Comments
Legend
Legend:
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
borrowers
.borrowernumber
Implied Constraint
R
cardnumber
varchar
32
√
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 Mon Jul 16 09:22 NZST 2018
Close relationships:
