tbl_analysis_values

225 rows


Description

Stores results from an analysis as a (untyped) string value.

Columns

Column Type Size Nulls Auto Children Parents Comments
analysis_value_id int8 19 √
tbl_analysis_boolean_values.analysis_value_id tbl_analysis_boolean_values_analysis_value_id_fkey R
tbl_analysis_categorical_values.analysis_value_id tbl_analysis_categorical_values_analysis_value_id_fkey R
tbl_analysis_dating_ranges.analysis_value_id tbl_analysis_dating_ranges_analysis_value_id_fkey R
tbl_analysis_identifiers.analysis_value_id tbl_analysis_identifiers_analysis_value_id_fkey R
tbl_analysis_integer_ranges.analysis_value_id tbl_analysis_integer_ranges_analysis_value_id_fkey R
tbl_analysis_integer_values.analysis_value_id tbl_analysis_integer_values_analysis_value_id_fkey R
tbl_analysis_notes.analysis_value_id tbl_analysis_notes_analysis_value_id_fkey R
tbl_analysis_numerical_ranges.analysis_value_id tbl_analysis_numerical_ranges_analysis_value_id_fkey R
tbl_analysis_numerical_values.analysis_value_id tbl_analysis_numerical_values_analysis_value_id_fkey R
tbl_analysis_taxon_counts.analysis_value_id tbl_analysis_taxon_counts_analysis_value_id_fkey R
tbl_analysis_value_dimensions.analysis_value_id tbl_analysis_value_dimensions_analysis_value_id_fkey R

Primary key (automatically incremented).
value_class_id int4 10
tbl_value_classes.value_class_id tbl_analysis_values_value_class_id_fkey R

Reference to associated value class that specifies kind of analysis value.
analysis_entity_id int8 19
tbl_analysis_entities.analysis_entity_id tbl_analysis_values_analysis_entity_id_fkey R

Identifies the specific analysis entity associated with this record.
analysis_value text 2147483647 √

The resulting value from the analysis (untyped as a string)
boolean_value bool 1 √

Boolean (true/false) interpretation of the value (is is_boolean is true).
is_boolean bool 1 √

Indicates if value is a boolean value.
is_uncertain bool 1 √

Indicates if resulting value of analysis is uncertain.
is_undefined bool 1 √

Indicates if resulting value is undefined.
is_not_analyzed bool 1 √

Indicates that no analysis was made.
is_indeterminable bool 1 √

Indicates if result of analysis is indeterminable.
is_anomaly bool 1 √

Indicates if value is an anomaly i.e. not complying to expected value class.

Indexes

Constraint Name Type Sort Column(s)
tbl_analysis_values_pkey Primary key Asc analysis_value_id

Relationships

Close relationships within degrees of separation