OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - concept link

Properties
Name Value
Description

 

CONCEPT

Table Description

The Standardized Vocabularies contains records, or Concepts, that uniquely identify each fundamental unit of meaning used to express clinical information in all domain tables of the CDM. Concepts are derived from vocabularies, which represent clinical information across a domain (e.g. conditions, drugs, procedures) through the use of codes and associated descriptions. Some Concepts are designated Standard Concepts, meaning these Concepts can be used as normative expressions of a clinical entity within the OMOP Common Data Model and within standardized analytics. Each Standard Concept belongs to one domain, which defines the location where the Concept would be expected to occur within data tables of the CDM.

Concepts can represent broad categories (like ‘Cardiovascular disease’), detailed clinical elements (‘Myocardial infarction of the anterolateral wall’) or modifying characteristics and attributes that define Concepts at various levels of detail (severity of a disease, associated morphology, etc.).

Records in the Standardized Vocabularies tables are derived from national or international vocabularies such as SNOMED-CT, RxNorm, and LOINC, or custom Concepts defined to cover various aspects of observational data analysis.

CDM Field User Guide ETL Conventions Datatype Required Primary Key Foreign Key FK Table FK Domain
concept_id A unique identifier for each Concept across all domains. integer Yes Yes No
concept_name An unambiguous, meaningful and descriptive name for the Concept. varchar(255) Yes No No
domain_id A foreign key to the DOMAIN table the Concept belongs to. varchar(20) Yes No Yes DOMAIN
vocabulary_id A foreign key to the VOCABULARY table indicating from which source the Concept has been adapted. varchar(20) Yes No Yes VOCABULARY
concept_class_id The attribute or concept class of the Concept. Examples are ‘Clinical Drug’, ‘Ingredient’, ‘Clinical Finding’ etc. varchar(20) Yes No Yes CONCEPT_CLASS
standard_concept This flag determines where a Concept is a Standard Concept, i.e. is used in the data, a Classification Concept, or a non-standard Source Concept. The allowable values are ‘S’ (Standard Concept) and ‘C’ (Classification Concept), otherwise the content is NULL. varchar(1) No No No
concept_code The concept code represents the identifier of the Concept in the source vocabulary, such as SNOMED-CT concept IDs, RxNorm RXCUIs etc. Note that concept codes are not unique across vocabularies. varchar(50) Yes No No
valid_start_date The date when the Concept was first recorded. The default value is 1-Jan-1970, meaning, the Concept has no (known) date of inception. date Yes No No
valid_end_date The date when the Concept became invalid because it was deleted or superseded (updated) by a new concept. The default value is 31-Dec-2099, meaning, the Concept is valid until it becomes deprecated. date Yes No No
invalid_reason Reason the Concept was invalidated. Possible values are D (deleted), U (replaced with an update) or NULL when valid_end_date has the default value. varchar(1) No No No

Data Model Physical
Primary Key Constraint Name xpk_concept
Primary Key Clustered Unspecified
Unlogged false

Columns Summary
Column Name Data Type PK / FK Nullable Description
concept_id int4 PK No
concept_name varchar(255) No
domain_id varchar(20) FK No
vocabulary_id varchar(20) PK / FK No
concept_class_id varchar(20) PK / FK No
standard_concept varchar(1) Yes
concept_code varchar(50) No
valid_start_date date No
valid_end_date date No
invalid_reason varchar(1) Yes

