borrower_files

0 rows


Columns

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

unique key

borrowernumber INT 10 null
borrowers.borrowernumber borrower_files_ibfk_1C

foreign key linking to the patron via the borrowernumber

file_name VARCHAR 255 null
items_search_fields.name Implied ConstraintR

file name

file_type VARCHAR 255 null

type of file

file_description VARCHAR 255 null

description given to the file

file_content LONGBLOB 2147483647 null

the file

date_uploaded TIMESTAMP 19 current_timestamp()

date and time the file was added

Indexes

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

Relationships