Context
Add database tables for Sleepypod Mini data. Uses existing Drizzle + SQLite setup.
Tables
mini_sessions
- id, startTime, endTime, duration
- averageSootheLevel, maxSootheLevel
- cryEvents (count of escalations)
- notes
mini_soothe_events
- id, sessionId (FK), timestamp
- fromLevel, toLevel, trigger (auto/manual)
- duration at level
mini_baby_profile
- name, birthDate, weight
- settings (lock, weaning mode, sound type, volume)
mini_device_state
- lastSeen, firmwareVersion, wifiStrength
- currentState (asleep, awake, soothing, baseline)
- currentLevel, currentSound
Baby Biometrics (derived)
- Sleep duration trends (daily/weekly)
- Cry detection frequency from soothe escalation patterns
- Soothe responsiveness (time to settle at each level)
- Wake pattern analysis (time-of-night distribution)
Parent
Epic: #405
Context
Add database tables for Sleepypod Mini data. Uses existing Drizzle + SQLite setup.
Tables
mini_sessions
mini_soothe_events
mini_baby_profile
mini_device_state
Baby Biometrics (derived)
Parent
Epic: #405