| branchcode |
VARCHAR |
10 |
|
|
null |
|
|
branches.branchcode
|
branch_item_rules_ibfk_2 C
|
|
the branch this rule is for (branches.branchcode) |
| itemtype |
VARCHAR |
10 |
|
|
null |
|
|
itemtypes.itemtype
|
branch_item_rules_ibfk_1 C
|
|
the item type this rule applies to (items.itype) |
| holdallowed |
BIT |
0 |
√ |
|
null |
|
|
the number of holds allowed |
| hold_fulfillment_policy |
enum('any', 'homebranch', 'holdingbranch') |
13 |
|
|
any |
|
|
limit trapping of holds by branchcode |
| returnbranch |
VARCHAR |
15 |
√ |
|
null |
|
|
the branch the item returns to (homebranch, holdingbranch, noreturn) |
