variable_tables

-1 rows


Description

Information about tables that is not relevant for other variable types.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_id int8 19 null
variable_table_columns.table_variable_id variable_table_columns_table_variable_id_table_variable_ty_fkey C
variables.id variable_tables_variable_id_variable_type_id_fkey C
variable_type_id int4 10 null
variable_table_columns.table_variable_type_id variable_table_columns_table_variable_id_table_variable_ty_fkey C
variables.variable_type_id variable_tables_variable_id_variable_type_id_fkey C
variable_types.id variable_tables_variable_type_id_fkey R
table_style_id int4 10 null
variable_table_styles.id variable_tables_table_style_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
variable_tables_pkey Primary key Asc variable_id
variable_tables_variable_id_variable_type_id_key Must be unique Asc/Asc variable_id + variable_type_id

Check Constraints

Constraint Name Constraint
variable_tables_variable_type_id_check (variable_type_id = 6)

Relationships