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