Table postgres.omop.visit_detail
[CLINICAL] The VISIT_DETAIL table is an optional table used to represents details of each record in the parent visit_occurrence table. For every record in visit_occurrence table there may be 0 or more records in the visit_detail table with a 1:n relationship where n may be 0. The visit_detail table is structurally very similar to visit_occurrence table and belongs to the similar domain as the visit.

 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
visit_detail_id int4 10
condition_occurrence.visit_detail_id fpk_condition_visit_detail R
device_exposure.visit_detail_id fpk_device_visit_detail R
drug_exposure.visit_detail_id fpk_drug_visit_detail R
measurement.visit_detail_id fpk_measurement_visit_detail R
note.visit_detail_id fpk_note_visit_detail R
observation.visit_detail_id fpk_observation_visit_detail R
procedure_occurrence.visit_detail_id fpk_procedure_visit_detail R
visit_detail.visit_detail_parent_id fpk_visit_detail_parent R
A unique identifier for each Person's visit or encounter at a healthcare provider.
person_id int4 10
person.person_id fpk_visit_detail_person R
A foreign key identifier to the Person for whom the visit is recorded. The demographic details of that Person are stored in the PERSON table.
visit_detail_concept_id int4 10
concept.concept_id fpk_visit_detail_concept R
A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies.
visit_start_date date 13 The start date of the visit.
visit_start_datetime timestamp 29,6  √  null The date and time of the visit started.
visit_end_date date 13 The end date of the visit. If this is a one-day visit the end date should match the start date.
visit_end_datetime timestamp 29,6  √  null The date and time of the visit end.
visit_type_concept_id int4 10
concept.concept_id fpk_visit_type_concept R
A foreign key to the predefined Concept identifier in the Standardized Vocabularies reflecting the type of source data from which the visit record is derived.
provider_id int4 10  √  null
provider.provider_id fpk_visit_provider R
A foreign key to the provider in the provider table who was associated with the visit.
care_site_id int4 10  √  null
care_site.care_site_id fpk_visit_care_site R
A foreign key to the care site in the care site table that was visited.
visit_source_value varchar 50  √  null The source code for the visit as it appears in the source data.
visit_source_concept_id int4 10  √  null
concept.concept_id fpk_visit_concept_s R
A foreign key to a Concept that refers to the code used in the source.
admitting_source_concept_id int4 10  √  null
concept.concept_id fpk_visit_admitting_s R
A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the admitting source for a visit.
admitting_source_value varchar 50  √  null The source code for the admitting source as it appears in the source data.
discharge_to_concept_id int4 10  √  null
concept.concept_id fpk_visit_discharge R
A foreign key to the predefined concept in the Place of Service Vocabulary reflecting the discharge disposition for a visit.
discharge_to_source_value varchar 50  √  null The source code for the discharge disposition as it appears in the source data.
preceding_visit_detail_id int4 10  √  null A foreign key to the VISIT_DETAIL table of the visit immediately preceding this visit
visit_detail_parent_id int4 10  √  null
visit_detail.visit_detail_id fpk_visit_detail_parent R
A foreign key to the VISIT_DETAIL table record to represent the immediate parent visit-detail record.
visit_occurrence_id int4 10  √  null
visit_occurrence.visit_occurrence_id fpk_visit_occurrence R
A foreign key that refers to the record in the VISIT_OCCURRENCE table. This is a required field, because for every visit_detail is a child of visit_occurrence and cannot exist without a corresponding parent record in visit_occurrence.

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

Indexes:
Column(s) Type Sort Constraint Name
visit_detail_id Primary key Asc xpk_visit_detail
visit_detail_concept_id Performance Asc idx_visit_detail_concept_id
person_id Performance Asc idx_visit_detail_person_id
visit_detail_parent_id Performance Asc idx_visit_detail_visit_detail_id
visit_occurrence_id Performance Asc idx_visit_detail_visit_occurrence_id

Close relationships  within of separation: