| Table bety.public.formats_variables |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | serial | 10 | χ | √ | nextval('formats_variables_id_seq'::regclass) | ||
| format_id | int4 | 10 | √ | χ | null | formats.id | |
| variable_id | int4 | 10 | √ | χ | null | variables.id | |
| name | varchar | 255 | √ | χ | null | ||
| unit | varchar | 255 | √ | χ | null | ||
| storage_type | varchar | 255 | √ | χ | null | ||
| column_number | int4 | 10 | √ | χ | null | ||
| created_at | timestamp | 29,6 | √ | χ | null | ||
| updated_at | timestamp | 29,6 | √ | χ | null |
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 |
|
