milestones — Schema
0 rows — 5 columns
| Column | Type | Constraints |
|---|---|---|
| id | INTEGER | PK |
| goal_id | INTEGER | FK → goals.id |
| title | TEXT | NOT NULL |
| status | TEXT | NOT NULL DEFAULT 'pending' IN (pending, done) |
| due_date | TEXT |
CREATE Statement
CREATE TABLE milestones (
id INTEGER PRIMARY KEY AUTOINCREMENT,
goal_id INTEGER REFERENCES goals(id),
title TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'pending' CHECK(status IN ('pending','done')),
due_date TEXT
)