This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last 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:52] cmkerr [Proposal] |
||
---|---|---|---|
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 | | ||
- | | ADMIN_CODE | No | varchar(255) | | | + | | TIMING_CONCEPT_ID | No | integer | A foreign key that refers to a timing Concept identifier in the Standardized Vocabularies | |
- | | ADMIN_CODE_VOCAB | No | varchar(100) | | | + | | TIMING_SOURCE_VALUE | No | varchar(100) | Text string representing the timing of the survey | |
- | | TIMING | No | varchar(100) | | | + | |
==== Use Cases ==== | ==== Use Cases ==== |