KKCSY
Tables (39)
AUDIT_LOG
- audit_id — NUMBER — Primary key
- user_id — NUMBER
- actor_id — NUMBER
- action — VARCHAR2(255)
- target — VARCHAR2(255)
- before_value — VARCHAR2(2000)
- after_value — VARCHAR2(2000)
- created_at — TIMESTAMP
CARD_ACTIVITY_METRIC
- snapshot_id — NUMBER — Primary key
- issued_count — NUMBER
- active_count — NUMBER
- density_score — NUMBER
- activity_score — NUMBER
CODE_DICTIONARY
- dict_id — NUMBER — Primary key
- version_id — NUMBER
- column_code — VARCHAR2(100)
- column_name — VARCHAR2(255)
- column_desc — VARCHAR2(1000)
- major_category — VARCHAR2(255)
- minor_category — VARCHAR2(255)
- is_required — CHAR(1)
CODE_DICTIONARY_DIFF
- diff_id — NUMBER — Primary key
- pre_version_id — NUMBER
- post_version_id — NUMBER
- change_type — VARCHAR2(100)
- column_code — VARCHAR2(100)
- before_json — CLOB
- after_json — CLOB
- created_at — TIMESTAMP
CODE_DICTIONARY_VERSION
- version_id — NUMBER — Primary key
- upload_id — NUMBER
- version_label — VARCHAR2(255)
- created_at — TIMESTAMP
COLUMN_CONFLICT_LOG
- conflict_id — NUMBER — Primary key
- column_code — VARCHAR2(100)
- conflict_type — VARCHAR2(100)
- detected_at — TIMESTAMP
CREDIT_EVENT
- event_id — NUMBER — Primary key
- user_id — NUMBER
- event_type — VARCHAR2(100)
- occurred_at — DATE
- resolved_at — DATE
CREDIT_RISK_SCORE
- snapshot_id — NUMBER — Primary key
- risk_score — NUMBER
- risk_summary — NUMBER
- risk_flag — VARCHAR2(50)
- components_json — CLOB
EDA_METRIC
- metric_id — NUMBER — Primary key
- eda_run_id — NUMBER
- metric_name — VARCHAR2(255)
- metric_type — VARCHAR2(100)
- metric_key — VARCHAR2(255)
- metric_value — CLOB
- created_at — TIMESTAMP
EDA_OUTLIER_RESULT
- outlier_id — NUMBER — Primary key
- eda_run_id — NUMBER
- row_id — NUMBER
- column_code — VARCHAR2(100)
- method — VARCHAR2(100)
- flag — CHAR(1)
- reason — VARCHAR2(1000)
EDA_RUN
- eda_run_id — NUMBER — Primary key
- user_id — NUMBER
- snapshot_id — NUMBER
- version_id — NUMBER
- created_at — TIMESTAMP
EDA_STAT_RESULT
- stat_id — NUMBER — Primary key
- eda_run_id — NUMBER
- row_id — NUMBER
- column_code — VARCHAR2(100)
- mean — NUMBER
- median — NUMBER
- std — NUMBER
- min — NUMBER
- max — NUMBER
- q1 — NUMBER
- q3 — NUMBER
- skewness — NUMBER
- kurtosis — NUMBER
- missing_rate — NUMBER
- data_type — VARCHAR2(100)
INDICATOR_DEFINITION
- indicator_code — VARCHAR2(100) — Primary key
- formula_text — VARCHAR2(2000)
- description — VARCHAR2(2000)
METADATA_LOG
- log_id — NUMBER — Primary key
- upload_id — NUMBER
- provider_id — NUMBER
- original_filename — VARCHAR2(255)
- stored_path — VARCHAR2(500)
- validation_status — VARCHAR2(50)
- validation_error — CLOB
- uploaded_at — TIMESTAMP
PRODUCT
- product_id — NUMBER — Primary key
- provider_id — NUMBER
- product_name — VARCHAR2(255)
- product_type — VARCHAR2(100)
- loan_type — VARCHAR2(100)
- repayment_type — VARCHAR2(100)
- collateral_type — VARCHAR2(100)
- rate_type — VARCHAR2(100)
- note — VARCHAR2(1000)
- add_date — TIMESTAMP
- end_date — DATE
PRODUCT_ELIGIBILITY
- product_id — NUMBER — Primary key
- min_age — NUMBER
- max_age — NUMBER
- min_income — NUMBER
- max_dti — NUMBER
- min_credit_score — NUMBER
- max_dsr — NUMBER
- employment_type — VARCHAR2(100)
PRODUCT_INTEREST_RATE
- rate_id — NUMBER — Primary key
- product_id — NUMBER
- rate_base — NUMBER
- rate_min — NUMBER
- rate_max — NUMBER
- as_of_date — DATE
PRODUCT_RATE_SNAPSHOT
- rate_id — NUMBER — Primary key
- product_id — NUMBER
- rate_min — NUMBER
- rate_max — NUMBER
- score_base — NUMBER
- as_of_date — DATE
- rate_type — VARCHAR2(100)
PROVIDER
- provider_id — NUMBER — Primary key
- provider_name — VARCHAR2(255)
- provider_type — VARCHAR2(100)
- source_group — VARCHAR2(100)
QUALITY_ISSUE
- issue_id — NUMBER — Primary key
- upload_id — NUMBER
- issue_type — VARCHAR2(100)
- column_code — VARCHAR2(100)
- detail_json — CLOB
- status — VARCHAR2(50)
- resolved_by — VARCHAR2(255)
- resolved_at — TIMESTAMP
- detected_stage — VARCHAR2(100)
- issued_at — TIMESTAMP
RAW_FILE_UPLOAD
- upload_id — NUMBER — Primary key
- file_name — VARCHAR2(255)
- file_hash — VARCHAR2(255)
- uploader_id — NUMBER
- uploaded_at — TIMESTAMP
- status — VARCHAR2(50)
RECO_ESTIMATION_DETAIL
- detail_id — NUMBER — Primary key
- item_id — NUMBER
- factor_code — VARCHAR2(100)
- factor_name — VARCHAR2(255)
- factor_value — VARCHAR2(255)
- contribution — NUMBER
RECO_EVENT_LOG
- log_id — NUMBER — Primary key
- masked_user_id — VARCHAR2(255)
- product_id — NUMBER
- event_type — VARCHAR2(100)
- occurred_at — TIMESTAMP
RECO_EXCLUSION_REASON
- reason_id — NUMBER — Primary key
- result_id — NUMBER
- product_id — NUMBER
- reason_code — VARCHAR2(100)
- reason_text — VARCHAR2(1000)
RECO_ITEM
- item_id — NUMBER — Primary key
- result_id — NUMBER
- product_id — NUMBER
- matching_score — NUMBER
- estimated_rate — NUMBER
- estimated_limit — NUMBER
- reason_json — CLOB
- rank — NUMBER
RECO_POLICY
- policy_id — NUMBER — Primary key
- version — VARCHAR2(100)
- policy_type — VARCHAR2(100)
- policy_key — VARCHAR2(255)
- policy_value — VARCHAR2(2000)
- effective_from — TIMESTAMP
- effective_to — TIMESTAMP
RECO_REJECT_LOG
- reject_id — NUMBER — Primary key
- request_id — NUMBER
- product_id — NUMBER
- reject_code — VARCHAR2(100)
- reject_reason — VARCHAR2(1000)
- created_at — TIMESTAMP
RECO_REQUEST
- request_id — NUMBER — Primary key
- user_id — NUMBER
- snapshot_id — NUMBER
- version_id — NUMBER
- requested_at — TIMESTAMP
RECO_RESULT
- result_id — NUMBER — Primary key
- request_id — NUMBER
- overall_score — NUMBER
- policy_version — VARCHAR2(100)
- confidence_level — VARCHAR2(100)
- explanation_json — CLOB
- created_at — TIMESTAMP
USER_AUTH
- auth_id — NUMBER — Primary key
- user_id — NUMBER
- login_id — VARCHAR2(255)
- password_hash — VARCHAR2(255)
- password_updated_at — TIMESTAMP
- last_login_at — TIMESTAMP
- fail_login_count — NUMBER
- is_locked — CHAR(1)
USER_CONSENT
- consent_id — NUMBER — Primary key
- user_id — NUMBER
- consent_type — VARCHAR2(100)
- agreed_yn — CHAR(1)
- agreed_at — TIMESTAMP
- expired_at — TIMESTAMP
USER_CREDIT_LV1
- user_id — NUMBER — Primary key
- age — NUMBER
- income_year — NUMBER
- gender — VARCHAR2(50)
USER_CREDIT_LV2
- user_id — NUMBER — Primary key
- employment_type — VARCHAR2(100)
- residence_type — VARCHAR2(100)
- updated_at — TIMESTAMP
USER_CREDIT_LV3
- user_id — NUMBER — Primary key
- loan_purpose — VARCHAR2(100)
- total_debt — NUMBER
- existing_loan_count — NUMBER
USER_CREDIT_SNAPSHOT
- snapshot_id — NUMBER — Primary key
- user_id — NUMBER
- monthly_payment — NUMBER
- created_at — TIMESTAMP
USER_DEBT_DETAIL
- debt_id — NUMBER — Primary key
- user_id — NUMBER
- debt_type — VARCHAR2(100)
- balance — NUMBER
- monthly_payment — NUMBER
- created_at — TIMESTAMP
USER_INPUT_HISTORY
- history_id — NUMBER — Primary key
- user_id — NUMBER
- input_type — VARCHAR2(100)
- input_json — CLOB
- created_at — TIMESTAMP
USER_PROFILE
- user_id — NUMBER — Primary key
- username — VARCHAR2(255)
- role — VARCHAR2(50)
- created_at — TIMESTAMP
USER_RISK_DETAIL
- risk_id — NUMBER — Primary key
- user_id — NUMBER
- credit_score — NUMBER
- dti — NUMBER
- dsr — NUMBER
- repayment_cap — NUMBER
- stability_score — NUMBER
- normalized_soc — CLOB
- created_at — TIMESTAMP