Zolpia

Tables (5)

EEGData (Untitled3)

  • eegDataID (Key) — Primary key — NOT NULL
  • sleepAnalysisResultID (Key2) — Foreign key → SleepAnalysisResult.sleepAnalysisResultID — NOT NULL
  • statement (int)

SleepAnalysisResult (Untitled2)

  • sleepAnalysisResultID (Key) — Primary key — NOT NULL
  • userID (uniue) — Foreign key → User.email
  • sleepScore (Field)
  • sleepTimeFrom (Field2)
  • sleepTimeTo (Field3)
  • deepSleepTime (Field4)
  • shallowSleepTime (Field5)
  • evaulation (Field6)
  • sleepDate (Field7)

User (Untitled)

  • email (uniue) — Primary key
  • password (hashed)
  • name

VibrationPattern (Untitled5)

  • vibrationPatternID (Key) — Primary key — NOT NULL
  • pattern (charfield)

VibrationSetting (CopyOfUntitled4)

  • vibrationSettingID (Key2) — Primary key — NOT NULL
  • vibrationPatternID (Key) — Foreign key → VibrationPattern.vibrationPatternID — NOT NULL
  • userID (uniue) — Foreign key → User.email
  • name (Field)
  • isAlarm (Field2)
  • alarmTimeTo (Field3)