cdm_53

Tables (9)

concept

  • concept_id — INT — Primary key — NOT NULL
  • concept_name — VARCHAR(255) — NOT NULL
  • domain_id — VARCHAR(20) — NOT NULL
  • vocabulary_id — VARCHAR(20) — NOT NULL
  • concept_class_id — VARCHAR(20) — NOT NULL
  • standard_concept — VARCHAR(1)
  • concept_code — VARCHAR(50) — NOT NULL
  • valid_start_date — DATE — NOT NULL
  • valid_end_date — DATE — NOT NULL
  • invalid_reason — VARCHAR(1)

concept_ancestor

  • ancestor_concept_id — INT — Primary key — NOT NULL
  • descendant_concept_id — INT — Primary key — NOT NULL
  • min_levels_of_separation — INT — NOT NULL
  • max_levels_of_separation — INT — NOT NULL

concept_class

  • concept_class_id — VARCHAR(20) — Primary key — NOT NULL
  • concept_class_name — VARCHAR(255) — NOT NULL
  • concept_class_concept_id — INT — NOT NULL

concept_relationship

  • concept_id_1 — INT — Primary key — NOT NULL
  • concept_id_2 — INT — Primary key — NOT NULL
  • relationship_id — VARCHAR(20) — Primary key — NOT NULL
  • valid_start_date — DATE — NOT NULL
  • valid_end_date — DATE — NOT NULL
  • invalid_reason — VARCHAR(1)

concept_synonym

  • concept_id — INT — Primary key — NOT NULL
  • concept_synonym_name — VARCHAR(1000) — Primary key — NOT NULL
  • language_concept_id — INT — NOT NULL

drug_strength

  • drug_concept_id — INT — Primary key — NOT NULL
  • ingredient_concept_id — INT — Primary key — NOT NULL
  • amount_value — FLOAT(53)
  • amount_unit_concept_id — INT
  • numerator_value — FLOAT(53)
  • numerator_unit_concept_id — INT
  • denominator_value — FLOAT(53)
  • denominator_unit_concept_id — INT
  • box_size — INT
  • valid_start_date — DATE — NOT NULL
  • valid_end_date — DATE — NOT NULL
  • invalid_reason — VARCHAR(1)

relationship

  • relationship_id — VARCHAR(20) — Primary key — NOT NULL
  • relationship_name — VARCHAR(255) — NOT NULL
  • is_hierarchical — VARCHAR(1) — NOT NULL
  • defines_ancestry — VARCHAR(1) — NOT NULL
  • reverse_relationship_id — VARCHAR(20) — NOT NULL
  • relationship_concept_id — INT — NOT NULL

source_to_concept_map

  • source_code — VARCHAR(50) — Primary key — NOT NULL
  • source_vocabulary_id — VARCHAR(20) — Primary key — NOT NULL
  • target_concept_id — INT — Primary key — NOT NULL
  • source_concept_id — INT — NOT NULL
  • source_code_description — VARCHAR(255)
  • target_vocabulary_id — VARCHAR(20) — NOT NULL
  • valid_start_date — DATE — NOT NULL
  • valid_end_date — DATE — NOT NULL
  • invalid_reason — VARCHAR(1)

vocabulary

  • vocabulary_id — VARCHAR(20) — Primary key — NOT NULL
  • vocabulary_name — VARCHAR(255) — NOT NULL
  • vocabulary_reference — VARCHAR(255) — NOT NULL
  • vocabulary_version — VARCHAR(255)
  • vocabulary_concept_id — INT — NOT NULL