variable

620 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_num serial 10 √ nextval('variable_variable_num_seq'::regclass)
additional_method_info.variable_num Implied ConstraintR
mv_dataset_result_summary.variable_num Implied ConstraintR
reference_material_value.variable_num fk_reference_material_value_variableR
result.variable_num fk_result_variableR
v_dataset_result.variable_num Implied ConstraintR
v_dataset_result_summary.variable_num Implied ConstraintR
variable_type_num int4 10 null
variable_type.variable_type_num fk_variable_variable_type_numR
variable_code varchar 32 null
variable_name varchar 2000 √ null
variable_definition varchar 2000 √ null
no_data_value bool 1 false
status int4 10 √ 1
display_order int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
variable_pkey Primary key Asc variable_num
uc_variable Must be unique Asc/Asc variable_type_num + variable_code
v_variable_num_idx Performance Asc variable_num
v_variable_type_num_idx Performance Asc variable_type_num

Relationships

Close relationships within degrees of separation