Changes between Version 12 and Version 13 of Onyx to PDO
- Timestamp:
- 01/11/12 08:34:51 (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Onyx to PDO
v12 v13 33 33 The '''__observation facts__''' holds one row for every fact (deemed sensible to include) that has been gleaned about a participant from the questionnaire. 34 34 35 Each observation fact points to a patient and a visit : these are part of the observation fact's primary key. All three main tables have dates:35 Each observation fact points to a patient and a visit using the unique i2b2 internal patient id and event id: these are part of the observation fact's primary key. All three main tables have dates: 36 36 37 ||= observation fact =|| start date|| end date ||38 ||= visit dimension =|| start date|| end date ||37 ||= observation fact =|| '''start date''' || end date || 38 ||= visit dimension =|| '''start date''' || end date || 39 39 ||= patient dimension =|| birthdate || death date || 40 40 41 41 The start dates for observation fact and visit dimension are mandatory. 42 42 43 43 === Building Observation Facts ===
