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)