issue_files


Description

Relationships between issues and issue files, such as cover images.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
file_id BIGINT 19 √ null
issue_galleys.file_id issue_galleys_file_idC
issue_id BIGINT 19 null
issues.issue_id issue_files_issue_idC
file_name VARCHAR 90 null
file_type VARCHAR 255 null
file_size BIGINT 19 null
content_type BIGINT 19 null
original_file_name VARCHAR 127 √ NULL
date_uploaded DATETIME 19 null
date_modified DATETIME 19 null

Indexes

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

Relationships

Close relationships within degrees of separation