ITEM

Tables (3)

Confirmlist

  • Key (ID) — int — Primary key — NOT NULL
  • Key (ID2) — int — Foreign key → Todolist.Key — NOT NULL — auto_increment
  • Field (IAMGE) — longblob
  • Field (DESCRIPT) — varchar(255)

Todolist

  • Key (ID) — int — Primary key — NOT NULL — auto_increment
  • Field (TITLE) — varchar(40) — NOT NULL
  • Field (COMPLETED) — tinyint(1) — NOT NULL
  • Field (CONFIRMED) — tinyint(1) — NOT NULL
  • Field (LINED) — tinyint(1) — NOT NULL
  • Field (TEAM) — int — NOT NULL
  • Key (USER_ID) — varchar(40) — Foreign key → User.Key — NOT NULL

User

  • Key (USER_ID) — varchar(40) — Primary key — NOT NULL
  • Field (USER_NAME) — varchar(40) — NOT NULL
  • Field (PW) — varchar(40) — NOT NULL
  • Field (EMAIL) — varchar(40) — NOT NULL
  • Field (TEAM) — int — NOT NULL
  • Field (AUTHOR) — varchar(40)