overduerules

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
overduerules_id INT 10 √ null
overduerules_transport_types.overduerules_id overduerules_fkC

unique identifier for the overduerules
branchcode VARCHAR 10

foreign key from the branches table to define which branch this rule is for (if blank it’s all libraries)
categorycode VARCHAR 10
categories.categorycode Implied ConstraintR

foreign key from the categories table to define which patron category this rule is for
delay1 INT 10 √ null

number of days after the item is overdue that the first notice is sent
letter1 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the first notice
debarred1 VARCHAR 1 √ 0

is the patron restricted when the first notice is sent (1 for yes, 0 for no)
delay2 INT 10 √ null

number of days after the item is overdue that the second notice is sent
debarred2 VARCHAR 1 √ 0

is the patron restricted when the second notice is sent (1 for yes, 0 for no)
letter2 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the second notice
delay3 INT 10 √ null

number of days after the item is overdue that the third notice is sent
letter3 VARCHAR 20 √ null

foreign key from the letter table to define which notice should be sent as the third notice
debarred3 INT 10 √ 0

is the patron restricted when the third notice is sent (1 for yes, 0 for no)

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc overduerules_id
overduerules_branch_cat Must be unique Asc/Asc branchcode + categorycode

Relationships

Close relationships within degrees of separation