tasks — Schema
9 rows — 9 columns
| Column | Type | Constraints |
|---|---|---|
| id | INTEGER | PK |
| title | TEXT | NOT NULL |
| area | TEXT | IN (work, health, faith, personal) |
| priority | TEXT | NOT NULL DEFAULT 'medium' IN (high, medium, low) |
| status | TEXT | NOT NULL DEFAULT 'todo' IN (todo, in_progress, done) |
| due_date | TEXT | |
| scheduled_date | TEXT | |
| goal_id | INTEGER | FK → goals.id |
| created_at | TEXT | DEFAULT datetime('now') |
CREATE Statement
CREATE TABLE tasks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
area TEXT CHECK(area IN ('work','health','faith','personal')),
priority TEXT NOT NULL DEFAULT 'medium' CHECK(priority IN ('high','medium','low')),
status TEXT NOT NULL DEFAULT 'todo' CHECK(status IN ('todo','in_progress','done')),
due_date TEXT,
scheduled_date TEXT,
goal_id INTEGER REFERENCES goals(id),
created_at TEXT DEFAULT (datetime('now'))
)