[myplanet] focus-to-do
Tables (10)
Color (Untitled3)
- Key — INT(4) — Primary key — NOT NULL
- Field — VARCHAR(10)
- Field2 — DATETIME
- Field3 — DATETIME
- Field4 — DATETIME
Folder (Untitled2)
- Key — INT(4) — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Color.Key — NOT NULL
- Field — VARCHAR(45)
- Field2 — DATETIME
- Field3 — DATETIME
- Field4 — DATETIME
Pomodoro (Untitled6)
- Key — INT(4) — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Work.Key — NOT NULL
- Key (Key42) — INT(4) — Foreign key → Work.Key — NOT NULL
- Field (시작 시간) — DATETIME
- Field2 (끝난 시간) — DATETIME
- Field3 (경과 시간) — DATETIME
PomodoroHistory (Untitled10)
- Key — INT(4) — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Work.Key — NOT NULL
- Field — DATETIME
- Field2 — DATETIME
- Field3
Project (Untitled4)
- Key — INT(4) — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Folder.Key — NOT NULL
- Key (Key3) — INT(4) — Foreign key → Color.Key — NOT NULL
- Key (Key4) — INT(4) — Foreign key → User.Key — NOT NULL
- Field — VARCHAR(45)
- Field2 — DATETIME
- Field3 — DATETIME
- Field4 — DATETIME
- Field6
SubWork (Untitled9)
- Key — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Work.Key — NOT NULL
- Field — VARCHAR
- Field2 — DATETIME
- Field3 — DATETIME
- Field4 — BOOLEAN
Tag (Untitled7)
- Key — INT(4) — Primary key — NOT NULL
- Field — VARCHAR(45)
- Field2 — DATETIME
- Field3 — DATETIME
- Field4 — DATETIME
User (Untitled5)
- Key — INT(4) — Primary key — NOT NULL
- Field — VARCHAR(45)
- Field2 — VARCHAR(45)
Work (Untitled)
- Key — INT(4) — Primary key — NOT NULL
- Key (Key2) — INT(4) — Foreign key → Folder.Key — NOT NULL
- Key (Key3) — INT(4) — Foreign key → User.Key — NOT NULL
- Key (Key4) — INT(4) — Foreign key → Project.Key — NOT NULL
- Key (Key42) — INT(4) — Foreign key → Project.Key — NOT NULL
- Field — VARCHAR(45)
- Field2 — VARCHAR(2000)
- Field3
- Field4 — INT(2)
- Field5 — INT(4)
- Field6 — INT(4)
- Field7 — DATE
- Field8 — BOOLEAN
- Field9
- Field10