Relationships Summary
Name Begin End
 fpk_care_site_place_of_service_concept_id : Relationship
 concept : Entity
 care_site : Entity
 fpk_cdm_source_cdm_version_concept_id : Relationship
 concept : Entity
 cdm_source : Entity
 fpk_cohort_definition_definition_type_concept_id : Relationship
 concept : Entity
 cohort_definition : Entity
 fpk_cohort_definition_subject_concept_id : Relationship
 concept : Entity
 cohort_definition : Entity
 fpk_concept_ancestor_ancestor_concept_id : Relationship
 concept : Entity
 concept_ancestor : Entity
 fpk_concept_ancestor_descendant_concept_id : Relationship
 concept : Entity
 concept_ancestor : Entity
 fpk_concept_class_concept_class_concept_id : Relationship
 concept : Entity
 concept_class : Entity
 fpk_concept_relationship_concept_id_1 : Relationship
 concept : Entity
 concept_relationship : Entity
 fpk_concept_relationship_concept_id_2 : Relationship
 concept : Entity
 concept_relationship : Entity
 fpk_concept_synonym_concept_id : Relationship
 concept : Entity
 concept_synonym : Entity
 fpk_concept_synonym_language_concept_id : Relationship
 concept : Entity
 concept_synonym : Entity
 fpk_condition_era_condition_concept_id : Relationship
 concept : Entity
 condition_era : Entity
 fpk_condition_occurrence_condition_concept_id : Relationship
 concept : Entity
 condition_occurrence : Entity
 fpk_condition_occurrence_condition_type_concept_id : Relationship
 concept : Entity
 condition_occurrence : Entity
 fpk_condition_occurrence_condition_status_concept_id : Relationship
 concept : Entity
 condition_occurrence : Entity
 fpk_condition_occurrence_condition_source_concept_id : Relationship
 concept : Entity
 condition_occurrence : Entity
 fpk_cost_cost_type_concept_id : Relationship
 concept : Entity
 cost : Entity
 fpk_cost_currency_concept_id : Relationship
 concept : Entity
 cost : Entity
 fpk_cost_revenue_code_concept_id : Relationship
 concept : Entity
 cost : Entity
 fpk_cost_drg_concept_id : Relationship
 concept : Entity
 cost : Entity
 fpk_death_death_type_concept_id : Relationship
 concept : Entity
 death : Entity
 fpk_death_cause_concept_id : Relationship
 concept : Entity
 death : Entity
 fpk_death_cause_source_concept_id : Relationship
 concept : Entity
 death : Entity
 fpk_device_exposure_device_concept_id : Relationship
 concept : Entity
 device_exposure : Entity
 fpk_device_exposure_device_type_concept_id : Relationship
 concept : Entity
 device_exposure : Entity
 fpk_device_exposure_device_source_concept_id : Relationship
 concept : Entity
 device_exposure : Entity
 fpk_device_exposure_unit_concept_id : Relationship
 concept : Entity
 device_exposure : Entity
 fpk_device_exposure_unit_source_concept_id : Relationship
 concept : Entity
 device_exposure : Entity
 fpk_domain_domain_concept_id : Relationship
 concept : Entity
 domain : Entity
 fpk_dose_era_drug_concept_id : Relationship
 concept : Entity
 dose_era : Entity
 fpk_dose_era_unit_concept_id : Relationship
 concept : Entity
 dose_era : Entity
 fpk_drug_era_drug_concept_id : Relationship
 concept : Entity
 drug_era : Entity
 fpk_drug_exposure_drug_concept_id : Relationship
 concept : Entity
 drug_exposure : Entity
 fpk_drug_exposure_drug_type_concept_id : Relationship
 concept : Entity
 drug_exposure : Entity
 fpk_drug_exposure_route_concept_id : Relationship
 concept : Entity
 drug_exposure : Entity
 fpk_drug_exposure_drug_source_concept_id : Relationship
 concept : Entity
 drug_exposure : Entity
 fpk_drug_strength_drug_concept_id : Relationship
 concept : Entity
 drug_strength : Entity
 fpk_drug_strength_ingredient_concept_id : Relationship
 concept : Entity
 drug_strength : Entity
 fpk_drug_strength_amount_unit_concept_id : Relationship
 concept : Entity
 drug_strength : Entity
 fpk_drug_strength_numerator_unit_concept_id : Relationship
 concept : Entity
 drug_strength : Entity
 fpk_drug_strength_denominator_unit_concept_id : Relationship
 concept : Entity
 drug_strength : Entity
 fpk_episode_episode_concept_id : Relationship
 concept : Entity
 episode : Entity
 fpk_episode_episode_object_concept_id : Relationship
 concept : Entity
 episode : Entity
 fpk_episode_episode_type_concept_id : Relationship
 concept : Entity
 episode : Entity
 fpk_episode_episode_source_concept_id : Relationship
 concept : Entity
 episode : Entity
 fpk_episode_event_episode_event_field_concept_id : Relationship
 concept : Entity
 episode_event : Entity
 fpk_fact_relationship_domain_concept_id_1 : Relationship
 concept : Entity
 fact_relationship : Entity
 fpk_fact_relationship_domain_concept_id_2 : Relationship
 concept : Entity
 fact_relationship : Entity
 fpk_fact_relationship_relationship_concept_id : Relationship
 concept : Entity
 fact_relationship : Entity
 fpk_location_country_concept_id : Relationship
 concept : Entity
 location : Entity
 fpk_measurement_measurement_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_measurement_type_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_operator_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_value_as_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_unit_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_measurement_source_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_unit_source_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_measurement_meas_event_field_concept_id : Relationship
 concept : Entity
 measurement : Entity
 fpk_metadata_metadata_concept_id : Relationship
 concept : Entity
 metadata : Entity
 fpk_metadata_metadata_type_concept_id : Relationship
 concept : Entity
 metadata : Entity
 fpk_metadata_value_as_concept_id : Relationship
 concept : Entity
 metadata : Entity
 fpk_note_note_type_concept_id : Relationship
 concept : Entity
 note : Entity
 fpk_note_note_class_concept_id : Relationship
 concept : Entity
 note : Entity
 fpk_note_encoding_concept_id : Relationship
 concept : Entity
 note : Entity
 fpk_note_language_concept_id : Relationship
 concept : Entity
 note : Entity
 fpk_note_note_event_field_concept_id : Relationship
 concept : Entity
 note : Entity
 fpk_note_nlp_section_concept_id : Relationship
 concept : Entity
 note_nlp : Entity
 fpk_note_nlp_note_nlp_concept_id : Relationship
 concept : Entity
 note_nlp : Entity
 fpk_note_nlp_note_nlp_source_concept_id : Relationship
 concept : Entity
 note_nlp : Entity
 fpk_observation_observation_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_observation_type_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_value_as_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_qualifier_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_unit_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_observation_source_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_obs_event_field_concept_id : Relationship
 concept : Entity
 observation : Entity
 fpk_observation_period_period_type_concept_id : Relationship
 concept : Entity
 observation_period : Entity
 fpk_payer_plan_period_payer_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_payer_source_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_plan_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_plan_source_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_sponsor_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_sponsor_source_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_stop_reason_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_payer_plan_period_stop_reason_source_concept_id : Relationship
 concept : Entity
 payer_plan_period : Entity
 fpk_person_gender_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_person_race_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_person_ethnicity_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_person_gender_source_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_person_race_source_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_person_ethnicity_source_concept_id : Relationship
 concept : Entity
 person : Entity
 fpk_procedure_occurrence_procedure_concept_id : Relationship
 concept : Entity
 procedure_occurrence : Entity
 fpk_procedure_occurrence_procedure_type_concept_id : Relationship
 concept : Entity
 procedure_occurrence : Entity
 fpk_procedure_occurrence_modifier_concept_id : Relationship
 concept : Entity
 procedure_occurrence : Entity
 fpk_procedure_occurrence_procedure_source_concept_id : Relationship
 concept : Entity
 procedure_occurrence : Entity
 fpk_provider_specialty_concept_id : Relationship
 concept : Entity
 provider : Entity
 fpk_provider_gender_concept_id : Relationship
 concept : Entity
 provider : Entity
 fpk_provider_specialty_source_concept_id : Relationship
 concept : Entity
 provider : Entity
 fpk_provider_gender_source_concept_id : Relationship
 concept : Entity
 provider : Entity
 fpk_relationship_relationship_concept_id : Relationship
 concept : Entity
 relationship : Entity
 fpk_source_to_concept_map_source_concept_id : Relationship
 concept : Entity
 source_to_concept_map : Entity
 fpk_source_to_concept_map_target_concept_id : Relationship
 concept : Entity
 source_to_concept_map : Entity
 fpk_specimen_specimen_concept_id : Relationship
 concept : Entity
 specimen : Entity
 fpk_specimen_specimen_type_concept_id : Relationship
 concept : Entity
 specimen : Entity
 fpk_specimen_unit_concept_id : Relationship
 concept : Entity
 specimen : Entity
 fpk_specimen_anatomic_site_concept_id : Relationship
 concept : Entity
 specimen : Entity
 fpk_specimen_disease_status_concept_id : Relationship
 concept : Entity
 specimen : Entity
 fpk_visit_detail_visit_detail_concept_id : Relationship
 concept : Entity
 visit_detail : Entity
 fpk_visit_detail_visit_detail_type_concept_id : Relationship
 concept : Entity
 visit_detail : Entity
 fpk_visit_detail_visit_detail_source_concept_id : Relationship
 concept : Entity
 visit_detail : Entity
 fpk_visit_detail_admitted_from_concept_id : Relationship
 concept : Entity
 visit_detail : Entity
 fpk_visit_detail_discharged_to_concept_id : Relationship
 concept : Entity
 visit_detail : Entity
 fpk_visit_occurrence_visit_concept_id : Relationship
 concept : Entity
 visit_occurrence : Entity
 fpk_visit_occurrence_visit_type_concept_id : Relationship
 concept : Entity
 visit_occurrence : Entity
 fpk_visit_occurrence_visit_source_concept_id : Relationship
 concept : Entity
 visit_occurrence : Entity
 fpk_visit_occurrence_admitted_from_concept_id : Relationship
 concept : Entity
 visit_occurrence : Entity
 fpk_visit_occurrence_discharged_to_concept_id : Relationship
 concept : Entity
 visit_occurrence : Entity
 fpk_vocabulary_vocabulary_concept_id : Relationship
 concept : Entity
 vocabulary : Entity
 fpk_concept_domain_id : Relationship
 domain : Entity
 concept : Entity
 fpk_concept_vocabulary_id : Relationship
 vocabulary : Entity
 concept : Entity
 fpk_concept_concept_class_id : Relationship
 concept_class : Entity
 concept : Entity

