tbl_measured_values

91617 rows


Description

This table records continuous chemical or physical values related to specific sample analyses. Each Sample Analysis can have zero or one associated Measured Value.

Columns

Column Type Size Nulls Auto Children Parents Comments
measured_value_id int8 19 √
tbl_measured_value_dimensions.measured_value_id fk_measured_weights_value_id R

Primary key (automatically incremented).
analysis_entity_id int8 19
tbl_analysis_entities.analysis_entity_id fk_measured_values_analysis_entity_id R

Identifies the specific analysis entity associated with this record.
date_updated timestamptz 35,6 √
measured_value numeric(20,10) 20,10

The continuous value obtained from the sample analysis.

Indexes

Constraint Name Type Sort Column(s)
tbl_measured_values_pkey Primary key Asc measured_value_id
idx_measured_values_analysis_entity_id Performance Asc analysis_entity_id

Relationships

Close relationships within degrees of separation