Table: modeltypes_formats |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | bigserial | 19 | χ | √ | nextval('modeltypes_formats_id_seq'::regclass) | ||
modeltype_id | int8 | 19 | χ | χ | modeltypes.id | ||
tag | varchar | 255 | χ | χ | |||
format_id | int8 | 19 | χ | χ | formats.id | ||
required | bool | 1 | χ | χ | false | ||
input | bool | 1 | χ | χ | true | ||
user_id | int8 | 19 | √ | χ | null | users.id | |
created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
updated_at | timestamp | 29,6 | √ | χ | utc_now() |
Indexes:
Column(s) | Type | Sort | Constraint Name |
---|---|---|---|
id | Primary key | Asc | modeltypes_formats_pkey |
modeltype_id + tag | Must be unique | Asc/Asc | index_modeltypes_formats_on_modeltype_id_and_tag |
modeltype_id + format_id + input | Must be unique | Asc/Asc/Asc | index_modeltypes_formats_on_modeltype_id_format_id_input |
![]() ![]() |