Taskify

Tables (3)

Untitled (Task)

  • Key (id) — int — Primary key — NOT NULL
  • Field (title) — String
  • Field (content) — String
  • Field (createdTime) — datetime
  • Field (isDeleted) — bool
  • Key2 (categoryId) — int — Foreign key → Untitled.Key2 — NOT NULL

Untitled (Category)

  • Key2 (id) — int — Primary key — NOT NULL
  • Field (name) — String

Untitled (History)

  • Key (actionTime) — datetime — Primary key — NOT NULL
  • Field (action) — String
  • Field (taskTitle) — String
  • Field (category) — String — NOT NULL
  • Field (prevCategory) — String — NOT NULL