variable_image_values

-1 rows


Description

Linking table that defines which image files are values of which variables.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
variable_value_id int8 19 null
variable_values.id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_id int8 19 null
variables.id variable_image_values_variable_id_fkey R
variable_values.variable_id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_type_id int4 10 null
variable_values.variable_type_id variable_image_values_variable_value_id_variable_id_variab_fkey R
variable_types.id variable_image_values_variable_type_id_fkey R
file_id int8 19 null
files.id variable_image_values_file_id_fkey R
caption text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
variable_image_values_pkey Primary key Asc variable_value_id
variable_image_values_file_id_idx Performance Asc file_id

Check Constraints

Constraint Name Constraint
variable_image_values_variable_type_id_check (variable_type_id = 4)

Relationships

Close relationships within degrees of separation