금융 서비스 이탈 가능 고객 예측 현황 시스템

테이블 (15)

M_BRANCH

  • BRANCH_ID — NUMBER — 기본 키 — NOT NULL
  • BRANCH_NAME — VARCHAR(255)

M_CHANNEL

  • CHANNEL_ID — NUMBER — 기본 키 — NOT NULL
  • CHANNEL_NAME — VARCHAR(255)
  • CHANNEL_TYPE — VARCHAR(50)

M_CHURN_RULE

  • RULE_ID — NUMBER — 기본 키 — NOT NULL
  • FACTOR_CODE — VARCHAR(50)
  • FACTOR_NAME — VARCHAR(255)
  • FACTOR_GROUP — VARCHAR(50)
  • FACTOR_TYPE — VARCHAR(50)
  • CONDITION_EXPR — VARCHAR(1000)
  • ODDS_RATIO — NUMBER
  • BETA — NUMBER
  • P_VALUE — NUMBER
  • IS_SIGNIFICANT — CHAR(1)
  • IS_ACTIVE — CHAR(1)
  • RULE_VERSION — NUMBER

M_CONTRACT

  • CONTRACT_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • PRODUCT_ID — NUMBER — 외래 키 → M_PRODUCT.PRODUCT_ID
  • START_DATE — DATE
  • MATURITY_DATE — DATE
  • MONTHLY_PREMIUM — NUMBER
  • PAY_METHOD — VARCHAR(50)
  • IS_AUTO_PAY — CHAR(1)
  • CONTRACT_STATUS — VARCHAR(50)

M_CUSTOMER

  • CUST_ID — VARCHAR(50) — 기본 키 — NOT NULL
  • CUST_TYPE — VARCHAR(50)
  • GENDER — VARCHAR(10)
  • BIRTH_DATE — DATE
  • JOB_GROUP — VARCHAR(50)
  • INCOME_LEVEL — VARCHAR(50)
  • REGION — VARCHAR(50)
  • PHONE — VARCHAR(50)
  • CHANNEL_ID — NUMBER — 외래 키 → M_CHANNEL.CHANNEL_ID
  • BRANCH_ID — NUMBER — 외래 키 → M_BRANCH.BRANCH_ID
  • JOINED_AT — DATE
  • FUNNEL_STAGE — VARCHAR(50)
  • IS_CHURNED — CHAR(1)
  • CHURN_REASON — VARCHAR(255)
  • UPDATED_AT — DATE

M_EMPLOYEE

  • EMP_ID — NUMBER — 기본 키 — NOT NULL
  • EMP_NO — VARCHAR(50)
  • ROLE — VARCHAR(50)
  • BRANCH_ID — NUMBER — 외래 키 → M_BRANCH.BRANCH_ID
  • PASSWORD_HASH — VARCHAR(255)
  • DAILY_AVG_CONSULT — NUMBER

M_PRODUCT

  • PRODUCT_ID — NUMBER — 기본 키 — NOT NULL
  • PRODUCT_NAME — VARCHAR(255)
  • PRODUCT_TYPE — VARCHAR(50)
  • BASE_PREMIUM — NUMBER
  • COVERAGE_DESC — VARCHAR(1000)
  • PAY_TERM — VARCHAR(50)

T_ASSIGNMENT

  • ASSIGN_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • EMP_ID — NUMBER — 외래 키 → M_EMPLOYEE.EMP_ID
  • ASSIGN_RULE — VARCHAR(50)
  • ASSIGNED_AT — DATE
  • IS_ACTIVE — CHAR(1)

T_BEHAVIOR_LOG

  • BEHAV_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • BEHAV_TYPE — VARCHAR(50)
  • BEHAV_DETAIL — VARCHAR(255)
  • PAGE_URL — VARCHAR(500)
  • STAY_SECONDS — NUMBER
  • DEVICE_TYPE — VARCHAR(50)
  • OCCURRED_AT — DATE

T_CHURN_PREDICTION

  • PRED_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • CHURN_PROB — NUMBER
  • CHURN_SCORE — NUMBER
  • MACRO_FACTOR — NUMBER
  • FINAL_RISK — NUMBER
  • RISK_GRADE — VARCHAR(50)
  • RULE_VERSION — NUMBER
  • CALCULATED_AT — DATE

T_CONTACT_LOG

  • CONTACT_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • EMP_ID — NUMBER — 외래 키 → M_EMPLOYEE.EMP_ID
  • CONTACT_TYPE — VARCHAR(50)
  • CONTACT_RESULT — VARCHAR(50)
  • MEMO — VARCHAR(1000)
  • CONTACTED_AT — DATE

T_DEFENSE_ACTION

  • ACTION_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • EMP_ID — NUMBER — 외래 키 → M_EMPLOYEE.EMP_ID
  • ACTION_TYPE — VARCHAR(50)
  • PROPOSED_PRODUCT_ID — NUMBER — 외래 키 → M_PRODUCT.PRODUCT_ID
  • ACTION_RESULT — VARCHAR(50)
  • ACTED_AT — DATE

T_FUNNEL_HISTORY

  • HIST_ID — NUMBER — 기본 키 — NOT NULL
  • CUST_ID — VARCHAR(50) — 외래 키 → M_CUSTOMER.CUST_ID
  • STAGE — VARCHAR(50)
  • ENTERED_AT — DATE
  • IS_DROPPED — CHAR(1)
  • DROP_REASON — VARCHAR(255)

T_PAYMENT_LOG

  • PAY_ID — NUMBER — 기본 키 — NOT NULL
  • CONTRACT_ID — NUMBER — 외래 키 → M_CONTRACT.CONTRACT_ID
  • DUE_DATE — DATE
  • PAID_DATE — DATE
  • AMOUNT — NUMBER
  • PAY_STATUS — VARCHAR(50)
  • OVERDUE_DAYS — NUMBER

T_PREDICTION_FACTOR

  • FACTOR_ID — NUMBER — 기본 키 — NOT NULL
  • PRED_ID — NUMBER — 외래 키 → T_CHURN_PREDICTION.PRED_ID
  • RULE_ID — NUMBER — 외래 키 → M_CHURN_RULE.RULE_ID
  • CONTRIBUTION — NUMBER
  • RANK_NO — NUMBER