CREATE TABLE bd_hospital.map_diagnosis_illness (
    id_diagnosis INT NOT NULL,
    illness_name VARCHAR(50),
    description TEXT,
    UNIQUE KEY id_illness_elements (id_diagnosis , illness_name),
    CONSTRAINT fk_diagnosis_illness_illness FOREIGN KEY (illness_name)
        REFERENCES illness (name)
        ON UPDATE CASCADE ON DELETE CASCADE,
    CONSTRAINT fk_diagnosis_illness_diagnosis FOREIGN KEY (id_diagnosis)
        REFERENCES diagnosis (id)
        ON UPDATE CASCADE ON DELETE CASCADE
);