budget-management
Tables (5)
budgets
- id — VARCHAR(127) — Primary key — NOT NULL
- ledger_id — VARCHAR(127)
- category — VARCHAR(63) — NOT NULL
- amount — BIGINT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
customer_refresh_tokens
- id — VARCHAR(127) — Primary key — NOT NULL
- customer_id — VARCHAR(127) — Foreign key → customers.id — NOT NULL
- value — VARCHAR(255)
- requested_at — DATETIME
customers
- id — VARCHAR(127) — Primary key — NOT NULL
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- daily_expense_recommendation_push_approved — BOOLEAN — NOT NULL
- daily_expense_analysis_push_approved — BOOLEAN — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
expenses
- Key (id) — VARCHAR(127) — Primary key — NOT NULL
- Field (customer_id) — VARCHAR(127) — NOT NULL
- Field (spent_at) — DATETIME — NOT NULL
- Field (category) — VARCHAR(63) — NOT NULL
- Field (amount) — BIGINT — NOT NULL
- Field (memo) — VARCHAR(511)
- Field (included_expense_sum) — BOOLEAN — NOT NULL
ledgers
- id — VARCHAR(127) — Primary key — NOT NULL
- customer_id — VARCHAR(127)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME