user

테이블 (5)

Control function table(제어기능)

  • Key (control_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (device_id) — NOT NULL
  • Field (State) — NOT NULL

Device table

  • Key (device_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (user_id2) — NOT NULL — 외래 키 → user table.Key — NOT NULL
  • Key (user_id) — NOT NULL — NOT NULL
  • Field (device_name) — NOT NULL — NOT NULL
  • Field (device_type) — NOT NULL
  • Field (device_location) — NOT NULL
  • Field (last_updated) — DATETIME

Power table(전력)

  • Key (usage_id) — NOT NULL — 기본 키 — NOT NULL
  • Field (device_id) — NOT NULL
  • Field (Power consumption(전략소비량)) — FLOAT
  • Field (Cost(비용)) — NOT NULL

Sensor table

  • Key (data_id) — NOT NULL — 기본 키 — NOT NULL
  • Key (device_id2) — NOT NULL — 외래 키 → Device table.Key — NOT NULL
  • Key (user_id2) — NOT NULL — 외래 키 → Device table.Key — NOT NULL
  • Key (device_id) — NOT NULL — NOT NULL
  • Field (Temperature(온도)) — FLOAT
  • Field (Humidity(습도)) — FLOAT
  • Field (light(전등)) — FLOAT

user table

  • Key (user_id) — NOT NULL — 기본 키 — NOT NULL