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
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
branchcode varchar 10
branches
the branch this rule is for (branches.branchcode)
itemtype varchar 10
itemtypes
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 Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: