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