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