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