Columns Detail
Name Value
Name concept_id
Type int4
Nullable false
Unique false
Primary Key true
Index false
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name concept_name
Type varchar
Nullable false
Unique false
Primary Key false
Index false
Type Name varchar
Length 255
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name domain_id
Type varchar
Nullable false
Unique false
Primary Key false
Index false
Type Name varchar
Length 20
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name vocabulary_id
Type varchar
Nullable false
Unique false
Primary Key true
Index false
Type Name varchar
Length 20
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name concept_class_id
Type varchar
Nullable false
Unique false
Primary Key true
Index false
Type Name varchar
Length 20
Scale 0
Id Generator native
Foreign Key true
Generated Unspecified
Sync To Attribute Yes

Name Value
Name standard_concept
Type varchar
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 1
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name concept_code
Type varchar
Nullable false
Unique false
Primary Key false
Index false
Type Name varchar
Length 50
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name valid_start_date
Type date
Nullable false
Unique false
Primary Key false
Index false
Type Name date
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name valid_end_date
Type date
Nullable false
Unique false
Primary Key false
Index false
Type Name date
Length 0
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Name Value
Name invalid_reason
Type varchar
Nullable true
Unique false
Primary Key false
Index false
Type Name varchar
Length 1
Scale 0
Id Generator native
Foreign Key false
Generated Unspecified
Sync To Attribute Yes

