text: --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.cdm_source  (
    cdm_source_name					VARCHAR(255)	NOT NULL ,
    cdm_source_abbreviation			VARCHAR(25)		NULL ,
    cdm_holder						VARCHAR(255)	NULL ,
    source_description				VARCHAR(MAX)	NULL ,
    source_documentation_reference	VARCHAR(255)	NULL ,
    cdm_etl_reference					VARCHAR(255)	NULL ,
    source_release_date				DATE			NULL ,
    cdm_release_date					DATE			NULL ,
    cdm_version						VARCHAR(10)		NULL ,
    vocabulary_version				VARCHAR(20)		NULL
  )
  DISTSTYLE ALL;
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.metadata  (
    metadata_concept_id       INTEGER       NOT NULL ,
    metadata_type_concept_id  INTEGER       NOT NULL ,
    name                      VARCHAR(250)  NOT NULL ,
    value_as_string           VARCHAR(MAX)  NULL ,
    value_as_concept_id       INTEGER       NULL ,
    metadata_date             DATE          NULL ,
    metadata_datetime         TIMESTAMP     NULL
  )
  DISTSTYLE ALL;
  
  INSERT INTO metadata (metadata_concept_id, metadata_type_concept_id, name, value_as_string, value_as_concept_id, metadata_date, metadata_datetime)
  VALUES (0, 0, 'CDM Version', '6.0', 0, NULL, NULL)
  ;
  
  
  /************************
  
  Standardized clinical data
  
  ************************/
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.person  (
    person_id						BIGINT	  		NOT NULL ,
    gender_concept_id				INTEGER	  		NOT NULL ,
    year_of_birth					INTEGER	  		NOT NULL ,
    month_of_birth				INTEGER	  		NULL,
    day_of_birth					INTEGER	  		NULL,
    birth_datetime				TIMESTAMP	  	NULL,
    death_datetime				TIMESTAMP		NULL,
    race_concept_id				INTEGER		  	NOT NULL,
    ethnicity_concept_id			INTEGER	  		NOT NULL,
    location_id					BIGINT		 	NULL,
    provider_id					BIGINT		  	NULL,
    care_site_id					BIGINT		  	NULL,
    person_source_value			VARCHAR(50)		NULL,
    gender_source_value			VARCHAR(50)		NULL,
    gender_source_concept_id	  	INTEGER		  	NOT NULL,
    race_source_value				VARCHAR(50) 	NULL,
    race_source_concept_id		INTEGER		  	NOT NULL,
    ethnicity_source_value		VARCHAR(50) 	NULL,
    ethnicity_source_concept_id	INTEGER		  	NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.observation_period  (
    observation_period_id				BIGINT		NOT NULL ,
    person_id							BIGINT		NOT NULL ,
    observation_period_start_date		DATE		NOT NULL ,
    observation_period_end_date		DATE		NOT NULL ,
    period_type_concept_id			INTEGER		NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.specimen  (
    specimen_id					BIGINT			NOT NULL ,
    person_id						BIGINT			NOT NULL ,
    specimen_concept_id			INTEGER			NOT NULL ,
    specimen_type_concept_id		INTEGER			NOT NULL ,
    specimen_date					DATE			NULL ,
    specimen_datetime				TIMESTAMP		NOT NULL ,
    quantity						FLOAT			NULL ,
    unit_concept_id				INTEGER			NULL ,
    anatomic_site_concept_id		INTEGER			NOT NULL ,
    disease_status_concept_id		INTEGER			NOT NULL ,
    specimen_source_id			VARCHAR(50)		NULL ,
    specimen_source_value			VARCHAR(50)		NULL ,
    unit_source_value				VARCHAR(50)		NULL ,
    anatomic_site_source_value	VARCHAR(50)		NULL ,
    disease_status_source_value	VARCHAR(50)		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.visit_occurrence  (
    visit_occurrence_id			    BIGINT			NOT NULL ,
    person_id						    BIGINT			NOT NULL ,
    visit_concept_id				    INTEGER			NOT NULL ,
    visit_start_date				    DATE			NULL ,
    visit_start_datetime				TIMESTAMP		NOT NULL ,
    visit_end_date					DATE			NULL ,
    visit_end_datetime				TIMESTAMP		NOT NULL ,
    visit_type_concept_id			    INTEGER			NOT NULL ,
    provider_id					    BIGINT			NULL,
    care_site_id					    BIGINT			NULL,
    visit_source_value				VARCHAR(50)		NULL,
    visit_source_concept_id		    INTEGER			NOT NULL ,
    admitted_from_concept_id      	INTEGER     	NOT NULL ,   
    admitted_from_source_value    	VARCHAR(50) 	NULL ,
    discharge_to_source_value		  	VARCHAR(50)		NULL ,
    discharge_to_concept_id		    INTEGER   		NOT NULL ,
    preceding_visit_occurrence_id		BIGINT			NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.visit_detail  (
    visit_detail_id                    BIGINT      NOT NULL ,
    person_id                          BIGINT      NOT NULL ,
    visit_detail_concept_id            INTEGER     NOT NULL ,
    visit_detail_start_date            DATE        NULL ,
    visit_detail_start_datetime        TIMESTAMP   NOT NULL ,
    visit_detail_end_date              DATE        NULL ,
    visit_detail_end_datetime          TIMESTAMP   NOT NULL ,
    visit_detail_type_concept_id       INTEGER     NOT NULL ,
    provider_id                        BIGINT      NULL ,
    care_site_id                       BIGINT      NULL ,
    discharge_to_concept_id            INTEGER     NOT NULL ,
    admitted_from_concept_id           INTEGER     NOT NULL , 
    admitted_from_source_value         VARCHAR(50) NULL ,
    visit_detail_source_value          VARCHAR(50) NULL ,
    visit_detail_source_concept_id     INTEGER     NOT NULL ,
    discharge_to_source_value          VARCHAR(50) NULL ,
    preceding_visit_detail_id          BIGINT      NULL ,
    visit_detail_parent_id             BIGINT      NULL ,
    visit_occurrence_id                BIGINT      NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.procedure_occurrence  (
    procedure_occurrence_id		BIGINT			NOT NULL ,
    person_id						BIGINT			NOT NULL ,
    procedure_concept_id			INTEGER			NOT NULL ,
    procedure_date				DATE			NULL ,
    procedure_datetime			TIMESTAMP		NOT NULL ,
    procedure_type_concept_id		INTEGER			NOT NULL ,
    modifier_concept_id			INTEGER			NOT NULL ,
    quantity						INTEGER			NULL ,
    provider_id					BIGINT			NULL ,
    visit_occurrence_id			BIGINT			NULL ,
    visit_detail_id             	BIGINT	     	NULL ,
    procedure_source_value		VARCHAR(50)		NULL ,
    procedure_source_concept_id	INTEGER			NOT NULL ,
    modifier_source_value		    VARCHAR(50)		NULL 
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.drug_exposure  (
    drug_exposure_id				BIGINT			 	NOT NULL ,
    person_id						BIGINT			 	NOT NULL ,
    drug_concept_id				INTEGER			  	NOT NULL ,
    drug_exposure_start_date		DATE			    NULL ,
    drug_exposure_start_datetime	TIMESTAMP		 	NOT NULL ,
    drug_exposure_end_date		DATE			    NULL ,
    drug_exposure_end_datetime	TIMESTAMP		  	NOT NULL ,
    verbatim_end_date				DATE			    NULL ,
    drug_type_concept_id			INTEGER			  	NOT NULL ,
    stop_reason					VARCHAR(20)			NULL ,
    refills						INTEGER		  		NULL ,
    quantity						FLOAT			    NULL ,
    days_supply					INTEGER		  		NULL ,
    sig							TEXT				NULL ,
    route_concept_id				INTEGER				NOT NULL ,
    lot_number					VARCHAR(50)	 		NULL ,
    provider_id					BIGINT			  	NULL ,
    visit_occurrence_id			BIGINT			  	NULL ,
    visit_detail_id               BIGINT       		NULL ,
    drug_source_value				VARCHAR(50)	  		NULL ,
    drug_source_concept_id		INTEGER			  	NOT NULL ,
    route_source_value			VARCHAR(50)	  		NULL ,
    dose_unit_source_value		VARCHAR(50)	  		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.device_exposure  (
    device_exposure_id			    BIGINT		  	NOT NULL ,
    person_id						    BIGINT			NOT NULL ,
    device_concept_id			        INTEGER			NOT NULL ,
    device_exposure_start_date	    DATE			NULL ,
    device_exposure_start_datetime	TIMESTAMP		NOT NULL ,
    device_exposure_end_date		    DATE			NULL ,
    device_exposure_end_datetime    	TIMESTAMP		NULL ,
    device_type_concept_id		    INTEGER			NOT NULL ,
    unique_device_id			        VARCHAR(50)		NULL ,
    quantity						    INTEGER			NULL ,
    provider_id					    BIGINT			NULL ,
    visit_occurrence_id			    BIGINT			NULL ,
    visit_detail_id                 	BIGINT       	NULL ,
    device_source_value			    VARCHAR(100)	NULL ,
    device_source_concept_id		    INTEGER			NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.condition_occurrence  (
    condition_occurrence_id		    BIGINT			NOT NULL ,
    person_id						    BIGINT			NOT NULL ,
    condition_concept_id			    INTEGER			NOT NULL ,
    condition_start_date			    DATE			NULL ,
    condition_start_datetime		  	TIMESTAMP		NOT NULL ,
    condition_end_date			    DATE			NULL ,
    condition_end_datetime		    TIMESTAMP		NULL ,
    condition_type_concept_id		  	INTEGER			NOT NULL ,
    condition_status_concept_id	  	INTEGER			NOT NULL ,
    stop_reason					    VARCHAR(20)		NULL ,
    provider_id					    BIGINT			NULL ,
    visit_occurrence_id			    BIGINT			NULL ,
    visit_detail_id               	BIGINT     	NULL ,
    condition_source_value		    VARCHAR(50)		NULL ,
    condition_source_concept_id	  	INTEGER			NOT NULL ,
    condition_status_source_value		VARCHAR(50)		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.measurement  (
    measurement_id				BIGINT			NOT NULL ,
    person_id						BIGINT			NOT NULL ,
    measurement_concept_id		INTEGER			NOT NULL ,
    measurement_date				DATE			NULL ,
    measurement_datetime			TIMESTAMP		NOT NULL ,
    measurement_time              VARCHAR(10)		NULL,
    measurement_type_concept_id	INTEGER			NOT NULL ,
    operator_concept_id			INTEGER			NULL ,
    value_as_number				FLOAT			NULL ,
    value_as_concept_id			INTEGER			NULL ,
    unit_concept_id				INTEGER			NULL ,
    range_low					    FLOAT			NULL ,
    range_high					FLOAT			NULL ,
    provider_id					BIGINT			NULL ,
    visit_occurrence_id			BIGINT			NULL ,
    visit_detail_id               BIGINT	     	NULL ,
    measurement_source_value		VARCHAR(50)		NULL ,
    measurement_source_concept_id	INTEGER			NOT NULL ,
    unit_source_value				VARCHAR(50)		NULL ,
    value_source_value			VARCHAR(70)		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.note  (
    note_id						BIGINT			NOT NULL ,
    person_id						BIGINT			NOT NULL ,
    note_event_id         		BIGINT      	NULL , 
    note_event_field_concept_id	INTEGER			NOT NULL , 
    note_date						DATE			NULL ,
    note_datetime					TIMESTAMP		NOT NULL ,
    note_type_concept_id			INTEGER			NOT NULL ,
    note_class_concept_id 		INTEGER			NOT NULL ,
    note_title					VARCHAR(250)	NULL ,
    note_text						VARCHAR(MAX)	NULL ,
    encoding_concept_id			INTEGER			NOT NULL ,
    language_concept_id			INTEGER			NOT NULL ,
    provider_id					BIGINT			NULL ,
    visit_occurrence_id			BIGINT			NULL ,
    visit_detail_id       		BIGINT       	NULL ,
    note_source_value				VARCHAR(50)		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.note_nlp  (
    note_nlp_id					BIGINT			NOT NULL ,
    note_id						BIGINT			NOT NULL ,
    section_concept_id			INTEGER			NOT NULL ,
    snippet						VARCHAR(250)	NULL ,
    "offset"					    VARCHAR(250)	NULL ,
    lexical_variant				VARCHAR(250)	NOT NULL ,
    note_nlp_concept_id			INTEGER			NOT NULL ,
    nlp_system					VARCHAR(250)	NULL ,
    nlp_date						DATE			NOT NULL ,
    nlp_datetime					TIMESTAMP		NULL ,
    term_exists					VARCHAR(1)		NULL ,
    term_temporal					VARCHAR(50)		NULL ,
    term_modifiers				VARCHAR(2000)	NULL ,
    note_nlp_source_concept_id  	INTEGER			NOT NULL
  )
  DISTSTYLE ALL;
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.observation
   (observation_id					BIGINT			NOT NULL ,
    person_id						    BIGINT			NOT NULL ,
    observation_concept_id			INTEGER			NOT NULL ,
    observation_date				    DATE			NULL ,
    observation_datetime				TIMESTAMP		NOT NULL ,
    observation_type_concept_id	    INTEGER			NOT NULL ,
    value_as_number				    FLOAT			NULL ,
    value_as_string				    VARCHAR(60)		NULL ,
    value_as_concept_id			    INTEGER			NULL ,
    qualifier_concept_id			    INTEGER			NULL ,
    unit_concept_id				    INTEGER			NULL ,
    provider_id					    BIGINT			NULL ,
    visit_occurrence_id			    BIGINT			NULL ,
    visit_detail_id               	BIGINT      	NULL ,
    observation_source_value		  	VARCHAR(50)		NULL ,
    observation_source_concept_id		INTEGER			NOT NULL ,
    unit_source_value				   	VARCHAR(50)		NULL ,
    qualifier_source_value			VARCHAR(50)		NULL ,
    observation_event_id				BIGINT			NULL , 
    obs_event_field_concept_id		INTEGER			NOT NULL , 
    value_as_datetime					TIMESTAMP		NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE ON KEY(person_id)
  CREATE TABLE {sc}.survey_conduct (
    survey_conduct_id					BIGINT			NOT NULL ,
    person_id 						BIGINT			NOT NULL ,
    survey_concept_id			  		INTEGER			NOT NULL ,
    survey_start_date				    DATE			NULL ,
    survey_start_datetime				TIMESTAMP		NULL ,
    survey_end_date					DATE			NULL ,
    survey_end_datetime				TIMESTAMP		NOT NULL ,
    provider_id						BIGINT			NULL ,
    assisted_concept_id	  			INTEGER			NOT NULL ,
    respondent_type_concept_id		INTEGER			NOT NULL ,
    timing_concept_id					INTEGER			NOT NULL ,
    collection_method_concept_id		INTEGER			NOT NULL ,
    assisted_source_value		  		VARCHAR(50)		NULL ,
    respondent_type_source_value		VARCHAR(100)	NULL ,
    timing_source_value				VARCHAR(100)	NULL ,
    collection_method_source_value	VARCHAR(100)	NULL ,
    survey_source_value				VARCHAR(100)	NULL ,
    survey_source_concept_id			INTEGER			NOT NULL ,
    survey_source_identifier			VARCHAR(100)	NULL ,
    validated_survey_concept_id		INTEGER			NOT NULL ,
    validated_survey_source_value		VARCHAR(100)	NULL ,
    survey_version_number				VARCHAR(20)		NULL ,
    visit_occurrence_id				BIGINT			NULL ,
    visit_detail_id					BIGINT			NULL ,
    response_visit_occurrence_id		BIGINT			NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.fact_relationship  (
    domain_concept_id_1		INTEGER			NOT NULL ,
    fact_id_1					BIGINT			NOT NULL ,
    domain_concept_id_2		INTEGER			NOT NULL ,
    fact_id_2					BIGINT			NOT NULL ,
    relationship_concept_id	INTEGER			NOT NULL
  )
  DISTSTYLE ALL;
  
  
  
  /************************
  
  Standardized health system data
  
  ************************/
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.location
   (location_id				BIGINT			NOT NULL ,
    address_1					VARCHAR(50)		NULL ,
    address_2					VARCHAR(50)		NULL ,
    city						VARCHAR(50)		NULL ,
    state						VARCHAR(2)		NULL ,
    zip						VARCHAR(9)		NULL ,
    county					VARCHAR(20)		NULL ,
    country					VARCHAR(100)	NULL ,
    location_source_value		VARCHAR(50)		NULL ,
    latitude					FLOAT			NULL ,
    longitude					FLOAT			NULL
  )
  DISTSTYLE ALL;
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.location_history  (
    location_history_id           BIGINT      	NOT NULL ,
    location_id			        BIGINT		  	NOT NULL ,
    relationship_type_concept_id	INTEGER		  	NOT NULL ,  
    domain_id				        VARCHAR(50)		NOT NULL ,
    entity_id				        BIGINT			NOT NULL ,
    start_date			        DATE			NOT NULL ,
    end_date				        DATE			NULL
  )
  DISTSTYLE ALL;
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.care_site  (
    care_site_id						BIGINT			NOT NULL ,
    care_site_name					VARCHAR(255)	NULL ,
    place_of_service_concept_id	  	INTEGER			NOT NULL ,
    location_id						BIGINT			NULL ,
    care_site_source_value			VARCHAR(50)		NULL ,
    place_of_service_source_value		VARCHAR(50)		NULL
  )
  DISTSTYLE ALL;
  
  
  --HINT DISTRIBUTE ON RANDOM
  CREATE TABLE {sc}.provider  (
    provider_id					BIGINT			NOT NULL ,
    provider_name					VARCHAR(255)	NULL ,
    NPI							VARCHAR(20)		NULL ,
    DEA							VARCHAR(20)		NULL ,
    specialty_concept_id			INTEGER			NOT NULL ,
    care_site_id					BIGINT			NULL ,
    year_of_birth					INTEGER			NULL ,
    gender_concept_id				INTEGER			NOT NULL ,
    provider_source_value			VARCHAR(50)		NULL ,
    specialty_source_value		VARCHAR(50)		NULL ,
    specialty_source_concept_id	INTEGER			NULL ,
    gender_source_value			VARCHAR(50)		NULL ,
    gender_source_concept_id		INTEGER			NOT NULL
  )
  DISTSTYLE ALL;
  
  
  /************************
  
  Standardized health economics
  
  ************************/
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.payer_plan_period
   (payer_plan_period_id			BIGINT			NOT NULL ,
    person_id						BIGINT			NOT NULL ,
    contract_person_id            BIGINT        	NULL ,
    payer_plan_period_start_date  DATE			NOT NULL ,
    payer_plan_period_end_date	DATE			NOT NULL ,
    payer_concept_id              INTEGER       	NOT NULL ,
    plan_concept_id               INTEGER       	NOT NULL ,
    contract_concept_id           INTEGER       	NOT NULL ,
    sponsor_concept_id            INTEGER       	NOT NULL ,
    stop_reason_concept_id        INTEGER       	NOT NULL ,
    payer_source_value			VARCHAR(50)	  	NULL ,
    payer_source_concept_id       INTEGER       	NOT NULL ,
    plan_source_value				VARCHAR(50)	  	NULL ,
    plan_source_concept_id        INTEGER       	NOT NULL ,
    contract_source_value         VARCHAR(50)   	NULL ,
    contract_source_concept_id    INTEGER       	NOT NULL ,
    sponsor_source_value          VARCHAR(50)   	NULL ,
    sponsor_source_concept_id     INTEGER       	NOT NULL ,
    family_source_value			VARCHAR(50)	  	NULL ,
    stop_reason_source_value      VARCHAR(50)   	NULL ,
    stop_reason_source_concept_id INTEGER       	NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE ON KEY(person_id)
  CREATE TABLE {sc}.cost  (
    cost_id						BIGINT		NOT NULL ,
    person_id 					BIGINT		NOT NULL,
    cost_event_id					BIGINT      NOT NULL ,
    cost_event_field_concept_id	INTEGER		NOT NULL , 
    cost_concept_id				INTEGER		NOT NULL ,
    cost_type_concept_id		  	INTEGER     NOT NULL ,
    currency_concept_id			INTEGER		NOT NULL ,
    cost							FLOAT		NULL ,
    incurred_date					DATE		NOT NULL ,
    billed_date					DATE		NULL ,
    paid_date						DATE		NULL ,
    revenue_code_concept_id		INTEGER		NOT NULL ,
    drg_concept_id			    INTEGER		NOT NULL ,
    cost_source_value				VARCHAR(50)	NULL ,
    cost_source_concept_id	  	INTEGER		NOT NULL ,
    revenue_code_source_value		VARCHAR(50) NULL ,
    drg_source_value			    VARCHAR(3)	NULL ,
    payer_plan_period_id			BIGINT		NULL
  )
  DISTKEY(person_id);
  
  
  /************************
  
  Standardized derived elements
  
  ************************/
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.drug_era  (
    drug_era_id				BIGINT			NOT NULL ,
    person_id					BIGINT			NOT NULL ,
    drug_concept_id			INTEGER			NOT NULL ,
    drug_era_start_datetime	TIMESTAMP		NOT NULL ,
    drug_era_end_datetime		TIMESTAMP		NOT NULL ,
    drug_exposure_count		INTEGER			NULL ,
    gap_days					INTEGER			NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.dose_era  (
    dose_era_id				BIGINT		NOT NULL ,
    person_id					BIGINT		NOT NULL ,
    drug_concept_id			INTEGER		NOT NULL ,
    unit_concept_id			INTEGER		NOT NULL ,
    dose_value				FLOAT		NOT NULL ,
    dose_era_start_datetime	TIMESTAMP	NOT NULL ,
    dose_era_end_datetime		TIMESTAMP	NOT NULL
  )
  DISTKEY(person_id);
  
  
  --HINT DISTRIBUTE_ON_KEY(person_id) 
  CREATE TABLE {sc}.condition_era  (
    condition_era_id					BIGINT			NOT NULL ,
    person_id							BIGINT			NOT NULL ,
    condition_concept_id				INTEGER			NOT NULL ,
    condition_era_start_datetime		TIMESTAMP		NOT NULL ,
    condition_era_end_datetime		TIMESTAMP		NOT NULL ,
    condition_occurrence_count		INTEGER			NULL
  )
  DISTKEY(person_id);