Iot_RDB
Tables (6)
Alert
- alert_id — INT
- device_id — INT — NOT NULL
- sensor_type — ENUM('Temperature', 'Humidity', 'CO2', 'Illumination', 'Noise', 'TVOC', 'Visited', 'Visible', 'Activity', 'Battery')
- timestamp — DATETIME — NOT NULL
- value — DECIMAL(10,2)
- threshold — DECIMAL(10,2)
- status — ENUM('active', 'resolved')
Building
- building_id — INT
- name — VARCHAR(100) — NOT NULL
Device
- device_id — INT
- place_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(50)
Interval_Type
- interval_id — INT
- duration — ENUM('1시간', '하루', '일주일', '1개월')
Measurement_Data
- data_id — INT
- device_id — INT — NOT NULL
- interval_id — INT — NOT NULL
- sensor_type — ENUM('Temperature', 'Humidity', 'CO2', 'Illumination', 'Noise', 'TVOC', 'Visited', 'Visible', 'Activity', 'Battery')
- timestamp — DATETIME — NOT NULL
- avg_value — DECIMAL(10,2)
- min_value — DECIMAL(10,2)
- max_value — DECIMAL(10,2)
Place
- place_id — INT
- building_id — INT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- type — ENUM('오피스', '페어룸', '서버실', '클래스A', '클래스B', '하이브', '배전판', '창고', '미팅룸')