projects:workgroups:cdm-wg:add_survey_data
Differences
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:49] cmkerr [SURVEY table] |
projects:workgroups:cdm-wg:add_survey_data [2017/05/29 16:52] cmkerr [Proposal] |
||
|---|---|---|---|
| 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 ==== | ||
projects/workgroups/cdm-wg/add_survey_data.txt · Last modified: 2017/05/30 14:23 by cmkerr
Page Tools
