This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
projects:workgroups:cdm-wg:add_survey_data [2017/05/29 16:45] cmkerr |
projects:workgroups:cdm-wg:add_survey_data [2017/05/29 16:49] cmkerr [OBSERVATION table - new columns] |
||
---|---|---|---|
Line 18: | Line 18: | ||
- The patient responses are stored as key-value pairs in the OBSERVATION table, but we need to be able to group responses together according to the survey they belong to. We propose adding a new column - SURVEY_ID - to the OBSERVATION table. | - The patient responses are stored as key-value pairs in the OBSERVATION table, but we need to be able to group responses together according to the survey they belong to. We propose adding a new column - SURVEY_ID - to the OBSERVATION table. | ||
| | ||
- | ===== SURVEY table ===== | + | === SURVEY table === |
^ Field ^ Required ^ Type ^ Description ^ | ^ Field ^ Required ^ Type ^ Description ^ | ||
| SURVEY_ID | Yes | integer | Unique identifer for each completed survey | | | SURVEY_ID | Yes | integer | Unique identifer for each completed survey | | ||
Line 38: | Line 38: | ||
- | ===== OBSERVATION table - new columns ===== | + | === OBSERVATION table - new columns === |
^ Field ^ Required ^ Type ^ Description ^ | ^ Field ^ Required ^ Type ^ Description ^ | ||
| SURVEY_ID | No | integer | A foreign key to the survey in the SURVEY table to which the observation belongs | | | SURVEY_ID | No | integer | A foreign key to the survey in the SURVEY table to which the observation belongs | |