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