habits — Schema
0 rows — 4 columns
| Column | Type | Constraints |
|---|---|---|
| id | INTEGER | PK |
| title | TEXT | NOT NULL |
| frequency | TEXT | NOT NULL DEFAULT 'daily' |
| active | INTEGER | NOT NULL DEFAULT 1 |
CREATE Statement
CREATE TABLE habits (
id INTEGER PRIMARY KEY AUTOINCREMENT,
title TEXT NOT NULL,
frequency TEXT NOT NULL DEFAULT 'daily',
active INTEGER NOT NULL DEFAULT 1
)