Table testsql_comments.overduerules
overdue notice status and triggers

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
overduerules_transport_types.branchcode overduerules_fk C
branches.branchcode Implied Constraint R
foreign key from the branches table to define which branch this rule is for (if blank it's all libraries)
categorycode varchar 10
overduerules_transport_types.categorycode overduerules_fk C
default_borrower_circ_rules.categorycode Implied Constraint R
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)

Table contained 0 rows at Tue Dec 27 17:46 NZDT 2016

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

Close relationships  within of separation: