submission_file_revisions

606 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
revision_id BIGINT UNSIGNED 20 √ null
submission_file_id BIGINT UNSIGNED 20 null
submission_files.submission_file_id submission_file_revisions_submission_file_id_foreign R
file_id BIGINT UNSIGNED 20 null
files.file_id submission_file_revisions_file_id_foreign R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc revision_id
submission_file_revisions_file_id_foreign Performance Asc file_id
submission_file_revisions_submission_file_id_foreign Performance Asc submission_file_id

Relationships

Close relationships within degrees of separation