Database Layout - OpenDiabetes/OpenDiabetesVault-engine GitHub Wiki
Event vs Data
In general *_DATA types are data, that observe something in a more or less continuous manner. For instance, blood glucose is always there, but is observed by the CGM system resulting in GLUCOSE_CGM values. In contrast to *_EVENT types, that are driven by an event actively produced by the user or a system. For instance, a insulin bolus is given actively by the patient and documented by the pump system resulting in BOLUS_NORMAL values.
Data organization
| VaultEntryType | Group | Type | Data Type | Typical Act Time | One-Hot | ML relevant | Merge To | NS Equivalent |
|---|---|---|---|---|---|---|---|---|
| BOLUS_NORMAL | BOLUS | USER_EVENT | float | 180 | nein | ja | ||
| BOLUS_SQARE | BOLUS | USER_EVENT | float | given | nein | ja | ||
| BASAL_PROFILE | BASAL | SYSTEM_EVENT | float | 60 | nein | ja | BASAL | |
| BASAL_MANUAL | BASAL | USER_EVENT | float | till next event | nein | ja | BASAL | |
| BASAL_INTERPRETER | BASAL | GENERATED_EVENT | float | till next event | nein | ja | BASAL | |
| EXERCISE_MANUAL | EXERCISE | USER_EVENT | float | given | ja | ja | ||
| EXERCISE_OTHER | EXERCISE | TRACKER_EVENT | float | given | ja | ja | ||
| EXERCISE_WALK | EXERCISE | TRACKER_EVENT | float | given | ja | ja | ||
| EXERCISE_BICYCLE | EXERCISE | TRACKER_EVENT | float | given | ja | ja | ||
| EXERCISE_RUN | EXERCISE | TRACKER_EVENT | float | given | ja | ja | ||
| GLUCOSE_CGM | GLUCOSE | SYSTEM_DATA | float | nein | ja | |||
| GLUCOSE_CGM_RAW | GLUCOSE | SYSTEM_DATA | float | nein | nein | |||
| GLUCOSE_CGM_ALERT | GLUCOSE | SYSTEM_DATA | float | ja | maybe | |||
| GLUCOSE_CGM_CALIBRATION | GLUCOSE | USER_EVENT | float | nein | maybe | |||
| GLUCOSE_BG | GLUCOSE | USER_EVENT | float | nein | maybe | |||
| GLUCOSE_BG_MANUAL | GLUCOSE | USER_EVENT | float | nein | maybe | |||
| GLUCOSE_BOLUS_CALCULATION | GLUCOSE | USER_EVENT | float | nein | maybe | |||
| GLUCOSE_ELEVATION_30 | GLUCOSE | GENERATED_DATA | float | nein | nein | |||
| CGM_SENSOR_FINISHED | CGM_SYSTEM | SYSTEM_EVENT | bool | ja | maybe | |||
| CGM_SENSOR_START | CGM_SYSTEM | SYSTEM_EVENT | bool | ja | maybe | |||
| CGM_CONNECTION_ERROR | CGM_SYSTEM | SYSTEM_EVENT | bool | till next GLUCOSE_CGM | ja | maybe | ||
| CGM_CALIBRATION_ERROR | CGM_SYSTEM | SYSTEM_EVENT | bool | till next GLUCOSE_CGM_CALIBRATION | ja | ja | ||
| CGM_TIME_SYNC | CGM_SYSTEM | SYSTEM_EVENT | timestamp ? | nein | maybe | |||
| MEAL_BOLUS_CALCULATOR | MEAL | USER_EVENT | float | nein | ja | MEAL | ||
| MEAL_MANUAL | MEAL | USER_EVENT | float | nein | ja | MEAL | ||
| PUMP_REWIND | PUMP_SYSTEM | USER_EVENT | bool | till next PUMP_PRIME | ja | maybe | ||
| PUMP_PRIME | PUMP_SYSTEM | USER_EVENT | float | nein | maybe | |||
| PUMP_FILL | PUMP_SYSTEM | USER_EVENT | bool | ja | maybe | PUMP_FILL | ||
| PUMP_FILL_INTERPRETER | PUMP_SYSTEM | SYSTEM_EVENT | bool | ja | maybe | PUMP_FILL | ||
| PUMP_NO_DELIVERY | PUMP_SYSTEM | SYSTEM_EVENT | bool | ??? | ja | ja | ||
| PUMP_SUSPEND | PUMP_SYSTEM | USER_EVENT | bool | till next PUMP_UNSUSPEND | ja | ja | PUMP_SUSPEND | |
| PUMP_UNSUSPEND | PUMP_SYSTEM | USER_EVENT / SYSTEM_EVENT | bool | nein | ja | |||
| PUMP_UNTRACKED_ERROR | PUMP_SYSTEM | SYSTEM_EVENT | bool | nein | nein | |||
| PUMP_RESERVOIR_EMPTY | PUMP_SYSTEM | SYSTEM_EVENT | bool | till next PUMP_REWIND | ja | maybe | ||
| PUMP_TIME_SYNC | PUMP_SYSTEM | SYSTEM_EVENT | timestamp ? | nein | maybe | |||
| PUMP_AUTONOMOUS_SUSPEND | PUMP_SYSTEM | SYSTEM_EVENT | bool | till next PUMP_UNSUSPEND | ja | ja | PUMP_SUSPEND | |
| PUMP_CGM_PREDICTION | PUMP_SYSTEM | SYSTEM_DATA | float | nein | nein | |||
| SLEEP_LIGHT | SLEEP | TRACKER_DATA | float | given | ja | ja | SLEEP | |
| SLEEP_REM | SLEEP | TRACKER_DATA | float | given | ja | ja | SLEEP | |
| SLEEP_DEEP | SLEEP | TRACKER_DATA | float | given | ja | ja | SLEEP | |
| HEART_RATE | HEART | TRACKER_DATA | float | nein | maybe | |||
| HEART_RATE_VARIABILITY | HEART | TRACKER_DATA | float | nein | maybe | |||
| STRESS | HEART | TRACKER_DATA | float | nein | nein | |||
| LOC_TRANSISTION | LOCATION | TRACKER_DATA | bool | given | ja | ja | ||
| LOC_HOME | LOCATION | TRACKER_DATA | bool | given | ja | ja | ||
| LOC_WORK | LOCATION | TRACKER_DATA | bool | given | ja | ja | ||
| LOC_FOOD | LOCATION | TRACKER_DATA | bool | given | ja | ja | ||
| LOC_SPORTS | LOCATION | TRACKER_DATA | bool | given | ja | ja | ||
| LOC_OTHER | LOCATION | TRACKER_DATA | bool | given | nein | nein | ||
| ML_CGM_PREDICTION | MACHINE_LEARNING | GENERATED_DATA | float | nein | nein | |||
| DM_INSULIN_SENSITIVTY | DATA_MINING | GENERATED_DATA | float | nein | maybe | |||
| OTHER_ANNOTATION |