genres


Description

The types of submission files configured for each context, such as Article Text, Data Set, Transcript, etc.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
genre_id BIGINT 19 √ null
genre_settings.genre_id genre_settings_genre_id_foreignC
submission_files.genre_id submission_files_genre_id_foreignN
context_id BIGINT 19 null
presses.press_id genres_context_id_foreignC
seq BIGINT 19 null
enabled SMALLINT 5 1
category BIGINT 19 1
dependent SMALLINT 5 0
supplementary SMALLINT 5 0
required SMALLINT 5 0

Whether or not at least one file of this genre is required for a new submission.
entry_key VARCHAR 30 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc genre_id
genres_context_id Performance Asc context_id

Relationships

Close relationships within degrees of separation