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 VARCHAR 50 null
restriction_types.code borrower_debarments_ibfk_2R

type of restriction, FK to restriction_types.code

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
borrower_debarments_ibfk_2 Performance Asc type
borrowernumber Performance Asc borrowernumber

Relationships