Table testsql_comments.misc_files
miscellaneous files attached to records from various tables

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  √ 
borrower_files.file_id Implied Constraint R
unique id for the file record
table_tag varchar 255 usually table name, or arbitrary unique tag
record_id int 10 record id from the table this file is associated to
file_name varchar 255 file name
file_type varchar 255 MIME type of the file
file_description varchar 255  √  null description given to the file
file_content longblob 2147483647 file content
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
record_id Performance Asc record_id
table_tag Performance Asc table_tag

Close relationships: