tbl_analysis_categorical_values

0 rows


Description

Storage for analysis values that represents a categorical value.

Columns

Column Type Size Nulls Auto Children Parents Comments
analysis_categorical_value_id int8 19 √

Primary key (automatically incremented).
analysis_value_id int8 19
tbl_analysis_values.analysis_value_id tbl_analysis_categorical_values_analysis_value_id_fkey R

Identifies the specific analysis value associated with this data.
value_type_item_id int4 10
tbl_value_type_items.value_type_item_id tbl_analysis_categorical_values_value_type_item_id_fkey R

References the predefined category type.
value numeric(20,10) 20,10 √

The categorical value assigned to the analysis.
is_variant bool 1 √

Indicates if value is an alternative interpretation of analysed value.

Indexes

Constraint Name Type Sort Column(s)
tbl_analysis_categorical_values_pkey Primary key Asc analysis_categorical_value_id

Relationships

Close relationships within degrees of separation