Table testsql_comments.branch_item_rules
information entered in the circulation and fine rules under 'Holds policy by item type'

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
branchcode varchar 10
branches.branchcode branch_item_rules_ibfk_2 C
the branch this rule is for (branches.branchcode)
itemtype varchar 10
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 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 at Mon Jun 26 09:07 NZST 2017

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

Close relationships  within of separation: