Table testsql_comments.branch_borrower_circ_rules
includes default circulation rules for patron categories found under "Checkout limit by patron category"

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_borrower_circ_rules_ibfk_2 C
the branch this rule applies to (branches.branchcode)
categorycode varchar 10
categories.categorycode branch_borrower_circ_rules_ibfk_1 C
the patron category this rule applies to (categories.categorycode)
maxissueqty int 10  √  null the maximum number of checkouts this patron category can have at this branch
maxonsiteissueqty int 10  √  null the maximum number of on-site checkouts this patron category can have at this branch

Table contained 0 rows at Mon Jun 26 09:07 NZST 2017

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

Close relationships  within of separation: