Table postgres.omop.condition_occurrence
[CLINICAL] Conditions are records of a Person suggesting the presence of a disease or medical condition stated as a diagnosis, a sign or a symptom, which is either observed by a Provider or reported by the patient. Conditions are recorded in different sources and levels of standardization, for example:

 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
condition_occurrence_id int4 10 A unique identifier for each Condition Occurrence event.
person_id int4 10
person.person_id fpk_condition_person R
A foreign key identifier to the Person who is experiencing the condition. The demographic details of that Person are stored in the PERSON table.
condition_concept_id int4 10
concept.concept_id fpk_condition_concept R
A foreign key that refers to a Standard Condition Concept identifier in the Standardized Vocabularies.
condition_start_date date 13 The date when the instance of the Condition is recorded.
condition_start_datetime timestamp 29,6 The date and time when the instance of the Condition is recorded.
condition_end_date date 13  √  null The date when the instance of the Condition is considered to have ended.
condition_end_datetime timestamp 29,6  √  null The date when the instance of the Condition is considered to have ended.
condition_type_concept_id int4 10
concept.concept_id fpk_condition_type_concept R
A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the source data from which the condition was recorded, the level of standardization, and the type of occurrence.
stop_reason varchar 20  √  null The reason that the condition was no longer present, as indicated in the source data.
provider_id int4 10  √  null
provider.provider_id fpk_condition_provider R
A foreign key to the Provider in the PROVIDER table who was responsible for capturing (diagnosing) the Condition.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_condition_visit R
A foreign key to the visit in the VISIT_OCCURRENCE table during which the Condition was determined (diagnosed).
visit_detail_id int4 10  √  null
visit_detail.visit_detail_id fpk_condition_visit_detail R
A foreign key to the visit in the VISIT_DETAIL table during which the Condition was determined (diagnosed).
condition_source_value varchar 50  √  null The source code for the condition as it appears in the source data. This code is mapped to a standard condition concept in the Standardized Vocabularies and the original code is stored here for reference.
condition_source_concept_id int4 10  √  null
concept.concept_id fpk_condition_concept_s R
A foreign key to a Condition Concept that refers to the code used in the source.
condition_status_source_value varchar 50  √  null The source code for the condition status as it appears in the source data.
condition_status_concept_id int4 10  √  null
concept.concept_id fpk_condition_status_concept R
A foreign key to the predefined concept in the standard vocabulary reflecting the condition status

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

Indexes:
Column(s) Type Sort Constraint Name
condition_occurrence_id Primary key Asc xpk_condition_occurrence
condition_concept_id Performance Asc idx_condition_concept_id
person_id Performance Asc idx_condition_person_id
visit_detail_id Performance Asc idx_condition_visit_detail_id
visit_occurrence_id Performance Asc idx_condition_visit_id

Close relationships  within of separation: