goals — Schema
0 rows — 4 columns
| Column | Type | Constraints |
|---|---|---|
| id | INTEGER | PK |
| title | TEXT | NOT NULL |
| status | TEXT | NOT NULL DEFAULT 'active' IN (active, completed, archived) |
| area | TEXT | IN (work, health, faith, personal) |
CREATE Statement
CREATE TABLE goals (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
status TEXT NOT NULL DEFAULT 'active' CHECK(status IN ('active','completed','archived')),
area TEXT CHECK(area IN ('work','health','faith','personal'))
)