OMOP
Tables (6)
concept (Untitled5)
- concept_id — INT — Primary key — NOT NULL
- concept_name — VARCHAR(255)
- domain_id — VARCHAR(20)
- vocabulary_id — VARCHAR(20)
- concept_class_id — VARCHAR(20)
- standard_concept — VARCHAR(1)
- concept_code — VARCHAR(50)
- valid_start_date — DATE
- valid_end_date — DATE
- invalid_reason — VARCHAR(1)
condition_occurrence (Untitled3)
- Key (condition_occurrence_id) — BIGINT — Primary key — NOT NULL
- person_id — BIGINT — Foreign key → person.Person id — NOT NULL
- visit_occurrence_id — BIGINT — Foreign key → visit_occurrence.Key — NOT NULL
- condition_concept_id — INT
- condition_start_date — DATE
- condition_start_datetime — DATETIME
- condition_end_date — DATE
- condition_end_datetime — DATETIME
- condition_type_concept_id — INT
- condition_status_concept_id — INT
- stop_reason — VARCHAR(20)
- provider_id — BIGINT
- visit_detail_id — BIGINT
- condition_source_value — VARCHAR(50)
- condition_source_concept_id — INT
- condition_status_source_value — VARCHAR(50)
death (Untitled6)
- person_id — BIGINT — Foreign key → person.Person id — NOT NULL
- death_date — DATE
- death_datetime — DATETIME
- death_type_concept_id — INT
- cause_concept_id — BIGINT
- cause_source_value — INT
- cause_soure_concept_id — INT
drug_exposure (Untitled4)
- Key (drug_exposure_id) — BIGINT — Primary key — NOT NULL
- person_id — BIGINT — Foreign key → person.Person id — NOT NULL
- Key (visit_occurrence_id) — BIGINT — Foreign key → visit_occurrence.Key — NOT NULL
- drug_concept_id — INT
- drug_exposure_start_date — DATE
- drug_exposure_start_datetime — DATETIME
- drug_exposure_end_date — DATE
- drug_exposure_end_datetime — DATETIME
- verbatim_end_date — DATE
- drug_type_concept_id — INT
- stop_reason — VARCHAR(20)
- refills — INT
- quantity — INT
- days_supply — INT
- sig — TEXT
- route_concept_id — INT
- lot_number — VARCHAR(50)
- provider_id — BIGINT
- visit_detail_id — BIGINT
- drug_source_value — VARCHAR(50)
- drug_source_concept_id — INT
- route_source_value — VARCHAR(50)
- dose_unit_source_value — VARCHAR(50)
person (Untitled)
- Person id (person_id) — BIGINT — Primary key — NOT NULL
- gender_concept_id — INT
- year_of_birth — INT
- month_of_birth — INT
- day_of_birth — INT
- birth_datetime — DATETIME
- race_concept_id — INT
- ethnicity_concept_id — INT
- location_id — BIGINT
- provider_id — BIGINT
- care_site_id — BIGINT
- person_source_value — VARCHAR(50)
- gender_source_value — VARCHAR(50)
- gender_source_concept_id — INT
- race_source_value — VARCHAR(50)
- race_source_concept_id — INT
- ethnicity_source_value — VARCHAR(50)
- ethnicity_source_concept_id — INT
visit_occurrence (Untitled2)
- Key (visit_occurrence_id) — BIGINT — Primary key — NOT NULL
- person_id (Key) — BIGINT — Foreign key → person.Person id — NOT NULL
- visit_concept_id — INT
- visit_start_date — DATE
- visit_start_datetime — DATETIME
- visit_end_time — DATE
- visit_end_datetime — DATETIME
- visit_type_concept_id — INT
- provider_id — BIGINT
- care_site_id — BIGINT
- visit_source_value — VARCHAR(50)
- visit_source_concept_id — INT
- admitted_from_concept_id — INT
- admitted_from_source_value — VARCHAR(50)
- discharge_to_source_value — VARCHAR(50)
- discharge_to_concept_id — INT
- preceding_visit_occurrence_id — BIGINT