Relationships Detail
Name Value
Name fpk_care_site_place_of_service_concept_id
Foreign Key
care_site
 place_of_service_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cdm_source_cdm_version_concept_id
Foreign Key
cdm_source
 cdm_version_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cohort_definition_definition_type_concept_id
Foreign Key
cohort_definition
 definition_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cohort_definition_subject_concept_id
Foreign Key
cohort_definition
 subject_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_ancestor_ancestor_concept_id
Foreign Key
concept_ancestor
 ancestor_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_ancestor_descendant_concept_id
Foreign Key
concept_ancestor
 descendant_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_class_concept_class_concept_id
Foreign Key
concept_class
 concept_class_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_relationship_concept_id_1
Foreign Key
concept_relationship
 concept_id_1 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_relationship_concept_id_2
Foreign Key
concept_relationship
 concept_id_2 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_synonym_concept_id
Foreign Key
concept_synonym
 concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_synonym_language_concept_id
Foreign Key
concept_synonym
 language_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_condition_era_condition_concept_id
Foreign Key
condition_era
 condition_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_condition_occurrence_condition_concept_id
Foreign Key
condition_occurrence
 condition_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_condition_occurrence_condition_type_concept_id
Foreign Key
condition_occurrence
 condition_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_condition_occurrence_condition_status_concept_id
Foreign Key
condition_occurrence
 condition_status_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_condition_occurrence_condition_source_concept_id
Foreign Key
condition_occurrence
 condition_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cost_cost_type_concept_id
Foreign Key
cost
 cost_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cost_currency_concept_id
Foreign Key
cost
 currency_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cost_revenue_code_concept_id
Foreign Key
cost
 revenue_code_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_cost_drg_concept_id
