ERD

Tables (6)

accounts

  • id — INT
  • user_id — INT — NOT NULL
  • account_name — VARCHAR(100) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • initial_balance — INT — NOT NULL
  • current_balance — INT — NOT NULL
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

alert_settings

  • id — INT
  • user_id — INT — NOT NULL
  • account_id — INT
  • alert_type — VARCHAR(50) — NOT NULL
  • threshold_amount — INT
  • is_active — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL

analysis_reports

  • id — INT
  • user_id — INT — NOT NULL
  • period_type — VARCHAR(20) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • total_income — INT — NOT NULL
  • total_expense — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

notifications

  • id — INT
  • user_id — INT — NOT NULL
  • alert_setting_id — INT
  • account_id — INT
  • transaction_id — INT
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • read_at — DATETIME

transactions

  • id — INT
  • account_id — INT — NOT NULL
  • amount — INT — NOT NULL
  • transaction_type — VARCHAR(20) — NOT NULL
  • occurred_at — DATETIME — NOT NULL
  • description — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME

users

  • id — INT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50)
  • nickname — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • is_active — TINYINT(1) — NOT NULL
  • is_admin — TINYINT(1) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME