Home

mint @c32dcc68dbf0cacc9e749a5916729b80e2717d1e - refs - log -
-
https://git.jolheiser.com/mint.git
Budget
mint / database / sqlc / migrations / 001_schema.up.sql
- raw -
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
);