habit_log — Schema
0 rows — 4 columns
| Column | Type | Constraints |
|---|---|---|
| id | INTEGER | PK |
| habit_id | INTEGER | FK → habits.id |
| date | TEXT | NOT NULL |
| completed | INTEGER | NOT NULL DEFAULT 0 |
CREATE Statement
CREATE TABLE habit_log (
id INTEGER PRIMARY KEY AUTOINCREMENT,
habit_id INTEGER REFERENCES habits(id),
date TEXT NOT NULL,
completed INTEGER NOT NULL DEFAULT 0
)