Kumho

Tables (5)

Device

  • id — int — Primary key — NOT NULL
  • Group ID (groupID) — int — Foreign key → Group.id — NOT NULL
  • User ID (userID) — int — Foreign key → User.id — NOT NULL
  • name — text
  • createdAt — datetime
  • updatedAt — datetime

Firmware version (firmwareNote)

  • id — int — Primary key — NOT NULL
  • version — text
  • Update note (updateNote) — text
  • Download URL (downloadURL) — text
  • createdAt — datetime
  • updatedAt — datetime

Group

  • id — int — Primary key — NOT NULL
  • User ID (userID) — int — Foreign key → User.id — NOT NULL
  • name — text
  • status — text
  • isSensorOperation — boolean
  • Brightness Value when sensor is recognized (activeSensorBrightness) — tinyint
  • Brightness Value when sensor is not recognized (deactivateSensorBrightness) — tinyint
  • Brightness Fixed mode: Brightness value (fixedModeBrightness) — tinyint
  • Sensor sensitivity value (sensorStrength) — tinyint
  • Brightness retention time value when sensor is recognized (sensorShiningDuration) — tinyint
  • Sensor recognizing cycle (sensorCycleDuration) — tinyint
  • Fade-In Time (fadeInTime) — tinyint
  • Fade-Out Time (fadeOutTime) — tinyint
  • createdAt — datetime
  • updatedAt — datetime

User

  • id — int — Primary key — NOT NULL
  • email — text
  • password — text
  • Company name (companyName) — text
  • Phone number (phoneNumber) — text
  • Address (address) — text
  • Address detail (addressDetail) — text
  • user role (role) — tinyint
  • Time created account (createdAt) — datetime
  • Time updated account (updatedAt) — datetime
  • User status (status) — text

User access infomation (userAccessInfo)

  • id — int — Primary key — NOT NULL
  • User ID (userID) — int — Foreign key → User.id — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime