1
2
3
4
5
6
7

CREATE TABLE transactions (
    id         INTEGER PRIMARY KEY,
    title      TEXT    NOT NULL,
    amount     INTEGER NOT NULL,
    date       DATE    NOT NULL,
    recurrance TEXT    NOT NULL
);