CCKSY2

Tables (38)

AUDIT_LOG

  • audit_id — NUMBER
  • 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
  • issued_count — NUMBER
  • active_count — NUMBER
  • density_score — NUMBER
  • activity_score — NUMBER

CODE_DICTIONARY

  • dict_id — NUMBER
  • 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
  • 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
  • upload_id — NUMBER
  • version_label — VARCHAR2(255)
  • created_at — TIMESTAMP

COLUMN_CONFLICT_LOG

  • conflict_id — NUMBER
  • column_code — VARCHAR2(100)
  • conflict_type — VARCHAR2(100)
  • detected_at — TIMESTAMP

CREDIT_EVENT

  • event_id — NUMBER
  • user_id — NUMBER
  • event_type — VARCHAR2(100)
  • occurred_at — DATE
  • resolved_at — DATE

CREDIT_RISK_SCORE

  • snapshot_id — NUMBER
  • risk_score — NUMBER
  • risk_summary — NUMBER
  • risk_flag — VARCHAR2(50)
  • components_json — CLOB

EDA_METRIC

  • metric_id — NUMBER
  • 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
  • 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
  • user_id — NUMBER
  • snapshot_id — NUMBER
  • version_id — NUMBER
  • created_at — TIMESTAMP

EDA_STAT_RESULT

  • stat_id — NUMBER
  • 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)
  • formula_text — VARCHAR2(2000)
  • description — VARCHAR2(2000)

METADATA_LOG

  • log_id — NUMBER
  • 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
  • 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
  • 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
  • product_id — NUMBER
  • rate_base — NUMBER
  • rate_min — NUMBER
  • rate_max — NUMBER
  • as_of_date — DATE

PRODUCT_RATE_SNAPSHOT

  • rate_id — NUMBER
  • product_id — NUMBER
  • rate_min — NUMBER
  • rate_max — NUMBER
  • score_base — NUMBER
  • as_of_date — DATE
  • rate_type — VARCHAR2(100)

PROVIDER

  • provider_id — NUMBER
  • provider_name — VARCHAR2(255)
  • provider_type — VARCHAR2(100)
  • source_group — VARCHAR2(100)

QUALITY_ISSUE

  • issue_id — NUMBER
  • 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

RECO_ESTIMATION_DETAIL

  • detail_id — NUMBER
  • item_id — NUMBER
  • factor_code — VARCHAR2(100)
  • factor_name — VARCHAR2(255)
  • factor_value — VARCHAR2(255)
  • contribution — NUMBER

RECO_EVENT_LOG

  • log_id — NUMBER
  • masked_user_id — VARCHAR2(255)
  • product_id — NUMBER
  • event_type — VARCHAR2(100)
  • occurred_at — TIMESTAMP

RECO_EXCLUSION_REASON

  • reason_id — NUMBER
  • result_id — NUMBER
  • product_id — NUMBER
  • reason_code — VARCHAR2(100)
  • reason_text — VARCHAR2(1000)

RECO_ITEM

  • item_id — NUMBER
  • 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
  • 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
  • request_id — NUMBER
  • product_id — NUMBER
  • reject_code — VARCHAR2(100)
  • reject_reason — VARCHAR2(1000)
  • created_at — TIMESTAMP

RECO_REQUEST

  • request_id — NUMBER
  • user_id — NUMBER
  • snapshot_id — NUMBER
  • version_id — NUMBER
  • requested_at — TIMESTAMP

RECO_RESULT

  • result_id — NUMBER
  • 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
  • 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
  • user_id — NUMBER
  • consent_type — VARCHAR2(100)
  • agreed_yn — CHAR(1)
  • agreed_at — TIMESTAMP
  • expired_at — TIMESTAMP

USER_CREDIT_LV1

  • user_id — NUMBER
  • age — NUMBER
  • income_year — NUMBER
  • gender — VARCHAR2(50)

USER_CREDIT_LV2

  • user_id — NUMBER
  • employment_type — VARCHAR2(100)
  • residence_type — VARCHAR2(100)
  • updated_at — TIMESTAMP

USER_CREDIT_LV3

  • user_id — NUMBER
  • loan_purpose — VARCHAR2(100)
  • total_debt — NUMBER
  • existing_loan_count — NUMBER

USER_CREDIT_SNAPSHOT

  • snapshot_id — NUMBER
  • user_id — NUMBER
  • monthly_payment — NUMBER
  • created_at — TIMESTAMP

USER_DEBT_DETAIL

  • debt_id — NUMBER
  • user_id — NUMBER
  • debt_type — VARCHAR2(100)
  • balance — NUMBER
  • monthly_payment — NUMBER
  • created_at — TIMESTAMP

USER_INPUT_HISTORY

  • history_id — NUMBER
  • user_id — NUMBER
  • input_type — VARCHAR2(100)
  • input_json — CLOB
  • created_at — TIMESTAMP

USER_PROFILE

  • user_id — NUMBER
  • username — VARCHAR2(255)
  • role — VARCHAR2(50)
  • created_at — TIMESTAMP

USER_RISK_DETAIL

  • risk_id — NUMBER
  • user_id — NUMBER
  • credit_score — NUMBER
  • dti — NUMBER
  • dsr — NUMBER
  • repayment_cap — NUMBER
  • stability_score — NUMBER
  • normalized_soc — CLOB
  • created_at — TIMESTAMP