     e.type = 'ContactEvent'
 ;
 
+ALTER TABLE dw_contact_answers
+    ADD CONSTRAINT dw_contact_answers_pkey PRIMARY KEY (id);
+CREATE INDEX dw_contact_answers_event_id
+    ON dw_contact_answers (event_id);
+CREATE INDEX dw_contact_answers_question_id
+    ON dw_contact_answers (question_id);
+
 CREATE TABLE dw_encounter_answers AS
 SELECT
     a.*

        ON (f.id = q.id)
;

CREATE TABLE dw_place_questions AS
SELECT
    q.*


ALTER TABLE dw_events_reporting_agencies
    ADD CONSTRAINT pk_dw_events_reporting_agencies PRIMARY KEY (id);
CREATE INDEX dw_events_rep_agen_morbidity_event_ix
    ON dw_events_reporting_agencies (dw_morbidity_events_id);
CREATE INDEX dw_events_rep_agen_contact_event_ix
    ON dw_events_reporting_agencies (dw_contact_events_id);
CREATE INDEX dw_events_reporting_agencies_place_ix
    ON dw_events_reporting_agencies (place_id);

CREATE TABLE dw_events_reporters AS
SELECT
