모의 은행 서비스
테이블 (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