_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 | attributes | attributes | 4 | CREATE TABLE attributes ( timestamp DATETIME, "key" VARCHAR NOT NULL, value VARCHAR, PRIMARY KEY ("key") ) |
| table | devices | devices | 6 | CREATE TABLE devices ( serial_number INTEGER NOT NULL, timestamp DATETIME, device_type VARCHAR, manufacturer VARCHAR(24), product VARCHAR, hardware_version VARCHAR, PRIMARY KEY (serial_number) ) |
| table | weight | weight | 7 | CREATE TABLE weight ( day DATE NOT NULL, weight FLOAT NOT NULL, PRIMARY KEY (day) ) |
| table | stress | stress | 9 | CREATE TABLE stress ( timestamp DATETIME NOT NULL, stress INTEGER NOT NULL, PRIMARY KEY (timestamp), UNIQUE (timestamp) ) |
| table | sleep | sleep | 11 | CREATE TABLE sleep ( day DATE NOT NULL, start DATETIME, "end" DATETIME, total_sleep TIME NOT NULL, deep_sleep TIME NOT NULL, light_sleep TIME NOT NULL, rem_sleep TIME NOT NULL, awake TIME NOT NULL, avg_spo2 FLOAT, avg_rr FLOAT, avg_stress FLOAT, score INTEGER, qualifier VARCHAR, PRIMARY KEY (day) ) |
| table | sleep_events | sleep_events | 13 | CREATE TABLE sleep_events ( timestamp DATETIME NOT NULL, event VARCHAR, duration TIME NOT NULL, PRIMARY KEY (timestamp) ) |
| table | resting_hr | resting_hr | 15 | CREATE TABLE resting_hr ( day DATE NOT NULL, resting_heart_rate FLOAT, PRIMARY KEY (day) ) |
| table | daily_summary | daily_summary | 17 | CREATE TABLE daily_summary ( day DATE NOT NULL, hr_min INTEGER, hr_max INTEGER, rhr INTEGER, stress_avg INTEGER, step_goal INTEGER, steps INTEGER, moderate_activity_time TIME NOT NULL, vigorous_activity_time TIME NOT NULL, intensity_time_goal TIME NOT NULL, floors_up FLOAT, floors_down FLOAT, floors_goal FLOAT, distance FLOAT, calories_goal INTEGER, calories_total INTEGER, calories_bmr INTEGER, calories_active INTEGER, calories_consumed INTEGER, hydration_goal INTEGER, hydration_intake INTEGER, sweat_loss INTEGER, spo2_avg FLOAT, spo2_min FLOAT, rr_waking_avg FLOAT, rr_max FLOAT, rr_min FLOAT, bb_charged INTEGER, bb_max INTEGER, bb_min INTEGER, description VARCHAR, PRIMARY KEY (day) ) |
| table | files | files | 19 | CREATE TABLE files ( id VARCHAR NOT NULL, name VARCHAR, type VARCHAR(28) NOT NULL, serial_number INTEGER, PRIMARY KEY (id), UNIQUE (name), FOREIGN KEY(serial_number) REFERENCES devices (serial_number) ) |
| table | device_info | device_info | 22 | CREATE TABLE device_info ( timestamp DATETIME NOT NULL, file_id VARCHAR, serial_number INTEGER NOT NULL, software_version VARCHAR, cum_operating_time TIME NOT NULL, battery_status VARCHAR(8), battery_voltage FLOAT, PRIMARY KEY (timestamp, serial_number), FOREIGN KEY(file_id) REFERENCES files (id), FOREIGN KEY(serial_number) REFERENCES devices (serial_number) ) |