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