Foreign Key
cost
 drg_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_death_type_concept_id
Foreign Key
death
 death_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_cause_concept_id
Foreign Key
death
 cause_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_death_cause_source_concept_id
Foreign Key
death
 cause_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_device_exposure_device_concept_id
Foreign Key
device_exposure
 device_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_device_exposure_device_type_concept_id
Foreign Key
device_exposure
 device_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_device_exposure_device_source_concept_id
Foreign Key
device_exposure
 device_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_device_exposure_unit_concept_id
Foreign Key
device_exposure
 unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_device_exposure_unit_source_concept_id
Foreign Key
device_exposure
 unit_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_domain_domain_concept_id
Foreign Key
domain
 domain_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_dose_era_drug_concept_id
Foreign Key
dose_era
 drug_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_dose_era_unit_concept_id
Foreign Key
dose_era
 unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_era_drug_concept_id
Foreign Key
drug_era
 drug_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_exposure_drug_concept_id
Foreign Key
drug_exposure
 drug_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_exposure_drug_type_concept_id
Foreign Key
drug_exposure
 drug_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_exposure_route_concept_id
Foreign Key
drug_exposure
 route_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_exposure_drug_source_concept_id
Foreign Key
drug_exposure
 drug_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_strength_drug_concept_id
Foreign Key
drug_strength
 drug_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_strength_ingredient_concept_id
Foreign Key
drug_strength
 ingredient_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_strength_amount_unit_concept_id
Foreign Key
drug_strength
 amount_unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_strength_numerator_unit_concept_id
Foreign Key
drug_strength
 numerator_unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_drug_strength_denominator_unit_concept_id
Foreign Key
drug_strength
 denominator_unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_episode_episode_concept_id
Foreign Key
episode
 episode_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_episode_episode_object_concept_id
Foreign Key
episode
 episode_object_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_episode_episode_type_concept_id
Foreign Key
episode
 episode_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_episode_episode_source_concept_id
Foreign Key
episode
 episode_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_episode_event_episode_event_field_concept_id
Foreign Key
episode_event
 episode_event_field_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_fact_relationship_domain_concept_id_1
Foreign Key
fact_relationship
 domain_concept_id_1 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_fact_relationship_domain_concept_id_2
Foreign Key
fact_relationship
 domain_concept_id_2 : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_fact_relationship_relationship_concept_id
Foreign Key
fact_relationship
 relationship_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_location_country_concept_id
Foreign Key
location
 country_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_measurement_concept_id
Foreign Key
measurement
 measurement_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_measurement_type_concept_id
Foreign Key
measurement
 measurement_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_operator_concept_id
Foreign Key
measurement
 operator_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_value_as_concept_id
Foreign Key
measurement
 value_as_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_unit_concept_id
Foreign Key
measurement
 unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_measurement_source_concept_id
Foreign Key
measurement
 measurement_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_unit_source_concept_id
Foreign Key
measurement
 unit_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_measurement_meas_event_field_concept_id
Foreign Key
measurement
 meas_event_field_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_metadata_metadata_concept_id
Foreign Key
metadata
 metadata_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_metadata_metadata_type_concept_id
Foreign Key
metadata
 metadata_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_metadata_value_as_concept_id
Foreign Key
metadata
 value_as_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_note_type_concept_id
Foreign Key
note
 note_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_note_class_concept_id
Foreign Key
note
 note_class_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_encoding_concept_id
Foreign Key
note
 encoding_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_language_concept_id
Foreign Key
note
 language_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_note_event_field_concept_id
Foreign Key
note
 note_event_field_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_nlp_section_concept_id
Foreign Key
note_nlp
 section_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_nlp_note_nlp_concept_id
Foreign Key
note_nlp
 note_nlp_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_note_nlp_note_nlp_source_concept_id
Foreign Key
note_nlp
 note_nlp_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_observation_concept_id
Foreign Key
observation
 observation_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_observation_type_concept_id
Foreign Key
observation
 observation_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_value_as_concept_id
Foreign Key
observation
 value_as_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_qualifier_concept_id
Foreign Key
observation
 qualifier_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_unit_concept_id
Foreign Key
observation
 unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_observation_source_concept_id
Foreign Key
observation
 observation_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_obs_event_field_concept_id
Foreign Key
observation
 obs_event_field_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_observation_period_period_type_concept_id
