reborn
Tables (6)
device
- deviceId — VARCHAR(50) — Primary key — NOT NULL
- placeId — INT — Foreign key → place.placeId — NOT NULL
- deviceName — VARCHAR(50) — NOT NULL
feedback
- feedbackId — INT — Primary key — NOT NULL
- deviceId — VARCHAR(50) — Foreign key → device.deviceId — NOT NULL
- title — VARCHAR(150) — NOT NULL
- content — TEXT
- status — VARCHAR(20) — NOT NULL
- userIp — VARCHAR(45) — NOT NULL
- createdAt — DATETIME(6) — NOT NULL
place
- placeId — INT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- placeType — VARCHAR(20) — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
sensorLogs
- logId — BIGINT — Primary key — NOT NULL
- deviceId — VARCHAR(50) — Foreign key → device.deviceId — NOT NULL
- temperature — DECIMAL(4,2)
- humidity — DECIMAL(4,2)
- illuminance — INT
- peopleCount — INT
- discomfort — DECIMAL(4,2)
- createdAt — DATETIME(6) — NOT NULL
user
- userId — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100)
- fcmToken — VARCHAR(255)
- createdAt — DATETIME(6) — NOT NULL
- refreshToken — VARCHAR(255) — NOT NULL
user_place_mapping
- userId — VARCHAR(255) — Foreign key → user.userId — NOT NULL
- placeId — INT — Foreign key → place.placeId — NOT NULL
- accessLevel — VARCHAR(20) — NOT NULL