Column Type Size Nulls Auto Default Children Parents Comments
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)

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc itemtype + branchcode
branch_item_rules_ibfk_2 Performance Asc branchcode