circulation_rules

30 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
branchcode VARCHAR 10 √ NULL
branches.branchcode circ_rules_ibfk_1 C
categorycode VARCHAR 10 √ NULL
categories.categorycode circ_rules_ibfk_2 C
itemtype VARCHAR 10 √ NULL
itemtypes.itemtype circ_rules_ibfk_3 C
rule_name VARCHAR 32 null
rule_value VARCHAR 32 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
branchcode Must be unique Asc/Asc/Asc/Asc branchcode + categorycode + itemtype + rule_name
circ_rules_ibfk_2 Performance Asc categorycode
circ_rules_ibfk_3 Performance Asc itemtype
rule_name Performance Asc rule_name

Relationships

Close relationships within degrees of separation