variable_table_columns

-1 rows


Description

The order of the columns in a table. Each column must be a variable whose parent is the table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_id int8 19 null
variables.id variable_table_columns_variable_id_fkey R
table_variable_id int8 19 null
variables.id variable_table_columns_table_variable_id_fkey R
variable_tables.variable_id variable_table_columns_table_variable_id_table_variable_ty_fkey C
table_variable_type_id int4 10 null
variable_tables.variable_type_id variable_table_columns_table_variable_id_table_variable_ty_fkey C
variable_types.id variable_table_columns_table_variable_type_id_fkey R
position int4 10 null
is_header bool 1 null

Indexes

Constraint Name Type Sort Column(s)
variable_table_columns_pkey Primary key Asc variable_id
variable_table_columns_table_variable_id_position_key Must be unique Asc/Asc table_variable_id + position

Check Constraints

Constraint Name Constraint
variable_table_columns_table_variable_type_id_check (table_variable_type_id = 6)

Relationships

Close relationships within degrees of separation