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 ==== |