LUCY Mobile for User
Tables (6)
Activities (activities)
- User ID (userId) — text — Primary key — NOT NULL
- Steps (steps) — int
- Date (date) — datetime
- Calories Burned (caloriesBurned) — int
- Activity Pattern (activityPattern) — int
- Heart Rate (heartRate) — int
- Distance (distance) — float
- Steps Difference (diffSteps) — int
- Stride (stride) — int
- Velocity (velocity) — float
- VO2 Max (vo2Max) — int
- Basal Metabolic Rate (bmr) — int
- Fat Burn Zone (fatBurnZone) — tuple
- Cardio Zone (cardioZone) — tuple
- Peak Zone (peakZone) — tuple
Activity Guides (activity guides)
- Calories Burned (caloriesBurned) — text
- Calories Needed (caloriesNeed) — text
- Activity Pattern (activityPattern) — text
- Activity HR (heartRate) — text
- VO2 Max (vo2Max) — text
Activity Standards (activity standards)
- Steps (steps) — tuple
- 전날 대비 차이 (diffPrevious) — tuple
- Calories (calories) — tuple
- Activity Pattern (activityPattern) — tuple
- Field
Sleep Guide (sleep guides)
- Amount (amount) — text
- 전날 대비 차이 (diffAmount) — text
- Awake Guide (awake) — text
- REM Sleep Guide (rem) — text
- Light Sleep Guide (lightSleep) — text
- Deep Sleep Guide (deepSleep) — text
- SpO2 Guide (spo2) — text
- SpO2 Low (spo2Low) — text
- SpO2 Abnormal Number (spo2Abnormal) — text
- Sleep Apnea (sleepApnea) — text
- Heart Rate Guide (heartRate) — text
- Breathing Rate (breathingRate) — text
Sleep Standards (sleep standards)
- Amount (amount) — tuple
- 전날 대비 차이 (diffPrevious) — int
- Awake (awake) — tuple
- REM (rem) — tuple
- Light (light) — tuple
- Deep (deep) — tuple
- SpO2 (spo2) — tuple
- SpO2 Low (spo2Low) — int
- SpO2 Abnormal Number (spo2AbnormalNumber) — int
- Sleep Apnea (sleepApnea) — int
- HR (heartRate) — tuple
- Breathing Rate (breathingRate) — tuple
Sleeps (sleeps)
- User ID (userId) — text — Primary key — NOT NULL
- Date (date) — datetime
- Minutes Asleep (minsAsleep) — int
- Minutes Awake (minsAwake) — int
- Minutes REM (minsRem) — int
- Minutes Deep (minsDeep) — int
- Time Bed (timeBed) — datetime
- Time Wakeup (timeWakeup) — datetime
- SpO2 (spo2) — float
- Breathing Rate (breathingRate) — float
- HR (heartRate) — int
- Minutes Total Sleep Time (totalSleepTime) — int
- Sleep Amount Difference (diffAmount) — int
- SpO2 Low Time (minsLowSpo2) — int
- SpO2 abnormal Time (numberAbnormalSpo2) — int
- Sleep Apnea Symptoms (sleepApnea) — bool