PJ2IoT

Tables (6)

Detail (detail)

  • Function No (fun_no) — NUM — Foreign key → Function.Function No — NOT NULL
  • Object No (obj_no) — NUM — Foreign key → Object.Object No — NOT NULL
  • Family No (fa_no) — NUM — Foreign key → Family.Family No — NOT NULL
  • Start (start) — time
  • End (end) — time
  • Status (status) — boolean
  • Condition On (con_on) — VARCHAR(30)
  • Condition Off (con_off) — VARCHAR(30)

Family (family)

  • Family No (fa_no) — NUM — Primary key — NOT NULL
  • ID (id) — VARCHAR(30)
  • Password (pwd) — VARCHAR(60)
  • Map (map) — IMG

Find stuff (find_stuff)

  • Stuff No (stuff_no) — NUM — Primary key — NOT NULL
  • User no (user_no) — NUM — Foreign key → User.User no — NOT NULL
  • Stuff Name (stuff_name) — VARCHAR(30)
  • Stuff img (stuff_img) — img
  • x — NUM
  • y — NUM

Function (function)

  • Function No (fun_no) — NUM — Primary key — NOT NULL
  • Function Name (fun_name) — VARCHAR(30)

Object (object)

  • Object No (obj_no) — NUM — Primary key — NOT NULL
  • Object Name (obj_name) — VARCHAR(30)

User (user)

  • User no (user_no) — NUM — Primary key — NOT NULL
  • Family No (fa_no) — NUM — Foreign key → Family.Family No — NOT NULL
  • Name (name) — VARCHAR(30)
  • Email (email) — VARCHAR(30)