Table testsql_comments.borrower_debarments
tracks restrictions on the patron's record

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
borrower_debarment_id int 10  √  unique key for the restriction
borrowernumber int 10
borrowers.borrowernumber borrower_debarments_ibfk_1 C
foreign key for borrowers.borrowernumber for patron who is restricted
expiration date 10  √  null expiration date of the restriction
type enum 11 MANUAL type of restriction
comment text 65535  √  null comments about the restriction
manager_id int 10  √  null foreign key for borrowers.borrowernumber for the librarian managing the restriction
created timestamp 19 CURRENT_TIMESTAMP date the restriction was added
updated timestamp 19  √  null date the restriction was updated

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

Indexes:
Column(s) Type Sort Constraint Name
borrower_debarment_id Primary key Asc PRIMARY
borrowernumber Performance Asc borrowernumber

Close relationships  within of separation: