Table testsql_comments.hold_fill_targets 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
borrowernumber int 10
borrowers.borrowernumber hold_fill_targets_ibfk_1 C
biblionumber int 10
biblio.biblionumber hold_fill_targets_ibfk_2 C
itemnumber int 10
aqorders_items.itemnumber Implied Constraint R
collections_tracking.itemnumber Implied Constraint R
deleteditems.itemnumber Implied Constraint R
import_items.itemnumber Implied Constraint R
linktracker.itemnumber Implied Constraint R
statistics.itemnumber Implied Constraint R
tmp_holdsqueue.itemnumber Implied Constraint R
items.itemnumber hold_fill_targets_ibfk_3 C
source_branchcode varchar 10  √  null
branches.branchcode hold_fill_targets_ibfk_4 C
item_level_request tinyint 3 0

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

Indexes:
Column(s) Type Sort Constraint Name
itemnumber Primary key Asc PRIMARY
biblionumber + source_branchcode Performance Asc/Asc bib_branch
borrowernumber Performance Asc hold_fill_targets_ibfk_1
source_branchcode Performance Asc hold_fill_targets_ibfk_4

Close relationships  within of separation: