     unit_id                     varchar(50),
     filter                      smallint
 );
-*/
+
 -- -------------------------------------------------------------------
 -- Rules all together
 -- Takes data from source tables and puts together participant_id

ALTER TABLE cdm.src_mapped ADD KEY (question_ppi_code);
CREATE INDEX mapped_p_id_and_ppi ON cdm.src_mapped (participant_id, question_ppi_code);
CREATE INDEX mapped_qr_id_and_ppi ON cdm.src_mapped (questionnaire_response_id, question_ppi_code);
*/
-- -------------------------------------------------------------------
-- source_file: src/location.sql
-- -------------------------------------------------------------------

        cdm.src_clean.question_ppi_code = cdm.combined_question_filter.question_ppi_code
SET cdm.src_clean.filter = 1
WHERE TRUE;

-- -------------------------------------------------------------------
-- source_file: src/src_mapped.sql
-- -------------------------------------------------------------------
