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_1 C

foreign key linking to the patron via the borrowernumber

file_name VARCHAR 255 null Implied Constraint R

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

Table contained 0 rows


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