Table: formats_variables |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | bigserial | 19 | χ | √ | nextval('formats_variables_id_seq'::regclass) | ||
format_id | int8 | 19 | χ | χ | formats.id | ||
variable_id | int8 | 19 | χ | χ | variables.id | ||
name | varchar | 255 | χ | χ | ''::character varying | ||
unit | varchar | 255 | χ | χ | ''::character varying | ||
storage_type | varchar | 255 | χ | χ | ''::character varying | ||
column_number | int4 | 10 | √ | χ | null | ||
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 | formats_variables_pkey |
format_id + variable_id | Performance | Asc/Asc | index_formats_variables_on_format_id_and_variable_id |
![]() ![]() |