corebank
Tables (23)
account
- account_id — BIGINT — Primary key — NOT NULL
- account_number — CHAR(12) — NOT NULL — 하이픈 없는 숫자 12자리
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — 입출금계좌는 NULL
- account_type — VARCHAR(24) — NOT NULL — DEMAND_DEPOSIT / TIME_DEPOSIT / INSTALLMENT_SAVINGS
- balance — BIGINT — NOT NULL — 원장 대사 대상
- status — VARCHAR(12) — NOT NULL — ACTIVE / SUSPENDED / CLOSED
- password_hash — CHAR(60) — NOT NULL — 계좌비밀번호 BCrypt
- password_failure_count — TINYINT — NOT NULL
- password_locked — BOOLEAN — NOT NULL — APW0101
- alias — VARCHAR(24) — 계좌별명. 한글 12자·영숫자 24자 (ACC0001)
- display_order — INT — 사용자 지정 표시순서
- withdrawal_registered — BOOLEAN — NOT NULL — 응답 withdrawalAccountRegistered
- withdrawal_registered_at — DATETIME(6)
- opened_date — DATE — NOT NULL
- maturity_date — DATE
- closed_date — DATE
- last_transaction_at — DATETIME(6)
- version — BIGINT — NOT NULL — 낙관적 락
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
audit_log
- audit_log_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT
- transaction_number — CHAR(20)
- event_type — VARCHAR(40) — NOT NULL
- request_ip — VARCHAR(45) — NOT NULL
- result — VARCHAR(12) — NOT NULL — SUCCESS / FAILURE
- detail — JSON — 민감정보 마스킹 후 저장
- requested_at — DATETIME(6) — NOT NULL
auto_transfer
- auto_transfer_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- withdrawal_account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- deposit_account_number — CHAR(12) — NOT NULL
- payee_name — VARCHAR(50) — NOT NULL
- amount — BIGINT — NOT NULL
- cycle_months — TINYINT — NOT NULL — 1 / 3 / 6
- transfer_day — TINYINT — NOT NULL — 1~31 (AUT0001)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL — 60개월 이내 (AUT0002)
- next_execution_date — DATE — NOT NULL
- my_passbook_memo — VARCHAR(10)
- recipient_passbook_memo — VARCHAR(10)
- status — VARCHAR(12) — NOT NULL — NORMAL / EXPIRED / TERMINATED (AutoTransferStatus)
- registered_at — DATETIME(6) — NOT NULL
- terminated_at — DATETIME(6)
- updated_at — DATETIME(6) — NOT NULL
- active_dup_key — VARCHAR(64)
auto_transfer_execution
- execution_id — BIGINT — Primary key — NOT NULL
- auto_transfer_id — BIGINT — Foreign key → auto_transfer.auto_transfer_id — NOT NULL
- execution_date — DATE — NOT NULL
- amount — BIGINT — NOT NULL
- status — VARCHAR(12) — NOT NULL — SUCCESS / ERROR / PROCESSING (ProcessResultStatus)
- transaction_number — CHAR(20)
- failure_reason — VARCHAR(200)
- executed_at — DATETIME(6) — NOT NULL
customer
- customer_id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(20) — NOT NULL — 로그인 아이디
- password_hash — CHAR(60) — NOT NULL — BCrypt
- user_name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone_number — VARCHAR(11) — NOT NULL — 하이픈 없음
- login_failure_count — TINYINT — NOT NULL — 5회 시 잠금 (ATH0102)
- account_locked — BOOLEAN — NOT NULL
- display_order_type — VARCHAR(20) — NOT NULL — CUSTOM / OPENED_DATE_ASC
- last_login_at — DATETIME(6) — 대시보드 currentLoginAt
- last_login_ip — VARCHAR(45) — 대시보드 currentLoginIp
- previous_login_at — DATETIME(6) — 대시보드 previousLoginAt
- password_changed_at — DATETIME(6)
- joined_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
customer_terms_agreement
- agreement_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
- agreed_at — DATETIME(6) — NOT NULL
favorite_account
- favorite_account_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- deposit_account_number — CHAR(12) — NOT NULL
- payee_name — VARCHAR(50) — NOT NULL — 등록 시점 예금주 스냅샷
- alias — VARCHAR(24) — 미지정 시 예금주명 (FAV0001)
- registered_at — DATETIME(6) — NOT NULL
idempotency_key
- idempotency_key — CHAR(36) — Primary key — NOT NULL — UUID v4
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- endpoint — VARCHAR(120) — NOT NULL
- request_hash — CHAR(64) — NOT NULL — SHA-256. *AuthToken 필드 제외 후 계산
- state — VARCHAR(12) — NOT NULL — PROCESSING / COMPLETED
- http_status — SMALLINT
- response_snapshot — JSON
- created_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL — 24시간 후 배치 삭제
ledger_entry
- ledger_entry_id — BIGINT — Primary key — NOT NULL
- occurred_at — DATETIME(6) — Primary key — NOT NULL — RANGE PARTITION KEY
- account_id — BIGINT — NOT NULL
- transfer_id — BIGINT — 이체 외 기표(상품가입 초입금 등)는 NULL
- transaction_number — CHAR(20) — NOT NULL — 짝이 되는 2행이 동일
- direction — VARCHAR(10) — NOT NULL — DEPOSIT / WITHDRAWAL
- amount — BIGINT — NOT NULL — 양수만. 방향은 direction 이 표현
- balance_after — BIGINT — NOT NULL — 기표 직후 잔액
- transaction_type — VARCHAR(32) — NOT NULL — IMMEDIATE_TRANSFER / SCHEDULED_TRANSFER / AUTO_TRANSFER / PRODUCT_SUBSCRIPTION / INTEREST / REVERSAL
- transaction_content — VARCHAR(10) — 통장 표시내용
- channel — CHAR(2) — NOT NULL — WB / BT
- reversed — BOOLEAN — NOT NULL
- reversal_id — BIGINT — 반대기표가 가리키는 원거래
- PARTITION — p202609
- PARTITION — p202610
- PARTITION — p202611
- PARTITION — p202612
- PARTITION — pmax
notification
- notification_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- type — VARCHAR(24) — NOT NULL — TRANSFER / SCHEDULED_TRANSFER / AUTO_TRANSFER / PRODUCT_SUBSCRIPTION
- ref_id — BIGINT — 다형 참조: TRANSFER->transfer.transfer_id / SCHEDULED_TRANSFER->scheduled_transfer_id / AUTO_TRANSFER->auto_transfer_execut…
- title — VARCHAR(100) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- read_at — DATETIME(6)
- occurred_at — DATETIME(6) — NOT NULL
product
- product_id — BIGINT — Primary key — NOT NULL
- product_code — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(100) — NOT NULL
- product_group — VARCHAR(12) — NOT NULL — SAVINGS(정기적금) / DEPOSIT(정기예금)
- deposit_type — VARCHAR(20) — NOT NULL — 거치식 / 적립식
- summary — VARCHAR(200)
- description — TEXT
- base_rate — DECIMAL(5, 2) — NOT NULL
- max_rate — DECIMAL(5, 2) — NOT NULL
- min_amount — BIGINT — NOT NULL
- max_amount — BIGINT — NOT NULL
- amount_unit — BIGINT — NOT NULL — 배수 검증 (PRD0004)
- min_term_months — SMALLINT — NOT NULL
- max_term_months — SMALLINT — NOT NULL
- interest_pay_type — VARCHAR(20) — NOT NULL — 단리 / 복리
- sale_status — VARCHAR(12) — NOT NULL — ON_SALE / SUSPENDED
- sale_start_date — DATE
- sale_end_date — DATE
- new_flag — BOOLEAN — NOT NULL
- single_account_limit — BOOLEAN — NOT NULL — 1인 1계좌 제한 상품 (PRD0301)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
product_preferential_rate
- condition_code — VARCHAR(30) — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- condition_name — VARCHAR(100) — NOT NULL
- rate — DECIMAL(5,2) — NOT NULL
product_rate_tier
- term_months — SMALLINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- rate — DECIMAL(5,2) — NOT NULL
product_subscription
- subscription_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- account_id — BIGINT — Foreign key → account.account_id — 가입으로 개설된 계좌
- withdrawal_account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 초입금 출금계좌
- subscription_amount — BIGINT — NOT NULL
- term_months — SMALLINT — NOT NULL
- payment_day — TINYINT — 1~28, 적립식만
- base_rate — DECIMAL(5, 2) — NOT NULL
- preferential_rate — DECIMAL(5, 2) — NOT NULL
- applied_rate — DECIMAL(5, 2) — NOT NULL
- maturity_handling — VARCHAR(12) — NOT NULL — TRANSFER / RENEW
- expected_maturity_amount — BIGINT
- status — VARCHAR(12) — NOT NULL — SUCCESS / ERROR / PROCESSING
- transaction_number — CHAR(20) — 초입금 거래번호
- opened_date — DATE
- maturity_date — DATE
- subscribed_at — DATETIME(6) — NOT NULL
product_terms
- product_id — BIGINT — Foreign key → product.product_id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
- required — BOOLEAN — NOT NULL
scheduled_transfer
- scheduled_transfer_id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- withdrawal_account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- payee_bank_code — CHAR(3) — NOT NULL — 당행 상수. bank 테이블 없음
- payee_account_number — CHAR(12) — NOT NULL
- payee_name — VARCHAR(50) — NOT NULL
- amount — BIGINT — NOT NULL
- scheduled_date — DATE — NOT NULL — 익일~1년 이내 (SCD0001)
- my_passbook_memo — VARCHAR(10)
- recipient_passbook_memo — VARCHAR(10)
- status — VARCHAR(12) — NOT NULL — WAITING / PROCESSING / SUCCESS / FAILED / CANCELED
- transaction_number — CHAR(20)
- registered_at — DATETIME(6) — NOT NULL
- executed_at — DATETIME(6)
- canceled_at — DATETIME(6)
- failure_reason — VARCHAR(200)
- active_dup_key — VARCHAR(80)
subscription_terms_agreement
- subscription_id — BIGINT — Foreign key → product_subscription.subscription_id — NOT NULL
- terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
- terms_version — VARCHAR(10) — NOT NULL — 동의 시점 버전 (PRD0006)
- read_at — DATETIME(6) — 전문 열람 시각 (PRD0005)
- agreed_at — DATETIME(6) — NOT NULL
terms
- terms_id — BIGINT — Primary key — NOT NULL
- terms_code — VARCHAR(30) — NOT NULL
- version — VARCHAR(10) — NOT NULL
- terms_type — VARCHAR(20) — NOT NULL — SIGNUP / PRODUCT
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- is_required — BOOLEAN — NOT NULL
- view_required — BOOLEAN — NOT NULL — 전문 열람 강제 (PRD0005)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
transaction_sequence
- seq_date — DATE — Primary key — NOT NULL — KST 기준 영업일
- channel — CHAR(2) — Primary key — NOT NULL — WB / BT
- last_seq — BIGINT — NOT NULL — 해당 일자·채널의 마지막 일련번호
- updated_at — DATETIME(6) — NOT NULL
transfer
- transfer_id — BIGINT — Primary key — NOT NULL
- transaction_number — CHAR(20) — NOT NULL — YYYYMMDD + 채널2 + 일련10
- withdrawal_account_id — BIGINT — Foreign key → account.account_id — NOT NULL
- deposit_account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 원장 입금행의 근거. 1차는 당행 전용이라 NOT NULL
- deposit_account_number — CHAR(12) — NOT NULL
- payee_name — VARCHAR(50) — NOT NULL — 거래 시점 스냅샷
- amount — BIGINT — NOT NULL
- fee — BIGINT — NOT NULL — 당행 0 고정 (POL-028)
- transfer_type — VARCHAR(12) — NOT NULL — IMMEDIATE / SCHEDULED / AUTO
- channel — CHAR(2) — NOT NULL — WB / BT
- status — VARCHAR(12) — NOT NULL — SUCCESS / ERROR / PROCESSING
- source_type — VARCHAR(12) — SCHEDULED / AUTO
- source_id — BIGINT
- my_passbook_memo — VARCHAR(10) — TRF0005 최대 10자
- recipient_passbook_memo — VARCHAR(10)
- withdrawal_balance_after — BIGINT
- error_code — VARCHAR(10)
- error_message — VARCHAR(200)
- transferred_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
transfer_limit
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- one_time_limit — BIGINT — NOT NULL
- daily_limit — BIGINT — NOT NULL
- version — BIGINT — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
transfer_limit_daily_usage
- usage_date — DATE — Primary key — NOT NULL — KST 기준 영업일
- customer_id — BIGINT — Foreign key → customer.customer_id — NOT NULL
- used_amount — BIGINT — NOT NULL — SUCCESS 확정 건만 합산
- updated_at — DATETIME(6) — NOT NULL
verification_request
- verification_request_id — VARCHAR(64) — Primary key — NOT NULL — EVF_ / PRR_ / OTP_REQ_ 접두어 + CSPRNG 난수
- purpose — VARCHAR(24) — NOT NULL — SIGN_UP / EMAIL_CHANGE / PASSWORD_RESET / OTP_TRANSACTION
- customer_id — BIGINT — Foreign key → customer.customer_id — 회원가입 전에는 NULL
- target — VARCHAR(100) — 이메일 주소 등 인증 대상
- code_hash — CHAR(60) — NOT NULL — 인증번호·OTP 단방향 해시 (REQ-NFR-009)
- transaction_type — VARCHAR(32) — OTP 전용. IMMEDIATE_TRANSFER 등
- transaction_data — JSON — OTP 전용. 거래 내용 변조 검증
- error_count — TINYINT — NOT NULL — 5회 초과 시 OTP0103
- locked — BOOLEAN — NOT NULL
- used — BOOLEAN — NOT NULL
- verified_at — DATETIME(6)
- expires_at — DATETIME(6) — NOT NULL — 발급 + 180초
- created_at — DATETIME(6) — NOT NULL