Table postgres.omop.observation
[CLINICAL] The OBSERVATION table captures clinical facts about a Person obtained in the context of examination, questioning or a procedure. Any data that cannot be represented by any other domains, such as social and lifestyle facts, medical history, family history, etc. are recorded here.

 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
observation_id int4 10 A unique identifier for each observation.
person_id int4 10
person.person_id fpk_observation_person R
A foreign key identifier to the Person about whom the observation was recorded. The demographic details of that Person are stored in the PERSON table.
observation_concept_id int4 10
concept.concept_id fpk_observation_concept R
A foreign key to the standard observation concept identifier in the Standardized Vocabularies.
observation_date date 13 The date of the observation.
observation_datetime timestamp 29,6  √  null The date and time of the observation.
observation_type_concept_id int4 10
concept.concept_id fpk_observation_type_concept R
A foreign key to the predefined concept identifier in the Standardized Vocabularies reflecting the type of the observation.
value_as_number numeric 131089  √  null The observation result stored as a number. This is applicable to observations where the result is expressed as a numeric value.
value_as_string varchar 60  √  null The observation result stored as a string. This is applicable to observations where the result is expressed as verbatim text.
value_as_concept_id int4 10  √  null
concept.concept_id fpk_observation_value R
A foreign key to an observation result stored as a Concept ID. This is applicable to observations where the result can be expressed as a Standard Concept from the Standardized Vocabularies (e.g., positive/negative, present/absent, low/high, etc.).
qualifier_concept_id int4 10  √  null
concept.concept_id fpk_observation_qualifier R
A foreign key to a Standard Concept ID for a qualifier (e.g., severity of drug-drug interaction alert)
unit_concept_id int4 10  √  null
concept.concept_id fpk_observation_unit R
A foreign key to a Standard Concept ID of measurement units in the Standardized Vocabularies.
provider_id int4 10  √  null
provider.provider_id fpk_observation_provider R
A foreign key to the provider in the PROVIDER table who was responsible for making the observation.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_observation_visit R
A foreign key to the visit in the VISIT_OCCURRENCE table during which the observation was recorded.
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_observation_visit_detail R
A foreign key to the visit in the VISIT_DETAIL table during which the observation was recorded.
observation_source_value varchar 50  √  null The observation code 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.
observation_source_concept_id int4 10  √  null
concept.concept_id fpk_observation_concept_s R
A foreign key to a Concept 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.
qualifier_source_value varchar 50  √  null The source value associated with a qualifier to characterize the observation

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

Indexes:
Column(s) Type Sort Constraint Name
observation_id Primary key Asc xpk_observation
observation_concept_id Performance Asc idx_observation_concept_id
person_id Performance Asc idx_observation_person_id
visit_detail_id Performance Asc idx_observation_visit_detail_id
visit_occurrence_id Performance Asc idx_observation_visit_id

Close relationships  within of separation: