dbms table_catalog table_schema table_name column_name ordinal_position data_type character_maximum_length constraint_type table_schema table_name column_name postgresql vocabularyv5 cdmv54 observation provider_id 12 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 measurement provider_id 14 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 note provider_id 11 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 device_exposure provider_id 12 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 procedure_occurrence provider_id 11 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 drug_exposure provider_id 17 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 condition_occurrence provider_id 11 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 visit_detail provider_id 9 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 visit_occurrence provider_id 9 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 person provider_id 10 integer FOREIGN KEY cdmv54 provider provider_id postgresql vocabularyv5 cdmv54 episode_event episode_id 1 bigint FOREIGN KEY cdmv54 episode episode_id postgresql vocabularyv5 cdmv54 concept_relationship relationship_id 3 character varying 20 FOREIGN KEY cdmv54 relationship relationship_id postgresql vocabularyv5 cdmv54 provider care_site_id 6 integer FOREIGN KEY cdmv54 care_site care_site_id postgresql vocabularyv5 cdmv54 visit_detail care_site_id 10 integer FOREIGN KEY cdmv54 care_site care_site_id postgresql vocabularyv5 cdmv54 visit_occurrence care_site_id 10 integer FOREIGN KEY cdmv54 care_site care_site_id postgresql vocabularyv5 cdmv54 person care_site_id 11 integer FOREIGN KEY cdmv54 care_site care_site_id postgresql vocabularyv5 cdmv54 care_site location_id 4 integer FOREIGN KEY cdmv54 location location_id postgresql vocabularyv5 cdmv54 person location_id 9 integer FOREIGN KEY cdmv54 location location_id postgresql vocabularyv5 cdmv54 concept concept_class_id 5 character varying 20 FOREIGN KEY cdmv54 concept_class concept_class_id postgresql vocabularyv5 cdmv54 observation visit_occurrence_id 13 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 measurement visit_occurrence_id 15 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 note visit_occurrence_id 12 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 device_exposure visit_occurrence_id 13 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 procedure_occurrence visit_occurrence_id 12 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 drug_exposure visit_occurrence_id 18 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 condition_occurrence visit_occurrence_id 12 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 visit_detail visit_occurrence_id 19 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 visit_occurrence preceding_visit_occurrence_id 17 integer FOREIGN KEY cdmv54 visit_occurrence visit_occurrence_id postgresql vocabularyv5 cdmv54 observation visit_detail_id 14 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 measurement visit_detail_id 16 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 note visit_detail_id 13 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 device_exposure visit_detail_id 14 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 procedure_occurrence visit_detail_id 13 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 drug_exposure visit_detail_id 19 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 condition_occurrence visit_detail_id 13 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 visit_detail preceding_visit_detail_id 17 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 visit_detail parent_visit_detail_id 18 integer FOREIGN KEY cdmv54 visit_detail visit_detail_id postgresql vocabularyv5 cdmv54 source_to_concept_map target_vocabulary_id 6 character varying 20 FOREIGN KEY cdmv54 vocabulary vocabulary_id postgresql vocabularyv5 cdmv54 concept vocabulary_id 4 character varying 20 FOREIGN KEY cdmv54 vocabulary vocabulary_id postgresql vocabularyv5 cdmv54 observation person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 measurement person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 specimen person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 note person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 death person_id 1 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 drug_era person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 episode person_id 2 bigint FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 condition_era person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 dose_era person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 payer_plan_period person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 device_exposure person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 procedure_occurrence person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 drug_exposure person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 condition_occurrence person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 visit_detail person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 visit_occurrence person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 observation_period person_id 2 integer FOREIGN KEY cdmv54 person person_id postgresql vocabularyv5 cdmv54 cohort_definition cohort_definition_id 1 integer FOREIGN KEY cdmv54 cohort cohort_definition_id postgresql vocabularyv5 cdmv54 fact_relationship domain_concept_id_1 1 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 fact_relationship domain_concept_id_2 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 fact_relationship relationship_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation observation_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation observation_type_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation value_as_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation qualifier_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation unit_concept_id 11 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation observation_source_concept_id 16 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation obs_event_field_concept_id 21 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement measurement_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement measurement_type_concept_id 7 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement operator_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement value_as_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement unit_concept_id 11 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement measurement_source_concept_id 18 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement unit_source_concept_id 20 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 measurement meas_event_field_concept_id 23 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 specimen specimen_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 specimen specimen_type_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 specimen unit_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 specimen anatomic_site_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 specimen disease_status_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note_nlp section_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note_nlp note_nlp_concept_id 7 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note_nlp note_nlp_source_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note note_type_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note note_class_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note encoding_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note language_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 note note_event_field_concept_id 16 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 death death_type_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 death cause_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 death cause_source_concept_id 7 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_era drug_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_ancestor ancestor_concept_id 1 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_ancestor descendant_concept_id 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cohort_definition definition_type_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cohort_definition subject_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_strength drug_concept_id 1 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_strength ingredient_concept_id 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_strength amount_unit_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_strength numerator_unit_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_strength denominator_unit_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 source_to_concept_map source_concept_id 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 source_to_concept_map target_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_synonym concept_id 1 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_synonym language_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_relationship concept_id_1 1 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_relationship concept_id_2 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 relationship relationship_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 concept_class concept_class_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cdm_source cdm_version_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 metadata metadata_concept_id 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 metadata metadata_type_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 metadata value_as_concept_id 6 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 episode_event episode_event_field_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 episode episode_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 episode episode_object_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 episode episode_type_concept_id 11 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 episode episode_source_concept_id 13 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 condition_era condition_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cost cost_type_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cost currency_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cost revenue_code_concept_id 19 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cost drg_concept_id 21 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 domain domain_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 vocabulary vocabulary_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 dose_era drug_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 dose_era unit_concept_id 4 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period payer_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period payer_source_concept_id 7 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period plan_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period plan_source_concept_id 10 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period sponsor_concept_id 11 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period sponsor_source_concept_id 13 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period stop_reason_concept_id 15 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 payer_plan_period stop_reason_source_concept_id 17 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 care_site place_of_service_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 provider specialty_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 provider gender_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 provider specialty_source_concept_id 11 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 provider gender_source_concept_id 13 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 location country_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 device_exposure device_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 device_exposure device_type_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 device_exposure device_source_concept_id 16 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 device_exposure unit_concept_id 17 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 device_exposure unit_source_concept_id 19 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_type_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 procedure_occurrence modifier_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_source_concept_id 15 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_exposure drug_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_exposure drug_type_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_exposure route_concept_id 15 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 drug_exposure drug_source_concept_id 21 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 condition_occurrence condition_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 condition_occurrence condition_type_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 condition_occurrence condition_status_concept_id 9 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 condition_occurrence condition_source_concept_id 15 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_detail visit_detail_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_detail visit_detail_type_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_detail visit_detail_source_concept_id 12 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_detail admitted_from_concept_id 13 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_detail discharged_to_concept_id 16 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_occurrence visit_concept_id 3 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_occurrence visit_type_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_occurrence visit_source_concept_id 12 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_occurrence admitted_from_concept_id 13 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 visit_occurrence discharged_to_concept_id 15 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 observation_period period_type_concept_id 5 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person race_concept_id 7 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person ethnicity_concept_id 8 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person gender_source_concept_id 14 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person race_source_concept_id 16 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person ethnicity_source_concept_id 18 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 person gender_concept_id 2 integer FOREIGN KEY cdmv54 concept concept_id postgresql vocabularyv5 cdmv54 cost cost_domain_id 3 character varying 20 FOREIGN KEY cdmv54 domain domain_id postgresql vocabularyv5 cdmv54 concept domain_id 3 character varying 20 FOREIGN KEY cdmv54 domain domain_id postgresql vocabularyv5 cdmv54 observation observation_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 measurement measurement_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 specimen specimen_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 note_nlp note_nlp_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 note note_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 drug_era drug_era_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 cohort cohort_definition_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 relationship relationship_id 1 character varying 20 PRIMARY KEY postgresql vocabularyv5 cdmv54 concept_class concept_class_id 1 character varying 20 PRIMARY KEY postgresql vocabularyv5 cdmv54 metadata metadata_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 episode episode_id 1 bigint PRIMARY KEY postgresql vocabularyv5 cdmv54 condition_era condition_era_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 cost cost_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 domain domain_id 1 character varying 20 PRIMARY KEY postgresql vocabularyv5 cdmv54 concept concept_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 vocabulary vocabulary_id 1 character varying 20 PRIMARY KEY postgresql vocabularyv5 cdmv54 dose_era dose_era_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 payer_plan_period payer_plan_period_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 care_site care_site_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 provider provider_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 location location_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 device_exposure device_exposure_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_occurrence_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 drug_exposure drug_exposure_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 condition_occurrence condition_occurrence_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 visit_detail visit_detail_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 visit_occurrence visit_occurrence_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 observation_period observation_period_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 person person_id 1 integer PRIMARY KEY postgresql vocabularyv5 cdmv54 fact_relationship fact_id_2 4 integer postgresql vocabularyv5 cdmv54 death death_datetime 3 timestamp without time zone postgresql vocabularyv5 cdmv54 observation unit_source_value 17 character varying 50 postgresql vocabularyv5 cdmv54 note note_title 7 character varying 250 postgresql vocabularyv5 cdmv54 visit_detail discharged_to_source_value 15 character varying 50 postgresql vocabularyv5 cdmv54 person gender_source_value 13 character varying 50 postgresql vocabularyv5 cdmv54 measurement measurement_event_id 22 bigint postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 person year_of_birth 3 integer postgresql vocabularyv5 cdmv54 note note_date 3 date postgresql vocabularyv5 cdmv54 cost paid_dispensing_fee 16 numeric postgresql vocabularyv5 cdmv54 vocabulary vocabulary_reference 3 character varying 255 postgresql vocabularyv5 cdmv54 drug_strength valid_end_date 11 date postgresql vocabularyv5 cdmv54 concept_relationship valid_end_date 5 date postgresql vocabularyv5 cdmv54 drug_era gap_days 7 integer postgresql vocabularyv5 cdmv54 care_site care_site_source_value 5 character varying 50 postgresql vocabularyv5 cdmv54 concept_ancestor max_levels_of_separation 4 integer postgresql vocabularyv5 cdmv54 cost total_paid 8 numeric postgresql vocabularyv5 cdmv54 visit_occurrence visit_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 episode episode_parent_id 8 bigint postgresql vocabularyv5 cdmv54 cdm_source cdm_release_date 8 date postgresql vocabularyv5 cdmv54 cost paid_patient_copay 11 numeric postgresql vocabularyv5 cdmv54 drug_exposure stop_reason 10 character varying 20 postgresql vocabularyv5 cdmv54 measurement measurement_source_value 17 character varying 50 postgresql vocabularyv5 cdmv54 person ethnicity_source_value 17 character varying 50 postgresql vocabularyv5 cdmv54 location city 4 character varying 50 postgresql vocabularyv5 cdmv54 location state 5 character varying 2 postgresql vocabularyv5 cdmv54 person day_of_birth 5 integer postgresql vocabularyv5 cdmv54 note_nlp term_temporal 13 character varying 50 postgresql vocabularyv5 cdmv54 specimen quantity 7 numeric postgresql vocabularyv5 cdmv54 visit_occurrence visit_start_date 4 date postgresql vocabularyv5 cdmv54 concept_class concept_class_name 2 character varying 255 postgresql vocabularyv5 cdmv54 drug_exposure refills 11 integer postgresql vocabularyv5 cdmv54 cost revenue_code_source_value 20 character varying 50 postgresql vocabularyv5 cdmv54 cdm_source source_release_date 7 date postgresql vocabularyv5 cdmv54 dose_era dose_era_end_date 7 timestamp without time zone postgresql vocabularyv5 cdmv54 fact_relationship fact_id_1 2 integer postgresql vocabularyv5 cdmv54 drug_era drug_era_start_date 4 timestamp without time zone postgresql vocabularyv5 cdmv54 device_exposure device_exposure_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 person month_of_birth 4 integer postgresql vocabularyv5 cdmv54 device_exposure device_source_value 15 character varying 50 postgresql vocabularyv5 cdmv54 location location_source_value 8 character varying 50 postgresql vocabularyv5 cdmv54 drug_exposure days_supply 13 integer postgresql vocabularyv5 cdmv54 metadata value_as_number 7 numeric postgresql vocabularyv5 cdmv54 cost drg_source_value 22 character varying 3 postgresql vocabularyv5 cdmv54 payer_plan_period stop_reason_source_value 16 character varying 50 postgresql vocabularyv5 cdmv54 concept standard_concept 6 character varying 1 postgresql vocabularyv5 cdmv54 condition_occurrence condition_end_date 6 date postgresql vocabularyv5 cdmv54 cohort_definition cohort_initiation_date 7 date postgresql vocabularyv5 cdmv54 condition_occurrence condition_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 observation value_as_number 7 numeric postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_date 4 date postgresql vocabularyv5 cdmv54 visit_detail visit_detail_end_date 6 date postgresql vocabularyv5 cdmv54 cohort cohort_end_date 4 date postgresql vocabularyv5 cdmv54 concept concept_name 2 character varying 255 postgresql vocabularyv5 cdmv54 drug_exposure drug_exposure_end_date 6 date postgresql vocabularyv5 cdmv54 cohort subject_id 2 integer postgresql vocabularyv5 cdmv54 drug_exposure drug_source_value 20 character varying 50 postgresql vocabularyv5 cdmv54 payer_plan_period payer_plan_period_end_date 4 date postgresql vocabularyv5 cdmv54 payer_plan_period payer_source_value 6 character varying 50 postgresql vocabularyv5 cdmv54 drug_exposure dose_unit_source_value 23 character varying 50 postgresql vocabularyv5 cdmv54 drug_exposure sig 14 text postgresql vocabularyv5 cdmv54 episode episode_source_value 12 character varying 50 postgresql vocabularyv5 cdmv54 location address_1 2 character varying 50 postgresql vocabularyv5 cdmv54 metadata metadata_date 8 date postgresql vocabularyv5 cdmv54 condition_occurrence condition_status_source_value 16 character varying 50 postgresql vocabularyv5 cdmv54 cost cost_event_id 2 integer postgresql vocabularyv5 cdmv54 cohort_definition cohort_definition_description 3 text postgresql vocabularyv5 cdmv54 visit_detail visit_detail_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 provider npi 3 character varying 20 postgresql vocabularyv5 cdmv54 cohort cohort_start_date 3 date postgresql vocabularyv5 cdmv54 condition_occurrence condition_start_date 4 date postgresql vocabularyv5 cdmv54 episode episode_number 9 integer postgresql vocabularyv5 cdmv54 provider provider_source_value 9 character varying 50 postgresql vocabularyv5 cdmv54 observation value_as_string 8 character varying 60 postgresql vocabularyv5 cdmv54 relationship relationship_name 2 character varying 255 postgresql vocabularyv5 cdmv54 metadata value_as_string 5 character varying 250 postgresql vocabularyv5 cdmv54 cdm_source cdm_version 9 character varying 10 postgresql vocabularyv5 cdmv54 concept_ancestor min_levels_of_separation 3 integer postgresql vocabularyv5 cdmv54 drug_strength amount_value 3 numeric postgresql vocabularyv5 cdmv54 condition_occurrence condition_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 drug_strength invalid_reason 12 character varying 1 postgresql vocabularyv5 cdmv54 metadata name 4 character varying 250 postgresql vocabularyv5 cdmv54 concept_relationship invalid_reason 6 character varying 1 postgresql vocabularyv5 cdmv54 location longitude 12 numeric postgresql vocabularyv5 cdmv54 drug_exposure quantity 12 numeric postgresql vocabularyv5 cdmv54 note_nlp note_id 2 integer postgresql vocabularyv5 cdmv54 specimen specimen_date 5 date postgresql vocabularyv5 cdmv54 device_exposure device_exposure_start_date 4 date postgresql vocabularyv5 cdmv54 payer_plan_period sponsor_source_value 12 character varying 50 postgresql vocabularyv5 cdmv54 device_exposure production_id 10 character varying 255 postgresql vocabularyv5 cdmv54 dose_era dose_value 5 numeric postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 visit_occurrence visit_end_date 6 date postgresql vocabularyv5 cdmv54 measurement value_source_value 21 character varying 50 postgresql vocabularyv5 cdmv54 note_nlp term_modifiers 14 character varying 2000 postgresql vocabularyv5 cdmv54 location latitude 11 numeric postgresql vocabularyv5 cdmv54 death cause_source_value 6 character varying 50 postgresql vocabularyv5 cdmv54 observation_period observation_period_end_date 4 date postgresql vocabularyv5 cdmv54 payer_plan_period family_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 metadata metadata_datetime 9 timestamp without time zone postgresql vocabularyv5 cdmv54 note note_text 8 text postgresql vocabularyv5 cdmv54 cost total_charge 6 numeric postgresql vocabularyv5 cdmv54 specimen unit_source_value 13 character varying 50 postgresql vocabularyv5 cdmv54 relationship is_hierarchical 3 character varying 1 postgresql vocabularyv5 cdmv54 episode episode_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 drug_strength box_size 9 integer postgresql vocabularyv5 cdmv54 location address_2 3 character varying 50 postgresql vocabularyv5 cdmv54 drug_strength valid_start_date 10 date postgresql vocabularyv5 cdmv54 drug_exposure lot_number 16 character varying 50 postgresql vocabularyv5 cdmv54 concept_relationship valid_start_date 4 date postgresql vocabularyv5 cdmv54 drug_exposure verbatim_end_date 8 date postgresql vocabularyv5 cdmv54 source_to_concept_map source_vocabulary_id 3 character varying 20 postgresql vocabularyv5 cdmv54 condition_occurrence stop_reason 10 character varying 20 postgresql vocabularyv5 cdmv54 condition_occurrence condition_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 cdm_source cdm_etl_reference 6 character varying 255 postgresql vocabularyv5 cdmv54 drug_era drug_era_end_date 5 timestamp without time zone postgresql vocabularyv5 cdmv54 visit_occurrence discharged_to_source_value 16 character varying 50 postgresql vocabularyv5 cdmv54 care_site place_of_service_source_value 6 character varying 50 postgresql vocabularyv5 cdmv54 observation observation_date 4 date postgresql vocabularyv5 cdmv54 measurement range_low 12 numeric postgresql vocabularyv5 cdmv54 cdm_source vocabulary_version 11 character varying 20 postgresql vocabularyv5 cdmv54 observation observation_event_id 20 bigint postgresql vocabularyv5 cdmv54 concept invalid_reason 10 character varying 1 postgresql vocabularyv5 cdmv54 visit_detail visit_detail_source_value 11 character varying 50 postgresql vocabularyv5 cdmv54 cost total_cost 7 numeric postgresql vocabularyv5 cdmv54 condition_era condition_era_start_date 4 timestamp without time zone postgresql vocabularyv5 cdmv54 cdm_source cdm_holder 3 character varying 255 postgresql vocabularyv5 cdmv54 note_nlp offset 5 character varying 50 postgresql vocabularyv5 cdmv54 note_nlp lexical_variant 6 character varying 250 postgresql vocabularyv5 cdmv54 specimen disease_status_source_value 15 character varying 50 postgresql vocabularyv5 cdmv54 measurement measurement_time 6 character varying 10 postgresql vocabularyv5 cdmv54 note note_event_id 15 bigint postgresql vocabularyv5 cdmv54 note_nlp nlp_date 10 date postgresql vocabularyv5 cdmv54 observation observation_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 device_exposure unique_device_id 9 character varying 255 postgresql vocabularyv5 cdmv54 visit_detail admitted_from_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 device_exposure device_exposure_end_date 6 date postgresql vocabularyv5 cdmv54 cost paid_ingredient_cost 15 numeric postgresql vocabularyv5 cdmv54 specimen specimen_datetime 6 timestamp without time zone postgresql vocabularyv5 cdmv54 cohort_definition cohort_definition_name 2 character varying 255 postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 device_exposure unit_source_value 18 character varying 50 postgresql vocabularyv5 cdmv54 provider provider_name 2 character varying 255 postgresql vocabularyv5 cdmv54 source_to_concept_map invalid_reason 9 character varying 1 postgresql vocabularyv5 cdmv54 care_site care_site_name 2 character varying 255 postgresql vocabularyv5 cdmv54 cost paid_patient_deductible 13 numeric postgresql vocabularyv5 cdmv54 dose_era dose_era_start_date 6 timestamp without time zone postgresql vocabularyv5 cdmv54 concept concept_code 7 character varying 50 postgresql vocabularyv5 cdmv54 cdm_source cdm_source_abbreviation 2 character varying 25 postgresql vocabularyv5 cdmv54 procedure_occurrence procedure_end_date 6 date postgresql vocabularyv5 cdmv54 death death_date 2 date postgresql vocabularyv5 cdmv54 concept valid_start_date 8 date postgresql vocabularyv5 cdmv54 episode episode_end_date 6 date postgresql vocabularyv5 cdmv54 note note_datetime 4 timestamp without time zone postgresql vocabularyv5 cdmv54 note_nlp term_exists 12 character varying 1 postgresql vocabularyv5 cdmv54 cost amount_allowed 18 numeric postgresql vocabularyv5 cdmv54 drug_era drug_exposure_count 6 integer postgresql vocabularyv5 cdmv54 cohort_definition cohort_definition_syntax 5 text postgresql vocabularyv5 cdmv54 person birth_datetime 6 timestamp without time zone postgresql vocabularyv5 cdmv54 observation_period observation_period_start_date 3 date postgresql vocabularyv5 cdmv54 drug_exposure route_source_value 22 character varying 50 postgresql vocabularyv5 cdmv54 cdm_source source_documentation_reference 5 character varying 255 postgresql vocabularyv5 cdmv54 visit_occurrence visit_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 observation value_source_value 19 character varying 50 postgresql vocabularyv5 cdmv54 provider year_of_birth 7 integer postgresql vocabularyv5 cdmv54 cost paid_by_primary 14 numeric postgresql vocabularyv5 cdmv54 provider gender_source_value 12 character varying 50 postgresql vocabularyv5 cdmv54 specimen anatomic_site_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 source_to_concept_map valid_start_date 7 date postgresql vocabularyv5 cdmv54 source_to_concept_map valid_end_date 8 date postgresql vocabularyv5 cdmv54 note_nlp nlp_datetime 11 timestamp without time zone postgresql vocabularyv5 cdmv54 note_nlp nlp_system 9 character varying 250 postgresql vocabularyv5 cdmv54 location zip 6 character varying 9 postgresql vocabularyv5 cdmv54 cdm_source cdm_source_name 1 character varying 255 postgresql vocabularyv5 cdmv54 provider specialty_source_value 10 character varying 50 postgresql vocabularyv5 cdmv54 measurement measurement_date 4 date postgresql vocabularyv5 cdmv54 specimen specimen_source_value 12 character varying 50 postgresql vocabularyv5 cdmv54 relationship reverse_relationship_id 5 character varying 20 postgresql vocabularyv5 cdmv54 drug_exposure drug_exposure_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 condition_era condition_era_end_date 5 timestamp without time zone postgresql vocabularyv5 cdmv54 procedure_occurrence modifier_source_value 16 character varying 50 postgresql vocabularyv5 cdmv54 person person_source_value 12 character varying 50 postgresql vocabularyv5 cdmv54 device_exposure device_exposure_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 source_to_concept_map source_code 1 character varying 50 postgresql vocabularyv5 cdmv54 visit_detail visit_detail_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 cost paid_patient_coinsurance 12 numeric postgresql vocabularyv5 cdmv54 cost payer_plan_period_id 17 integer postgresql vocabularyv5 cdmv54 concept valid_end_date 9 date postgresql vocabularyv5 cdmv54 drug_exposure drug_exposure_start_date 4 date postgresql vocabularyv5 cdmv54 measurement measurement_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 specimen specimen_source_id 11 character varying 50 postgresql vocabularyv5 cdmv54 vocabulary vocabulary_version 4 character varying 255 postgresql vocabularyv5 cdmv54 drug_strength numerator_value 5 numeric postgresql vocabularyv5 cdmv54 measurement unit_source_value 19 character varying 50 postgresql vocabularyv5 cdmv54 episode episode_start_datetime 5 timestamp without time zone postgresql vocabularyv5 cdmv54 drug_strength denominator_value 7 numeric postgresql vocabularyv5 cdmv54 relationship defines_ancestry 4 character varying 1 postgresql vocabularyv5 cdmv54 cost paid_by_payer 9 numeric postgresql vocabularyv5 cdmv54 payer_plan_period payer_plan_period_start_date 3 date postgresql vocabularyv5 cdmv54 measurement value_as_number 9 numeric postgresql vocabularyv5 cdmv54 note_nlp snippet 4 character varying 250 postgresql vocabularyv5 cdmv54 domain domain_name 2 character varying 255 postgresql vocabularyv5 cdmv54 cdm_source source_description 4 text postgresql vocabularyv5 cdmv54 visit_detail visit_detail_start_date 4 date postgresql vocabularyv5 cdmv54 observation observation_source_value 15 character varying 50 postgresql vocabularyv5 cdmv54 observation qualifier_source_value 18 character varying 50 postgresql vocabularyv5 cdmv54 cost paid_by_patient 10 numeric postgresql vocabularyv5 cdmv54 measurement range_high 13 numeric postgresql vocabularyv5 cdmv54 visit_occurrence admitted_from_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 source_to_concept_map source_code_description 4 character varying 255 postgresql vocabularyv5 cdmv54 location country_source_value 10 character varying 80 postgresql vocabularyv5 cdmv54 provider dea 4 character varying 20 postgresql vocabularyv5 cdmv54 person race_source_value 15 character varying 50 postgresql vocabularyv5 cdmv54 location county 7 character varying 20 postgresql vocabularyv5 cdmv54 episode episode_start_date 4 date postgresql vocabularyv5 cdmv54 concept_synonym concept_synonym_name 2 character varying 1000 postgresql vocabularyv5 cdmv54 condition_era condition_occurrence_count 6 integer postgresql vocabularyv5 cdmv54 procedure_occurrence quantity 10 integer postgresql vocabularyv5 cdmv54 episode_event event_id 2 bigint postgresql vocabularyv5 cdmv54 vocabulary vocabulary_name 2 character varying 255 postgresql vocabularyv5 cdmv54 device_exposure quantity 11 integer postgresql vocabularyv5 cdmv54 drug_exposure drug_exposure_end_datetime 7 timestamp without time zone postgresql vocabularyv5 cdmv54 note note_source_value 14 character varying 50 postgresql vocabularyv5 cdmv54 visit_occurrence visit_source_value 11 character varying 50 postgresql vocabularyv5 cdmv54 payer_plan_period plan_source_value 9 character varying 50