논문ERD
테이블 (5)
MotionList (motionlist)
- MotionID (motion_id) — INT(11) — 기본 키 — NOT NULL
- MotionName (motion_name) — VARCHAR(50)
- Company (company) — VARCHAR(50)
- UseYN (use_yn) — CHAR(1)
PlugList (pluglist)
- DeviceID (device_id) — INT(11) — 기본 키 — NOT NULL
- DeviceName (device_name) — VARCHAR(50)
- Company (company) — VARCHAR(50)
- UseYN (use_yn) — CHAR(1)
UserList (userlist)
- UserID (user_id) — INT(11) — 기본 키 — NOT NULL
- UserName (user_name) — VARCHAR(50)
- ZipCode (zip) — VARCHAR(10)
- Addr1 (addr1) — VARCHAR(50)
- Addr2 (addr2) — VARCHAR(50)
- AddrEtc (addretc) — VARCHAR(50)
- CreateDay (create_day) — DATETIME
- LastLoginDay (lastlogin_day) — VARCHAR(50)
UsingDevice (usingdevice)
- UsingID (using_id) — INT(11) — 기본 키
- UserID (user_id) — INT(11) — 외래 키 → UserList.UserID — NOT NULL
- DeviceID (device_id) — INT(11) — 외래 키 → PlugList.DeviceID
- MotionID (motion_id) — INT(11) — 외래 키 → MotionList.MotionID
UsingLog (usinglog)
- LogID (log_id) — INT(11) — 기본 키 — NOT NULL
- UsingID (using_id) — INT(11) — 외래 키 → UsingDevice.UsingID
- UserID (user_id) — INT(11) — 외래 키 → UsingDevice.UserID — NOT NULL
- LogDate (log_date) — Datetime
- LogType (log_type) — CHAR(1)
- LogValue (log_value) — FLOAT(10,3)
- Field