hold_fill_targets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 null
borrowers.borrowernumber hold_fill_targets_ibfk_1 C
biblionumber INT 10 null
biblio.biblionumber hold_fill_targets_ibfk_2 C
itemnumber INT 10 null
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

Indexes

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

Relationships