1
2
3
4
5
6
7
8
9

CREATE TABLE transactions (
    id         INTEGER PRIMARY KEY,
    title      TEXT    NOT NULL,
    amount     INTEGER NOT NULL,
    date       DATE    NOT NULL,
    recurrance TEXT    NOT NULL,
    week       INTEGER NOT NULL,
    is_income  BOOLEAN NOT NULL DEFAULT FALSE
);