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)