Table postgres.omop.measurement
[CLINICAL] The MEASUREMENT table contains records of Measurement, i.e. structured values (numerical or categorical) obtained through systematic and standardized examination or testing of a Person or Person's sample. The MEASUREMENT table contains both orders and results of such Measurements as laboratory tests, vital signs, quantitative findings from pathology reports, etc.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
measurement_id int4 10 A unique identifier for each Measurement.
person_id int4 10
person.person_id fpk_measurement_person R
A foreign key identifier to the Person about whom the measurement was recorded. The demographic details of that Person are stored in the PERSON table.
measurement_concept_id int4 10
concept.concept_id fpk_measurement_concept R
A foreign key to the standard measurement concept identifier in the Standardized Vocabularies.
measurement_date date 13 The date of the Measurement.
measurement_datetime timestamp 29,6  √  null The date and time of the Measurement. Some database systems don't have a datatype of time. To accomodate all temporal analyses, datatype datetime can be used (combining measurement_date and measurement_time [forum discussion](http://forums.ohdsi.org/t/date-time-and-datetime-problem-and-the-world-of-hours-and-1day/314))
measurement_type_concept_id int4 10
concept.concept_id fpk_measurement_type_concept R
A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the provenance from where the Measurement record was recorded.
operator_concept_id int4 10  √  null
concept.concept_id fpk_measurement_operator R
A foreign key identifier to the predefined Concept in the Standardized Vocabularies reflecting the mathematical operator that is applied to the value_as_number. Operators are <, <=, =, >=, >.
value_as_number numeric 131089  √  null A Measurement result where the result is expressed as a numeric value.
value_as_concept_id int4 10  √  null
concept.concept_id fpk_measurement_value R
A foreign key to a Measurement result represented as a Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.).
unit_concept_id int4 10  √  null
concept.concept_id fpk_measurement_unit R
A foreign key to a Standard Concept ID of Measurement Units in the Standardized Vocabularies.
range_low numeric 131089  √  null The lower limit of the normal range of the Measurement result. The lower range is assumed to be of the same unit of measure as the Measurement value.
range_high numeric 131089  √  null The upper limit of the normal range of the Measurement. The upper range is assumed to be of the same unit of measure as the Measurement value.
provider_id int4 10  √  null
provider.provider_id fpk_measurement_provider R
A foreign key to the provider in the PROVIDER table who was responsible for initiating or obtaining the measurement.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_measurement_visit R
A foreign key to the Visit in the VISIT_OCCURRENCE table during which the Measurement was recorded.
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_measurement_visit_detail R
A foreign key to the Visit in the VISIT_DETAIL table during which the Measurement was recorded.
measurement_source_value varchar 50  √  null The Measurement name as it appears in the source data. This code is mapped to a Standard Concept in the Standardized Vocabularies and the original code is stored here for reference.
measurement_source_concept_id int4 10  √  null
concept.concept_id fpk_measurement_concept_s R
A foreign key to a Concept in the Standard Vocabularies that refers to the code used in the source.
unit_source_value varchar 50  √  null The source code for the unit as it appears in the source data. This code is mapped to a standard unit concept in the Standardized Vocabularies and the original code is stored here for reference.
value_source_value varchar 50  √  null The source value associated with the content of the value_as_number or value_as_concept_id as stored in the source data.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:
Column(s) Type Sort Constraint Name
measurement_id Primary key Asc xpk_measurement
measurement_concept_id Performance Asc idx_measurement_concept_id
person_id Performance Asc idx_measurement_person_id
visit_detail_id Performance Asc idx_measurement_visit_detail_id
visit_occurrence_id Performance Asc idx_measurement_visit_id

Close relationships  within of separation: