accountt_manage
테이블 (9)
거래 (b_transactions)
- transaction_id — CHAR(36)
- account_id — CHAR(36)
- user_id — CHAR(36)
- policy_id — CHAR(36)
- txn_type — ENUM('DEPOSIT','WITHDRAWAL','TRANSFER','LOAN_REPAYMENT') — NOT NULL
- occurred_at — DATETIME(3) — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- fee_amount — DECIMAL(18,2) — NOT NULL
- deposit_channel — ENUM('ATM','ONLINE','AUTO')
- memo — VARCHAR(255)
- CHECK — (amount > 0)
계좌 (b_accounts)
- account_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- policy_id — CHAR(36)
- account_number — VARCHAR(32) — NOT NULL
- account_type — ENUM('DEPOSIT','SAVINGS','LOAN') — NOT NULL
- current_balance — DECIMAL(18,2) — NOT NULL
- min_balance — DECIMAL(18,2) — NOT NULL
- daily_limit — DECIMAL(18,2)
- locked_until — DATETIME(3)
- status — ENUM('ACTIVE','CLOSED','FROZEN','LOCKED') — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
계좌 잔액 (account_balance)
- account_id — CHAR(36)
- available — DECIMAL(18,2) — NOT NULL
- pending — DECIMAL(18,2) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- version — BIGINT — NOT NULL
등급 (b_grade)
- grade_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- policy_id — CHAR(36)
- monthly_balance — DECIMAL(18,2) — NOT NULL
- discount — DECIMAL(5,2)
- amount — DECIMAL(18,2) — NOT NULL
- calc_yyyymm — CHAR(6) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
수수료정책 (fee_policy)
- policy_id — CHAR(36)
- policy_name — VARCHAR(100) — NOT NULL
- discount_rate — DECIMAL(5,2)
- limit_value — DECIMAL(18,2) — NOT NULL
- apply_user_level — ENUM('BRONZE','SILVER','GOLD','PLATINUM','VIP')
- apply_txn_type — ENUM('DEPOSIT','WITHDRAWAL','TRANSFER','LOAN_REPAYMENT')
- min_txn_amount — DECIMAL(18,2)
- max_txn_amount — DECIMAL(18,2)
- created_at — DATETIME(3) — NOT NULL
- CHECK — (min_txn_amount IS NULL OR max_txn_amount IS NULL OR min_txn_amount <= max_txn_amount)
원장 트랜잭션 (b_ledger_txn)
- txn_id — CHAR(36)
- type — ENUM('DEPOSIT','WITHDRAWAL','TRANSFER','FEE','LOAN_DISBURSE','LOAN_REPAYMENT','LOAN_AUTO_WITHDRAW') — NOT NULL
- requested_by — CHAR(36)
- effective_at — DATETIME(3) — NOT NULL
- ref_text — VARCHAR(200)
- attributes — JSON
- created_at — DATETIME(3) — NOT NULL
원장 항목 (ledger_entry)
- entry_id — CHAR(36)
- txn_id — CHAR(36) — NOT NULL
- account_id — CHAR(36) — NOT NULL
- entry_type — ENUM('DEBIT','CREDIT') — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- balance_after — DECIMAL(18,2)
- created_at — DATETIME(3) — NOT NULL
- CHECK — (amount > 0)
자동이체 (b_auto_transfer)
- auto_transfer_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- from_account_id — CHAR(36) — NOT NULL
- to_account_id — CHAR(36) — NOT NULL
- amount — DECIMAL(18,2) — NOT NULL
- cron_expr — VARCHAR(120) — NOT NULL
- time_zone — VARCHAR(50) — NOT NULL
- start_at — DATETIME(3)
- end_at — DATETIME(3)
- is_active — TINYINT(1) — NOT NULL
- last_run_at — DATETIME(3)
- next_run_at — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
- CHECK — (amount > 0)
자동이체 실행로그 (auto_transfer_run)
- run_id — CHAR(36)
- auto_transfer_id — CHAR(36) — NOT NULL
- scheduled_for — DATETIME(3) — NOT NULL
- started_at — DATETIME(3) — NOT NULL
- finished_at — DATETIME(3)
- status — ENUM('PENDING','SUCCESS','FAILED','SKIPPED') — NOT NULL
- error_message — VARCHAR(500)