Table postgres.omop.person
[CLINICAL] The Person Domain contains records that uniquely identify each patient in the source data who is time at-risk to have clinical observations recorded within the source systems.

 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
person_id int4 10
condition_era.person_id fpk_condition_era_person R
condition_occurrence.person_id fpk_condition_person R
death.person_id fpk_death_person R
device_exposure.person_id fpk_device_person R
dose_era.person_id fpk_dose_era_person R
drug_era.person_id fpk_drug_era_person R
drug_exposure.person_id fpk_drug_person R
measurement.person_id fpk_measurement_person R
note.person_id fpk_note_person R
observation.person_id fpk_observation_person R
observation_period.person_id fpk_observation_period_person R
payer_plan_period.person_id fpk_payer_plan_period R
procedure_occurrence.person_id fpk_procedure_person R
specimen.person_id fpk_specimen_person R
visit_detail.person_id fpk_visit_detail_person R
visit_occurrence.person_id fpk_visit_person R
A unique identifier for each person.
gender_concept_id int4 10
concept.concept_id fpk_person_gender_concept R
A foreign key that refers to an identifier in the CONCEPT table for the unique gender of the person.
year_of_birth int4 10 The year of birth of the person. For data sources with date of birth, the year is extracted. For data sources where the year of birth is not available, the approximate year of birth is derived based on any age group categorization available.
month_of_birth int4 10  √  null The month of birth of the person. For data sources that provide the precise date of birth, the month is extracted and stored in this field.
day_of_birth int4 10  √  null The day of the month of birth of the person. For data sources that provide the precise date of birth, the day is extracted and stored in this field.
birth_datetime timestamp 29,6  √  null The date and time of birth of the person.
race_concept_id int4 10
concept.concept_id fpk_person_race_concept R
A foreign key that refers to an identifier in the CONCEPT table for the unique race of the person.
ethnicity_concept_id int4 10
concept.concept_id fpk_person_ethnicity_concept R
A foreign key that refers to the standard concept identifier in the Standardized Vocabularies for the ethnicity of the person.
location_id int4 10  √  null
location.location_id fpk_person_location R
A foreign key to the place of residency for the person in the location table, where the detailed address information is stored.
provider_id int4 10  √  null
provider.provider_id fpk_person_provider R
A foreign key to the primary care provider the person is seeing in the provider table.
care_site_id int4 10  √  null
care_site.care_site_id fpk_person_care_site R
A foreign key to the site of primary care in the care_site table, where the details of the care site are stored.
person_source_value varchar 50  √  null An (encrypted) key derived from the person identifier in the source data. This is necessary when a use case requires a link back to the person data at the source dataset.
gender_source_value varchar 50  √  null The source code for the gender of the person as it appears in the source data. The person?s gender is mapped to a standard gender concept in the Standardized Vocabularies; the original value is stored here for reference.
gender_source_concept_id int4 10  √  null
concept.concept_id fpk_person_gender_concept_s R
A foreign key to the gender concept that refers to the code used in the source.
race_source_value varchar 50  √  null The source code for the race of the person as it appears in the source data. The person race is mapped to a standard race concept in the Standardized Vocabularies and the original value is stored here for reference.
race_source_concept_id int4 10  √  null
concept.concept_id fpk_person_race_concept_s R
A foreign key to the race concept that refers to the code used in the source.
ethnicity_source_value varchar 50  √  null The source code for the ethnicity of the person as it appears in the source data. The person ethnicity is mapped to a standard ethnicity concept in the Standardized Vocabularies and the original code is, stored here for reference.
ethnicity_source_concept_id int4 10  √  null
concept.concept_id fpk_person_ethnicity_concept_s R
A foreign key to the ethnicity concept that refers to the code used in the source.

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

Indexes:
Column(s) Type Sort Constraint Name
person_id Primary key Asc xpk_person
person_id Must be unique Asc idx_person_id

Close relationships  within of separation: