files


Description

Records information in the database about files tracked by the system, linking them to the local filesystem.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id BIGINT UNSIGNED 20 √ null
submission_file_revisions.file_id submission_file_revisions_file_id_foreignC
submission_files.file_id submission_files_file_id_foreignC
path VARCHAR 255 null
mimetype VARCHAR 255 null

Indexes

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

Relationships

Close relationships within degrees of separation