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