circulation_rules

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 6 of 6 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 5 of 5 entries

Relationships

Close relationships within degrees of separation