Table testsql_comments.branch_borrower_circ_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 applies to (branches.branchcode)
categorycode varchar 10
categories
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 Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: