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