NMB

Tables (6)

Device (device)

  • UserId (user_id) — String — Foreign key → NugaId.UserId — NOT NULL
  • Deivce (device) — String
  • SerialNumber (serial_number) — Int
  • MacAddress (mac_address) — String
  • RegistrationTime (registration_time) — DateTime

ErrorLog (error_log)

  • UserId (user_id2) — String — Foreign key → UserInfo.UserId — NOT NULL
  • Error (error) — String
  • Date (date) — DateTime

History (history)

  • UserId (user_id2) — String — Foreign key → UserInfo.UserId — NOT NULL
  • UserName (user_name2) — String — Foreign key → UserInfo.UserName — NOT NULL
  • Date (date) — DateTime
  • Mode (mode) — Int
  • RunningTime (running_time) — Int

NugaId (nuga_id)

  • UserId (user_id) — String — Foreign key → UserInfo.UserId — NOT NULL
  • PW (pass_word) — String
  • RegistrationTime (registration_time) — DateTime

UserInfo (user_info)

  • UserId (user_id) — String — Primary key — NOT NULL
  • UserName (user_name) — String — Primary key — NOT NULL
  • UserAge (user_age) — Int
  • UserGender (user_gender) — Int
  • UserHeight (user_height) — Int

UserScanData (user_scan_data)

  • UserId (user_id2) — String — Foreign key → UserInfo.UserId — NOT NULL
  • UserName (user_name2) — String — Foreign key → UserInfo.UserName — NOT NULL
  • Date (date) — DateTime
  • ScanData (scan_data) — json