boost_todo
Tables (4)
Untitled (user)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
- Field (userId) — varchar(20) — NOT NULL
- Field (password) — varchar(200) — NOT NULL
Untitled (todo_column)
- Key (id) — int — Primary key — NOT NULL
- Key (userId) — int — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(20) — NOT NULL
Untitled (todo)
- Key (id) — int — Primary key — NOT NULL
- Key (userId) — int — Foreign key → Untitled.Key — NOT NULL
- Key (columnId) — int — Foreign key → Untitled.Key — NOT NULL
- Field (title) — varchar(40) — NOT NULL
- Field (content) — text — NOT NULL
- Field (moveUpdatedAt) — datetime
- Field (next) — int
Untitled (log)
- Key (id) — int — Primary key — NOT NULL
- Key (userId) — int — Foreign key → Untitled.Key — NOT NULL
- Field (logType) — 'add', 'remove', 'update','todo' — NOT NULL
- Field (title) — varchar(40) — NOT NULL
- Field (target) — 'user','column','todo' — NOT NULL
- Field (targetForm) — varchar(20)
- Field (targetTo) — varchar(20)
- Field (createdAt) — datetime — NOT NULL