금융 서비스 이탈 가능 고객 예측 현황 시스템
테이블 (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