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