         ON (f.id = d.id)
 ;
 
+ALTER TABLE dw_morbidity_diseases
+    ADD CONSTRAINT dw_morbidity_diseases_pkey PRIMARY KEY (id);
+
 CREATE TABLE dw_contact_diseases AS
 SELECT
     d.*


ALTER TABLE dw_events_reporting_agencies
    ADD CONSTRAINT pk_dw_events_reporting_agencies PRIMARY KEY (id);

CREATE TABLE dw_events_reporters AS
SELECT

    e.type = 'MorbidityEvent'
;

ALTER TABLE dw_morbidity_answers
    ADD CONSTRAINT dw_morbidity_answers_pkey PRIMARY KEY (id);
CREATE INDEX dw_morbidity_answers_event_id
    ON dw_morbidity_answers (event_id);
CREATE INDEX dw_morbidity_answers_question_id
    ON dw_morbidity_answers (question_id);

CREATE TABLE dw_contact_answers AS
SELECT
    a.*
