Table testsql_comments.branch_item_rules 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
returnbranch varchar 15  √  null the branch the item returns to (homebranch, holdingbranch, noreturn)

Table contained 0 rows at Tue Dec 27 18:01 NZDT 2016

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

Close relationships  within of separation: