genres

0 rows


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 bigserial 19 √ nextval('genres_genre_id_seq'::regclass)
genre_settings.genre_id genre_settings_genre_id_foreignC
submission_files.genre_id submission_files_genre_id_foreignN
context_id int8 19 null
presses.press_id genres_context_id_foreignC
seq int8 19 null
enabled int2 5 '1'::smallint
category int8 19 '1'::bigint
dependent int2 5 '0'::smallint
supplementary int2 5 '0'::smallint
required int2 5 '0'::smallint

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)
genres_pkey Primary key Asc genre_id
genres_context_id Performance Asc context_id

Relationships

Close relationships within degrees of separation