Foreign Key
observation_period
 period_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_payer_concept_id
Foreign Key
payer_plan_period
 payer_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_payer_source_concept_id
Foreign Key
payer_plan_period
 payer_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_plan_concept_id
Foreign Key
payer_plan_period
 plan_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_plan_source_concept_id
Foreign Key
payer_plan_period
 plan_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_sponsor_concept_id
Foreign Key
payer_plan_period
 sponsor_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_sponsor_source_concept_id
Foreign Key
payer_plan_period
 sponsor_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_stop_reason_concept_id
Foreign Key
payer_plan_period
 stop_reason_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_payer_plan_period_stop_reason_source_concept_id
Foreign Key
payer_plan_period
 stop_reason_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_gender_concept_id
Foreign Key
person
 gender_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_race_concept_id
Foreign Key
person
 race_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_ethnicity_concept_id
Foreign Key
person
 ethnicity_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_gender_source_concept_id
Foreign Key
person
 gender_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_race_source_concept_id
Foreign Key
person
 race_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_person_ethnicity_source_concept_id
Foreign Key
person
 ethnicity_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_procedure_occurrence_procedure_concept_id
Foreign Key
procedure_occurrence
 procedure_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_procedure_occurrence_procedure_type_concept_id
Foreign Key
procedure_occurrence
 procedure_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_procedure_occurrence_modifier_concept_id
Foreign Key
procedure_occurrence
 modifier_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_procedure_occurrence_procedure_source_concept_id
Foreign Key
procedure_occurrence
 procedure_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_provider_specialty_concept_id
Foreign Key
provider
 specialty_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_provider_gender_concept_id
Foreign Key
provider
 gender_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_provider_specialty_source_concept_id
Foreign Key
provider
 specialty_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_provider_gender_source_concept_id
Foreign Key
provider
 gender_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_relationship_relationship_concept_id
Foreign Key
relationship
 relationship_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_source_to_concept_map_source_concept_id
Foreign Key
source_to_concept_map
 source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_source_to_concept_map_target_concept_id
Foreign Key
source_to_concept_map
 target_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_specimen_specimen_concept_id
Foreign Key
specimen
 specimen_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_specimen_specimen_type_concept_id
Foreign Key
specimen
 specimen_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_specimen_unit_concept_id
Foreign Key
specimen
 unit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_specimen_anatomic_site_concept_id
Foreign Key
specimen
 anatomic_site_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_specimen_disease_status_concept_id
Foreign Key
specimen
 disease_status_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_detail_visit_detail_concept_id
Foreign Key
visit_detail
 visit_detail_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_detail_visit_detail_type_concept_id
Foreign Key
visit_detail
 visit_detail_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_detail_visit_detail_source_concept_id
Foreign Key
visit_detail
 visit_detail_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_detail_admitted_from_concept_id
Foreign Key
visit_detail
 admitted_from_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_detail_discharged_to_concept_id
Foreign Key
visit_detail
 discharged_to_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_occurrence_visit_concept_id
Foreign Key
visit_occurrence
 visit_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_occurrence_visit_type_concept_id
Foreign Key
visit_occurrence
 visit_type_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_occurrence_visit_source_concept_id
Foreign Key
visit_occurrence
 visit_source_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_occurrence_admitted_from_concept_id
Foreign Key
visit_occurrence
 admitted_from_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_visit_occurrence_discharged_to_concept_id
Foreign Key
visit_occurrence
 discharged_to_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_vocabulary_vocabulary_concept_id
Foreign Key
vocabulary
 vocabulary_concept_id : Column
Primary Key
concept
 concept_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_domain_id
Foreign Key
concept
 domain_id : Column
Primary Key
domain
 domain_id : Column
To Multiplicity 0..*
From Multiplicity 0..1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_vocabulary_id
Foreign Key
concept
 vocabulary_id : Column
Primary Key
vocabulary
 vocabulary_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Name Value
Name fpk_concept_concept_class_id
Foreign Key
concept
 concept_class_id : Column
Primary Key
concept_class
 concept_class_id : Column
To Multiplicity 0..*
From Multiplicity 1
Sync To Association Yes
Data Model Physical

Appears In
Diagram
 Vocabulary_With_Standard : Entity Relationship Diagram
 Vocabulary_Tables : Entity Relationship Diagram
OMOP_5.4_ER_ALL