Credit
Tables (7)
APP_INFO
- APP_ID — VARCHAR(50) — Primary key — NOT NULL
- CUST_ID — VARCHAR(50) — NOT NULL
- GOODS_CD — VARCHAR(10)
- INA_CD — VARCHAR(2)
- AD_NO — VARCHAR(10)
- PRE_LMT — DECIMAL(15,0)
- PRE_RT — DECIMAL(5,2)
- SALE_TRM — INT
- HAC_CD — VARCHAR(3)
- RRC_CD — VARCHAR(2)
- ADD_YN — CHAR(1)
- APP_DT — DATE
CB_VARS_HIST
- CB_HIST_ID — BIGINT — Primary key — NOT NULL
- APP_ID — VARCHAR(50) — NOT NULL
- SCORING_DT — DATE
- SCORE_CB — INT
- GRD_CB — INT
- SCORE_SP — INT
- B22000200 — INT
- B12000100 — INT
- BS0000164 — VARCHAR(20)
- CB_VARS_JSON — TEXT
CUST_MASTER
- CUST_ID — VARCHAR(50) — Primary key — NOT NULL
- RES_ADD — VARCHAR(20)
- LIV_ADD — VARCHAR(20)
- BIRTH_DT — VARCHAR(8)
- GENDER — CHAR(1)
- JOIN_DT — DATE
MODEL_META
- MODEL_VER — VARCHAR(20) — Primary key — NOT NULL
- MODEL_TYPE — VARCHAR(20)
- FILE_PATH — VARCHAR(255)
- IS_ACTIVE — CHAR(1)
- F1_SCORE — DECIMAL(5,4)
- AUC_SCORE — DECIMAL(5,4)
- REG_DT — DATE
MODEL_RES_HIST
- RES_ID — BIGINT — Primary key — NOT NULL
- APP_ID — VARCHAR(50) — NOT NULL
- RESULT_DELAY_CNT — INT
- TOT_SCORE — INT
- PROB_BAD — DECIMAL(6,5)
- BAD_YN — CHAR(1)
- CREDIT_GRADE — INT
- MODEL_VER — VARCHAR(20)
- EXEC_DT — DATE
SYS_ADMIN
- ADMIN_ID — VARCHAR(50) — Primary key — NOT NULL
- PWD_HASH — VARCHAR(256) — NOT NULL
- ADMIN_NM — VARCHAR(50)
- ROLE_CD — VARCHAR(10)
- FAIL_CNT — INT
- IS_LOCKED — CHAR(1)
- LAST_LOGIN — DATE
- REG_DT — DATE
SYS_CONFIG
- CONF_CD — VARCHAR(50) — Primary key — NOT NULL
- CONF_VAL — VARCHAR(100) — NOT NULL
- CONF_DESC — VARCHAR(200)
- MOD_DT — DATE