borrower_debarment_id |
INT |
10 |
|
√ |
null |
|
|
unique key for the restriction |
borrowernumber |
INT |
10 |
|
|
null |
|
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('SUSPENSION', 'OVERDUES', 'MANUAL', 'DISCHARGE') |
11 |
|
|
MANUAL |
|
|
type of restriction |
|
MEDIUMTEXT |
16777215 |
√ |
|
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 |