논문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