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