Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
genre_id | bigserial | 19 | √ | nextval('genres_genre_id_seq'::regclass) |
|
|
||||||
context_id | int8 | 19 | null |
|
|
|||||||
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 |