CREATE TABLE IF NOT EXISTS cascade_lvl00_progress_disease_codes (
                                                                    id Int32,
                                                                    code_type String,
                                                                    encounter_id Int32,
                                                                    patient_id Int32,
                                                                    employee_id Int32  DEFAULT NULL,
                                                                    code String DEFAULT NULL,
                                                                    title String,
                                                                    role String,
                                                                    diagnose_id Int32 DEFAULT NULL,
                                                                    legal_entity_id Int32 DEFAULT NULL,
                                                                    asserted_date DateTime,
                                                                    ehealth_status Enum('not_sent'=0,'finished'=1, 'entered_in_error'=2, 'failed'=3, 'pending'=4, 'failed_with_error'=5)
    ) ENGINE = MergeTree()
    ORDER BY tuple()



CREATE TABLE IF NOT EXISTS cascade_lvl00_actions
(
    id Int32,
    status String DEFAULT 1,
    encounter_id Nullable(Int32),
    employee_id Nullable(Int32),
    patient_id Nullable(Int32),
    legal_entity_id Nullable(Int32),
    asserted_date Nullable(DateTime),
    code Nullable(String),
    item_type Int32 DEFAULT 3,
    title String
) ENGINE = MergeTree()
    ORDER BY id

CREATE TABLE IF NOT EXISTS cascade_lvl01_progress_diseases_services (
    id Int32,
    asserted_date DateTime DEFAULT NULL,
    code String DEFAULT NULL,
    encounter_id Int32 DEFAULT NULL,
    item_type UInt8,
    status String,
    title String,
    employee_id Int32 DEFAULT NULL,
    legal_entity_id Int32 DEFAULT NULL,
    patient_id Int32 DEFAULT NULL,
    resource_type String
) ENGINE = MergeTree()
ORDER BY tuple()

CREATE TABLE IF NOT EXISTS cascade_lvl02_patient_declarations
(
    id Int32,
    employee_id Int32,
    declaration_id Int32,
    legal_entity_id Nullable(Int32),
    division_id Nullable(Int32),
    declaration_number String,
    patient_full_name String,
    date_of_birth Date32,
    gender Nullable(UInt8),
    tax_id Nullable(String),
    patient_phone Nullable(String),
    health24_id Int32,
    ehealth_patient_id Nullable(String),
    doctor_full_name String,
    doctor_position String,
    ehealth_employee_status String,
    medical_facility Nullable(String),
    declaration_start_date Nullable(Date32),
    declaration_end_date Nullable(Date32),
    declaration_created_at Nullable(Date32),
    declaration_updated_at Nullable(Date32),
    ehealth_declaration_id String,
    declaration_status String,
    declaration_status_title String,
    patient_address Nullable(String),
    settlement_type_title Nullable(String),
    settlement_name Nullable(String),
    full_settlement_name Nullable(String),
    full_address Nullable(String),
    verification_status Nullable(String),
    declared_employee_last_encounter_id Nullable(Int32),
    last_encounter_id Nullable(Int32),
    country_id Nullable(Int32),
    region_id Nullable(Int32),
    settlement_id Nullable(Int32),
    district_id Nullable(Int32)
) ENGINE = MergeTree()
    ORDER BY (id, declaration_id)