모의 은행 서비스

테이블 (4)

거래전표 (transactions)

  • txn_id — BIGINT — 기본 키 — NOT NULL
  • type — VARCHAR(1)
  • status — VARCHAR(1)
  • src_account_id — BIGINT
  • dst_account_id — BIGINT
  • dst_bank — VARCHAR(2)
  • amount — DECIMAL(19,4)
  • idempotency_key — VARCHAR(100)
  • created_dt — TIMESTAMP
  • updated_dt — TIMESTAMP

계좌 (accounts)

  • account_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(20)
  • status — VARCHAR(1)
  • balance — DECIMAL(19,4)
  • hold_amount — DECIMAL(19,4)
  • created_dt — TIMESTAMP
  • updated_dt — TIMESTAMP

외부 송금 (holds)

  • hold_id — BIGINT — 기본 키 — NOT NULL
  • account_id — BIGINT
  • amount — DECIMAL(19,4)
  • status — VARCHAR(1)
  • idempotency_key — VARCHAR(100)
  • created_dt — TIMESTAMP
  • updated_dt — TIMESTAMP

원장 (ledger_entries)

  • entry_id — BIGINT — 기본 키 — NOT NULL
  • txn_id — BIGINT
  • account_id — BIGINT
  • amount — DECIMAL(19,4)
  • created_dt — TIMESTAMP
  • updated_dt — TIMESTAMP