_memory
| type | name | tbl_name | rootpage | sql |
|---|---|---|---|---|
| table | _attributes | _attributes | 2 | CREATE TABLE _attributes ( timestamp DATETIME, "key" VARCHAR NOT NULL, value VARCHAR, PRIMARY KEY ("key") ) |
| table | summary | summary | 4 | CREATE TABLE summary ( timestamp DATETIME, "key" VARCHAR NOT NULL, value VARCHAR, PRIMARY KEY ("key") ) |
| table | years_summary | years_summary | 6 | CREATE TABLE years_summary ( first_day DATE NOT NULL, hr_avg FLOAT, hr_min FLOAT, hr_max FLOAT, rhr_avg FLOAT, rhr_min FLOAT, rhr_max FLOAT, inactive_hr_avg FLOAT, inactive_hr_min FLOAT, inactive_hr_max FLOAT, weight_avg FLOAT, weight_min FLOAT, weight_max FLOAT, intensity_time TIME NOT NULL, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, steps INTEGER, steps_goal INTEGER, floors FLOAT, floors_goal FLOAT, sleep_avg TIME NOT NULL, sleep_min TIME NOT NULL, sleep_max TIME NOT NULL, rem_sleep_avg TIME NOT NULL, rem_sleep_min TIME NOT NULL, rem_sleep_max TIME NOT NULL, stress_avg INTEGER, calories_avg INTEGER, calories_bmr_avg INTEGER, calories_active_avg INTEGER, calories_goal INTEGER, calories_consumed_avg INTEGER, activities INTEGER, activities_calories INTEGER, activities_distance INTEGER, hydration_goal INTEGER, hydration_avg INTEGER, hydration_intake INTEGER, sweat_loss_avg INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_max INTEGER, bb_min INTEGER, PRIMARY KEY (first_day) ) |
| table | months_summary | months_summary | 8 | CREATE TABLE months_summary ( first_day DATE NOT NULL, hr_avg FLOAT, hr_min FLOAT, hr_max FLOAT, rhr_avg FLOAT, rhr_min FLOAT, rhr_max FLOAT, inactive_hr_avg FLOAT, inactive_hr_min FLOAT, inactive_hr_max FLOAT, weight_avg FLOAT, weight_min FLOAT, weight_max FLOAT, intensity_time TIME NOT NULL, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, steps INTEGER, steps_goal INTEGER, floors FLOAT, floors_goal FLOAT, sleep_avg TIME NOT NULL, sleep_min TIME NOT NULL, sleep_max TIME NOT NULL, rem_sleep_avg TIME NOT NULL, rem_sleep_min TIME NOT NULL, rem_sleep_max TIME NOT NULL, stress_avg INTEGER, calories_avg INTEGER, calories_bmr_avg INTEGER, calories_active_avg INTEGER, calories_goal INTEGER, calories_consumed_avg INTEGER, activities INTEGER, activities_calories INTEGER, activities_distance INTEGER, hydration_goal INTEGER, hydration_avg INTEGER, hydration_intake INTEGER, sweat_loss_avg INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_max INTEGER, bb_min INTEGER, PRIMARY KEY (first_day) ) |
| table | weeks_summary | weeks_summary | 10 | CREATE TABLE weeks_summary ( first_day DATE NOT NULL, hr_avg FLOAT, hr_min FLOAT, hr_max FLOAT, rhr_avg FLOAT, rhr_min FLOAT, rhr_max FLOAT, inactive_hr_avg FLOAT, inactive_hr_min FLOAT, inactive_hr_max FLOAT, weight_avg FLOAT, weight_min FLOAT, weight_max FLOAT, intensity_time TIME NOT NULL, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, steps INTEGER, steps_goal INTEGER, floors FLOAT, floors_goal FLOAT, sleep_avg TIME NOT NULL, sleep_min TIME NOT NULL, sleep_max TIME NOT NULL, rem_sleep_avg TIME NOT NULL, rem_sleep_min TIME NOT NULL, rem_sleep_max TIME NOT NULL, stress_avg INTEGER, calories_avg INTEGER, calories_bmr_avg INTEGER, calories_active_avg INTEGER, calories_goal INTEGER, calories_consumed_avg INTEGER, activities INTEGER, activities_calories INTEGER, activities_distance INTEGER, hydration_goal INTEGER, hydration_avg INTEGER, hydration_intake INTEGER, sweat_loss_avg INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_max INTEGER, bb_min INTEGER, PRIMARY KEY (first_day) ) |
| table | days_summary | days_summary | 14 | CREATE TABLE days_summary ( day DATE NOT NULL, hr_avg FLOAT, hr_min FLOAT, hr_max FLOAT, rhr_avg FLOAT, rhr_min FLOAT, rhr_max FLOAT, inactive_hr_avg FLOAT, inactive_hr_min FLOAT, inactive_hr_max FLOAT, weight_avg FLOAT, weight_min FLOAT, weight_max FLOAT, intensity_time TIME NOT NULL, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, steps INTEGER, steps_goal INTEGER, floors FLOAT, floors_goal FLOAT, sleep_avg TIME NOT NULL, sleep_min TIME NOT NULL, sleep_max TIME NOT NULL, rem_sleep_avg TIME NOT NULL, rem_sleep_min TIME NOT NULL, rem_sleep_max TIME NOT NULL, stress_avg INTEGER, calories_avg INTEGER, calories_bmr_avg INTEGER, calories_active_avg INTEGER, calories_goal INTEGER, calories_consumed_avg INTEGER, activities INTEGER, activities_calories INTEGER, activities_distance INTEGER, hydration_goal INTEGER, hydration_avg INTEGER, hydration_intake INTEGER, sweat_loss_avg INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_max INTEGER, bb_min INTEGER, PRIMARY KEY (day) ) |