test
Tables (4)
categories
- id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → users.id
- name — varchar(255) — NOT NULL
recurring_transaction
- id — bigint — Primary key — NOT NULL
- amount — bigint
- day_of_month — int
- end_date — date
- is_done — bit(1) — NOT NULL
- memo — varchar(255)
- start_date — date
- category_id — bigint — Foreign key → categories.id
- user_id — bigint — Foreign key → users.id
transactions
- id — bigint — Primary key — NOT NULL
- date — date — NOT NULL
- amount — bigint — NOT NULL
- category_id — bigint — Foreign key → categories.id
- user_id — bigint — Foreign key → users.id — NOT NULL
- memo — varchar(255)
- type — enum('EXPENSE','INCOME') — NOT NULL
- recurring_transaction_id — bigint — Foreign key → recurring_transaction.id
- expense_type — enum('FIXED','VARIABLE')
users
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- username — varchar(255) — NOT NULL