32 lines
2.6 KiB
MySQL
32 lines
2.6 KiB
MySQL
|
|
|||
|
|
CREATE TABLE REC_LOAN_LAST."rec_msxf_after_loan_zxbl" (
|
|||
|
|
"id" VARCHAR(64) NOT NULL,
|
|||
|
|
"biz_date" VARCHAR(12),
|
|||
|
|
"duebill_no" VARCHAR(64),
|
|||
|
|
"five_level" VARCHAR(32),
|
|||
|
|
"max_long_overdue_month" VARCHAR(72),
|
|||
|
|
"max_overdue_times" VARCHAR(72),
|
|||
|
|
"total_overdue" VARCHAR(72),
|
|||
|
|
"exits_overdue_sts" VARCHAR(72),
|
|||
|
|
"exist_crdt_bad_sts" VARCHAR(72),
|
|||
|
|
"exists_loan_bad_debt" VARCHAR(72),
|
|||
|
|
"exists_zccz_bbrdc_in_loan_records" VARCHAR(72),
|
|||
|
|
|
|||
|
|
"create_date" DATE,
|
|||
|
|
"create_time" TIMESTAMP,
|
|||
|
|
CONSTRAINT rec_msxf_after_loan_zxbl_id PRIMARY KEY ("id")
|
|||
|
|
);
|
|||
|
|
CREATE INDEX index_rec_msxf_after_loan_zxbl_bizdate ON REC_LOAN_LAST."rec_msxf_after_loan_zxbl" ("biz_date");
|
|||
|
|
CREATE INDEX index_rec_msxf_after_loan_zxbl_duebill_no ON REC_LOAN_LAST."rec_msxf_after_loan_zxbl" ("duebill_no");
|
|||
|
|
|
|||
|
|
COMMENT ON TABLE REC_LOAN_LAST.rec_msxf_after_loan_zxbl IS '马上消费贷后征信变量文件';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.duebill_no IS '借款编号';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.five_level IS '贷款五级分类---A:否;B:是';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.max_long_overdue_month IS '贷款最长逾期月数---[0-1)-0; [1-2)-1; [2-3)-2; [3-4)-3; [4-5)-4; [5-6)-5; [6-7)-6; [7-8)-7; [8-9)-8; [9-10)-9; [10-11)-10; [11-12)-11; [12-13)-12; [13,∞)-13';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.max_overdue_times IS '所有贷款最近24个月连续逾期次数最大值（单笔贷款）---[0, 1)-A；[1, 3)-B；[3, 5)-C；[5, 7)-D；[7, 9)-E；[9, 11)-F；[11, 13)-G；[13, 15)-H；[15, 17)-I；[17, 19)-J；[19, 21)-K；[21, 23)-L；[23, 25)-M；[25, ∞)-N';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.total_overdue IS '所有贷款最近24个月内累计逾期次数---[0, 1)-A；[1, 3)-B；[3, 5)-C；[5, 7)-D；[7, 9)-E；[9, 11)-F；[11, 13)-G；[13, 15)-H；[15, 17)-I；[17, 19)-J；[19, 21)-K；[21, 23)-L；[23, 25)-M；[25, ∞)-N';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.exits_overdue_sts IS '是否存在贷款当前状态为“逾期”（所有贷款+信用卡）---A:否;B:是';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.exist_crdt_bad_sts IS '是否存在贷记卡当前状态为“逾期”、“呆账”、“冻结”、“止付”等特殊情况（所有贷记卡）---A:否;B:是';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.exists_loan_bad_debt IS '是否存在贷款当前状态为“呆账”（所有贷款）---A:否;B:是';
|
|||
|
|
COMMENT ON COLUMN REC_LOAN_LAST.rec_msxf_after_loan_zxbl.exists_zccz_bbrdc_in_loan_records IS '贷款还款记录中是否存在“资产处置”、“保证人代偿”等特殊情况---A:否;B:是';
|