User Tools

Site Tools


omop_cdm_bigquery_to_postgress_extraction

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
omop_cdm_bigquery_to_postgress_extraction [2020/06/26 12:33]
podalv
omop_cdm_bigquery_to_postgress_extraction [2020/06/26 12:35] (current)
podalv
Line 183: Line 183:
 create table source_to_concept_map(source_code varchar,​source_concept_id bigint,​source_vocabulary_id varchar,​source_code_description varchar,​target_concept_id bigint,​target_vocabulary_id varchar,​valid_start_DATE date,​valid_end_DATE date,​invalid_reason varchar, load_table_id varchar, load_row_id bigint); create table source_to_concept_map(source_code varchar,​source_concept_id bigint,​source_vocabulary_id varchar,​source_code_description varchar,​target_concept_id bigint,​target_vocabulary_id varchar,​valid_start_DATE date,​valid_end_DATE date,​invalid_reason varchar, load_table_id varchar, load_row_id bigint);
 create table specimen(specimen_id bigint,​person_id bigint,​specimen_concept_id bigint,​specimen_type_concept_id bigint,​specimen_DATE date,​specimen_DATETIME timestamp,​quantity decimal,​unit_concept_id bigint,​anatomic_site_concept_id bigint,​disease_status_concept_id bigint,​specimen_source_id bigint,​specimen_source_value varchar,​unit_source_value varchar,​anatomic_site_source_value varchar,​disease_status_source_value varchar); create table specimen(specimen_id bigint,​person_id bigint,​specimen_concept_id bigint,​specimen_type_concept_id bigint,​specimen_DATE date,​specimen_DATETIME timestamp,​quantity decimal,​unit_concept_id bigint,​anatomic_site_concept_id bigint,​disease_status_concept_id bigint,​specimen_source_id bigint,​specimen_source_value varchar,​unit_source_value varchar,​anatomic_site_source_value varchar,​disease_status_source_value varchar);
-create table visit_detail(visit_detail_id bigint,​person_id bigint,​visit_detail_concept_id bigint,​visit_detail_start_DATE date,​visit_detail_start_DATETIME timestamp,​visit_detail_end_DATE date,​visit_detail_end_DATETIME timestamp,​visit_detail_type_concept_id bigint,​provider_id bigint,​care_site_id bigint,​admitting_source_concept_id bigint,​discharge_to_concept_id bigint,​preceding_visit_detail_id bigint,​visit_detail_source_value varchar,​visit_detail_source_concept_id bigint,​admitting_source_value varchar,​discharge_to_source_value varchar,​visit_detail_parent_id bigint,​visit_occurrence_id bigint,unit_id ​varchar, unit_id varchar, load_table_id varchar);+create table visit_detail(visit_detail_id bigint,​person_id bigint,​visit_detail_concept_id bigint,​visit_detail_start_DATE date,​visit_detail_start_DATETIME timestamp,​visit_detail_end_DATE date,​visit_detail_end_DATETIME timestamp,​visit_detail_type_concept_id bigint,​provider_id bigint,​care_site_id bigint,​admitting_source_concept_id bigint,​discharge_to_concept_id bigint,​preceding_visit_detail_id bigint,​visit_detail_source_value varchar,​visit_detail_source_concept_id bigint,​admitting_source_value varchar,​discharge_to_source_value varchar,​visit_detail_parent_id bigint,​visit_occurrence_id bigint,trace_id ​varchar, unit_id varchar, load_table_id varchar);
 create table visit_occurrence(visit_occurrence_id bigint not null,​person_id bigint not null,​visit_concept_id bigint not null,​visit_start_DATE date not null,​visit_start_DATETIME timestamp,​visit_end_DATE date not null,​visit_end_DATETIME timestamp,​visit_type_concept_id bigint not null,​provider_id bigint,​care_site_id bigint,​visit_source_value varchar,​visit_source_concept_id bigint,​admitting_source_concept_id bigint,​admitting_source_value varchar,​discharge_to_concept_id bigint,​discharge_to_source_value varchar,​preceding_visit_occurrence_id bigint,​trace_id varchar,​unit_id varchar,​load_table_id varchar); create table visit_occurrence(visit_occurrence_id bigint not null,​person_id bigint not null,​visit_concept_id bigint not null,​visit_start_DATE date not null,​visit_start_DATETIME timestamp,​visit_end_DATE date not null,​visit_end_DATETIME timestamp,​visit_type_concept_id bigint not null,​provider_id bigint,​care_site_id bigint,​visit_source_value varchar,​visit_source_concept_id bigint,​admitting_source_concept_id bigint,​admitting_source_value varchar,​discharge_to_concept_id bigint,​discharge_to_source_value varchar,​preceding_visit_occurrence_id bigint,​trace_id varchar,​unit_id varchar,​load_table_id varchar);
 create table vocabulary(vocabulary_id varchar not null,​vocabulary_name varchar not null,​vocabulary_reference varchar not null,​vocabulary_version varchar,​vocabulary_concept_id bigint not null,​load_table_id varchar, load_row_id bigint); create table vocabulary(vocabulary_id varchar not null,​vocabulary_name varchar not null,​vocabulary_reference varchar not null,​vocabulary_version varchar,​vocabulary_concept_id bigint not null,​load_table_id varchar, load_row_id bigint);
omop_cdm_bigquery_to_postgress_extraction.txt · Last modified: 2020/06/26 12:35 by podalv