Table postgres.omop.concept
[VOCABULARY] 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.

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
concept_id int4 10
care_site.place_of_service_concept_id fpk_care_site_place R
cohort_attribute.value_as_concept_id fpk_ca_value R
cohort_definition.definition_type_concept_id fpk_cohort_definition_concept R
concept_ancestor.ancestor_concept_id fpk_concept_ancestor_concept_1 R
concept_ancestor.descendant_concept_id fpk_concept_ancestor_concept_2 R
concept_class.concept_class_concept_id fpk_concept_class_concept R
concept_relationship.concept_id_1 fpk_concept_relationship_c_1 R
concept_relationship.concept_id_2 fpk_concept_relationship_c_2 R
concept_synonym.concept_id fpk_concept_synonym_concept R
condition_era.condition_concept_id fpk_condition_era_concept R
condition_occurrence.condition_concept_id fpk_condition_concept R
condition_occurrence.condition_source_concept_id fpk_condition_concept_s R
condition_occurrence.condition_status_concept_id fpk_condition_status_concept R
condition_occurrence.condition_type_concept_id fpk_condition_type_concept R
cost.currency_concept_id fpk_visit_cost_currency R
cost.drg_concept_id fpk_drg_concept R
death.cause_concept_id fpk_death_cause_concept R
death.cause_source_concept_id fpk_death_cause_concept_s R
death.death_type_concept_id fpk_death_type_concept R
device_exposure.device_concept_id fpk_device_concept R
device_exposure.device_source_concept_id fpk_device_concept_s R
device_exposure.device_type_concept_id fpk_device_type_concept R
domain.domain_concept_id fpk_domain_concept R
dose_era.drug_concept_id fpk_dose_era_concept R
dose_era.unit_concept_id fpk_dose_era_unit_concept R
drug_era.drug_concept_id fpk_drug_era_concept R
drug_exposure.drug_concept_id fpk_drug_concept R
drug_exposure.drug_source_concept_id fpk_drug_concept_s R
drug_exposure.drug_type_concept_id fpk_drug_type_concept R
drug_exposure.route_concept_id fpk_drug_route_concept R
drug_strength.amount_unit_concept_id fpk_drug_strength_unit_1 R
drug_strength.denominator_unit_concept_id fpk_drug_strength_unit_3 R
drug_strength.drug_concept_id fpk_drug_strength_concept_1 R
drug_strength.ingredient_concept_id fpk_drug_strength_concept_2 R
drug_strength.numerator_unit_concept_id fpk_drug_strength_unit_2 R
fact_relationship.domain_concept_id_1 fpk_fact_domain_1 R
fact_relationship.domain_concept_id_2 fpk_fact_domain_2 R
fact_relationship.relationship_concept_id fpk_fact_relationship R
measurement.measurement_concept_id fpk_measurement_concept R
measurement.measurement_source_concept_id fpk_measurement_concept_s R
measurement.measurement_type_concept_id fpk_measurement_type_concept R
measurement.operator_concept_id fpk_measurement_operator R
measurement.unit_concept_id fpk_measurement_unit R
measurement.value_as_concept_id fpk_measurement_value R
note.encoding_concept_id fpk_note_encoding_concept R
note.language_concept_id fpk_language_concept R
note.note_class_concept_id fpk_note_class_concept R
note.note_type_concept_id fpk_note_type_concept R
note_nlp.note_nlp_concept_id fpk_note_nlp_concept R
note_nlp.section_concept_id fpk_note_nlp_section_concept R
observation.observation_concept_id fpk_observation_concept R
observation.observation_source_concept_id fpk_observation_concept_s R
observation.observation_type_concept_id fpk_observation_type_concept R
observation.qualifier_concept_id fpk_observation_qualifier R
observation.unit_concept_id fpk_observation_unit R
observation.value_as_concept_id fpk_observation_value R
observation_period.period_type_concept_id fpk_observation_period_concept R
person.ethnicity_concept_id fpk_person_ethnicity_concept R
person.ethnicity_source_concept_id fpk_person_ethnicity_concept_s R
person.gender_concept_id fpk_person_gender_concept R
person.gender_source_concept_id fpk_person_gender_concept_s R
person.race_concept_id fpk_person_race_concept R
person.race_source_concept_id fpk_person_race_concept_s R
procedure_occurrence.modifier_concept_id fpk_procedure_modifier R
procedure_occurrence.procedure_concept_id fpk_procedure_concept R
procedure_occurrence.procedure_source_concept_id fpk_procedure_concept_s R
procedure_occurrence.procedure_type_concept_id fpk_procedure_type_concept R
provider.gender_concept_id fpk_provider_gender R
provider.gender_source_concept_id fpk_provider_gender_s R
provider.specialty_concept_id fpk_provider_specialty R
provider.specialty_source_concept_id fpk_provider_specialty_s R
relationship.relationship_concept_id fpk_relationship_concept R
source_to_concept_map.target_concept_id fpk_source_to_concept_map_c_1 R
specimen.anatomic_site_concept_id fpk_specimen_site_concept R
specimen.disease_status_concept_id fpk_specimen_status_concept R
specimen.specimen_concept_id fpk_specimen_concept R
specimen.specimen_type_concept_id fpk_specimen_type_concept R
specimen.unit_concept_id fpk_specimen_unit_concept R
visit_detail.admitting_source_concept_id fpk_visit_admitting_s R
visit_detail.discharge_to_concept_id fpk_visit_discharge R
visit_detail.visit_detail_concept_id fpk_visit_detail_concept R
visit_detail.visit_source_concept_id fpk_visit_concept_s R
visit_detail.visit_type_concept_id fpk_visit_type_concept R
visit_occurrence.admitting_source_concept_id fpk_visit_admitting_s R
visit_occurrence.discharge_to_concept_id fpk_visit_discharge R
visit_occurrence.visit_concept_id fpk_visit_concept R
visit_occurrence.visit_source_concept_id fpk_visit_concept_s R
visit_occurrence.visit_type_concept_id fpk_visit_type_concept R
vocabulary.vocabulary_concept_id fpk_vocabulary_concept R
A unique identifier for each Concept across all domains.
concept_name varchar 255 An unambiguous, meaningful and descriptive name for the Concept.
domain_id varchar 20
domain.domain_id fpk_concept_domain R
A foreign key to the [DOMAIN](https://github.com/OHDSI/CommonDataModel/wiki/DOMAIN) table the Concept belongs to.
vocabulary_id varchar 20
vocabulary.vocabulary_id fpk_concept_vocabulary R
A foreign key to the [VOCABULARY](https://github.com/OHDSI/CommonDataModel/wiki/VOCABULARY) table indicating from which source the Concept has been adapted.
concept_class_id varchar 20
concept_class.concept_class_id fpk_concept_class R
The attribute or concept class of the Concept. Examples are 'Clinical Drug', 'Ingredient', 'Clinical Finding'etc.
standard_concept varchar 1  √  null 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 allowables values are 'S'(Standard Concept) and 'C'(Classification Concept), otherwise the content is NULL.
concept_code varchar 50 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.
valid_start_date date 13 The date when the Concept was first recorded. The default value is 1-Jan-1970, meaning, the Concept has no (known) date of inception.
valid_end_date date 13 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.
invalid_reason varchar 1  √  null 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.

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

Indexes:
Column(s) Type Sort Constraint Name
concept_id Primary key Asc xpk_concept
concept_class_id Performance Asc idx_concept_class_id
concept_code Performance Asc idx_concept_code
concept_id Must be unique Asc idx_concept_concept_id
domain_id Performance Asc idx_concept_domain_id
vocabulary_id Performance Asc idx_concept_vocabluary_id

Close relationships  within of separation: