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