실내공기질 관리 플랫폼 new
테이블 (9)
Buildings
- building_id — BIGINT
- user_id — BIGINT
- building_name — VARCHAR(200) — NOT NULL
- address — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
DeviceAutoControls
- control_id — BIGINT
- device_id — BIGINT — NOT NULL
- auto_control_enabled — BOOLEAN
- pm25_trigger — FLOAT
- co2_trigger — FLOAT
- power — BOOLEAN
- mode — VARCHAR(50)
- fan_speed — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Devices
- device_id — BIGINT
- floor_id — BIGINT — NOT NULL
- device_name — VARCHAR(100) — NOT NULL
- device_type — VARCHAR(50) — NOT NULL
- x_coordinate — FLOAT
- y_coordinate — FLOAT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Floors
- floor_id — BIGINT
- building_id — BIGINT — NOT NULL
- floor_name — VARCHAR(50) — NOT NULL
- map_image_url — VARCHAR(500)
- description — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Measurements
- measurement_id — BIGINT
- sensor_id — BIGINT — NOT NULL
- timestamp — DATETIME — NOT NULL
- temperature — FLOAT
- humidity — FLOAT
- co2 — FLOAT
- voc — FLOAT
- pm25 — FLOAT
- pm10 — FLOAT
Notifications
- notification_id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- message — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- read — BOOLEAN
Schedules
- schedule_id — BIGINT
- device_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- days_of_week — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Sensors
- sensor_id — BIGINT
- floor_id — BIGINT — NOT NULL
- sensor_name — VARCHAR(100) — NOT NULL
- sensor_type — VARCHAR(50) — NOT NULL
- x_coordinate — FLOAT
- y_coordinate — FLOAT
- description — VARCHAR(500)
- registered_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Users
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- username — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(20)
- has_asthma — BOOLEAN
- has_allergy — BOOLEAN
- preferred_temp_min — FLOAT
- preferred_temp_max — FLOAT
- preferred_hum_min — FLOAT
- preferred_hum_max — FLOAT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL