Table testsql_comments.borrower_files
files attached to the patron/borrower record

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
file_id int 10  √ 
misc_files.file_id Implied Constraint R
unique key
borrowernumber int 10
borrowers.borrowernumber borrower_files_ibfk_1 C
foreign key linking to the patron via the borrowernumber
file_name varchar 255 file name
file_type varchar 255 type of file
file_description varchar 255  √  null description given to the file
file_content longblob 2147483647 the file
date_uploaded timestamp 19 CURRENT_TIMESTAMP date and time the file was added

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: