(for Vocabulary:) A foreign key that refers to a standard concept identifier in the CONCEPT table for the Vocabulary the VOCABULARY record belongs to.

(for Specimen:) A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen.

(for Observation:) A foreign key to the standard observation concept identifier in the Standardized Vocabularies.

(for DrugStrength:) A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept.

(for ConditionOccurrence:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Condition' domain.

(for DrugExposure:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Drug' domain.

(for ConceptClass:) A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Concept Class the record belongs to.

(for NoteNlp:) A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the normalized concept for the extracted term. Domain of the term is represented as part of the Concept table.

(for VisitOccurrence:) A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies belonging to the 'Visit' Vocabulary.

(for Measurement:) A foreign key to the standard measurement concept identifier in the Standardized Vocabularies. These belong to the 'Measurement' domain, but could overlap with the 'Observation' domain (see #3 below).

(for Relationship:) A foreign key that refers to an identifier in the CONCEPT table for the unique relationship concept.

(for Domain:) A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Domain Concept the Domain record belongs to.

(for DoseEra:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the active Ingredient Concept.

(for Cost:) A foreign key that refers to a Standard Cost Concept identifier in the Standardized Vocabularies belonging to the 'Cost' vocabulary.

(for ProcedureOccurrence:) A foreign key that refers to a standard procedure Concept identifier in the Standardized Vocabularies.

(for ConditionEra:) A foreign key that refers to a standard Condition Concept identifier in the Standardized Vocabularies.

(for Metadata:) A foreign key that refers to a Standard Metadata Concept identifier in the Standardized Vocabularies.

(for DeviceExposure:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies belonging to the 'Device' domain.

(for VisitDetail:) A foreign key that refers to a visit Concept identifier in the Standardized Vocabularies belonging to the 'Visit' Vocabulary.

(for DrugEra:) A foreign key that refers to a Standard Concept identifier in the Standardized Vocabularies for the Ingredient Concept.

(for ConceptSynonym:) A foreign key to the Concept in the CONCEPT table.

dose_era.drug_concept_id#263 AS Concept

condition_era.condition_concept_id#257 AS Concept

device_exposure.device_concept_id#30 AS Concept

condition_occurrence.condition_concept_id#14 AS Concept

procedure_occurrence.procedure_concept_id#168 AS Concept

specimen.specimen_concept_id#182 AS Concept

visit_occurrence.visit_concept_id#240 AS Concept

visit_detail.visit_detail_concept_id#221 AS Concept

note_nlp.note_nlp_concept_id#113 AS Concept

cost.cost_concept_id#279 AS Concept

measurement.measurement_concept_id#73 AS Concept

domain.domain_concept_id#395 AS Concept

metadata.metadata_concept_id#360 AS Concept

drug_exposure.drug_concept_id#45 AS Concept

vocabulary.vocabulary_concept_id#427 AS Concept

drug_era.drug_concept_id#270 AS Concept

concept_synonym.concept_id#390 AS Concept

relationship.relationship_concept_id#413 AS Concept

concept_class.concept_class_concept_id#383 AS Concept

drug_strength.drug_concept_id#396 AS Concept

observation.observation_concept_id#123 AS Concept

concept