실내 공기질 관리 플랫폼

테이블 (9)

Buildings

  • building_id — BIGINT
  • user_id — BIGINT
  • building_name — VARCHAR(200) — NOT NULL
  • address — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

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
  • updated_at — DATETIME

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
  • updated_at — DATETIME

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
  • updated_at — DATETIME

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
  • 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
  • updated_at — DATETIME

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
  • updated_at — DATETIME

Users

  • Key — 기본 키 — NOT NULL
  • 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
  • updated_at — DATETIME