flexrate-erd 초안

테이블 (11)

AuditLog

  • log_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • event_type — ENUM('LOGIN', 'PASSWORD_CHANGE', 'PASSKEY_REGISTER', 'LOAN_APPLY', 'ERROR') — NOT NULL
  • auth_method — ENUM('PASSWORD', 'PASSKEY', 'MFA')
  • detail — TEXT
  • occurred_at — DATETIME — NOT NULL
  • ip_address — VARCHAR(45)
  • device_info — VARCHAR(255)

FidoCredential

  • credential_id — VARCHAR — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • public_key — TEXT — NOT NULL
  • sign_count — INT — NOT NULL
  • registered_at — DATETIME — NOT NULL
  • last_used_at — DATETIME
  • device_info — VARCHAR
  • is_active — BOOLEAN — NOT NULL

JwtToken

  • jwt_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • token — VARCHAR — NOT NULL
  • issued_at — DATETIME — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • ip_address — VARCHAR
  • device_info — VARCHAR

LoanApplication

  • application_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • product_id — UUID — 외래 키 → LoanProduct.product_id — NOT NULL
  • applied_at — DATETIME — NOT NULL
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED', 'EXECUTED') — NOT NULL
  • executed_at — DATETIME
  • amount — DECIMAL — NOT NULL
  • rate — DECIMAL — NOT NULL
  • review_result — TEXT

LoanProduct

  • product_id — UUID — 기본 키 — NOT NULL
  • name — VARCHAR — NOT NULL
  • description — TEXT
  • max_amount — DECIMAL — NOT NULL
  • min_rate — DECIMAL — NOT NULL
  • max_rate — DECIMAL — NOT NULL
  • terms — VARCHAR

LoanTransaction

  • transaction_id — UUID — 기본 키 — NOT NULL
  • application_id — UUID — 외래 키 → LoanApplication.application_id — NOT NULL
  • type — ENUM('EXECUTION', 'REPAYMENT', 'DELAY') — NOT NULL
  • amount — DECIMAL — NOT NULL
  • occurred_at — DATETIME — NOT NULL
  • status — ENUM('NORMAL', 'FAILED', 'CANCELLED') — NOT NULL

MfaLog

  • mfa_log_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • mfa_type — ENUM('PASS', 'EMAIL', 'SMS') — NOT NULL
  • result — ENUM('SUCCESS', 'FAILURE') — NOT NULL
  • authenticated_at — DATETIME — NOT NULL
  • transaction_id — UUID
  • ip_address — VARCHAR
  • device_info — VARCHAR

Notification

  • notification_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • type — ENUM('LOAN_APPROVAL', 'MATURITY_NOTICE') — NOT NULL
  • content — TEXT — NOT NULL
  • sent_at — DATETIME — NOT NULL
  • is_read — BOOLEAN — NOT NULL

PasswordResetToken

  • token_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • token — VARCHAR — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • used — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

User

  • user_id — UUID — 기본 키 — NOT NULL
  • email — VARCHAR — NOT NULL
  • password_hash — VARCHAR — NOT NULL
  • password_last_changed_at — DATETIME
  • name — VARCHAR — NOT NULL
  • phone — VARCHAR — NOT NULL
  • birth_date — DATE
  • created_at — DATETIME
  • updated_at — DATETIME
  • status — ENUM('ACTIVE', 'WITHDRAWN', 'SUSPENDED') — NOT NULL
  • last_login_at — DATETIME
  • last_login_method — ENUM('PASSWORD', 'PASSKEY', 'SOCIAL')
  • pass_linked — BOOLEAN
  • mfa_enabled — BOOLEAN
  • refresh_token — VARCHAR
  • refresh_token_expiry — DATETIME

UserFinancialData

  • data_id — UUID — 기본 키 — NOT NULL
  • user_id — UUID — 외래 키 → User.user_id — NOT NULL
  • data_type — ENUM('INCOME', 'EXPENSE', 'CREDIT_SCORE', 'LOAN_BALANCE') — NOT NULL
  • value — VARCHAR — NOT NULL
  • collected_at — DATETIME — NOT NULL
  • source — VARCHAR