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