borrower_debarments

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrower_debarment_id INT 10 null

unique key for the restriction

borrowernumber INT 10 null
borrowers.borrowernumber borrower_debarments_ibfk_1C

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

comment 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

Indexes

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

Relationships