321 lines
18 KiB
SQL
321 lines
18 KiB
SQL
alter table rec_xwbank_cus_info_tmp
|
||
add column "cust_ctry" VARCHAR(24);
|
||
alter table rec_xwbank_cus_info_his
|
||
add column "cust_ctry" VARCHAR(24);
|
||
|
||
alter table rec_xwbank_cus_info_tmp add column "ready_data" text;
|
||
alter table rec_xwbank_cus_info_tmp add column "living_status" varchar(12);
|
||
alter table rec_xwbank_cus_info_tmp add column "cert_area" varchar(12);
|
||
alter table rec_xwbank_cus_info_tmp add column "cert_city" varchar(12);
|
||
alter table rec_xwbank_cus_info_tmp add column "cert_province" varchar(12);
|
||
alter table rec_xwbank_cus_info_tmp add column "spouse_name" varchar(64);
|
||
alter table rec_xwbank_cus_info_tmp add column "spouse_cert_type" varchar(12);
|
||
alter table rec_xwbank_cus_info_tmp add column "spouse_cert_no" varchar(64);
|
||
alter table rec_xwbank_cus_info_tmp add column "spouse_work_comp_name" varchar(128);
|
||
alter table rec_xwbank_cus_info_tmp add column "spouse_work_comp_phone" varchar(32);
|
||
alter table rec_xwbank_cus_info_tmp add column "credit_home_address" varchar(255);
|
||
alter table rec_xwbank_cus_info_tmp add column "credit_comp_address" varchar(255);
|
||
alter table rec_xwbank_cus_info_tmp add column "credit_home_phone" varchar(24);
|
||
alter table rec_xwbank_cus_info_tmp add column "credit_comp_phone" varchar(24);
|
||
|
||
alter table rec_xwbank_cus_info_tmp add column "degree" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "degree" varchar(12);
|
||
|
||
|
||
alter table rec_xwbank_cus_info_his add column "ready_data" text;
|
||
alter table rec_xwbank_cus_info_his add column "living_status" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "cert_area" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "cert_city" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "cert_province" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "spouse_name" varchar(64);
|
||
alter table rec_xwbank_cus_info_his add column "spouse_cert_type" varchar(12);
|
||
alter table rec_xwbank_cus_info_his add column "spouse_cert_no" varchar(64);
|
||
alter table rec_xwbank_cus_info_his add column "spouse_work_comp_name" varchar(128);
|
||
alter table rec_xwbank_cus_info_his add column "spouse_work_comp_phone" varchar(32);
|
||
alter table rec_xwbank_cus_info_his add column "credit_home_address" varchar(255);
|
||
alter table rec_xwbank_cus_info_his add column "credit_comp_address" varchar(255);
|
||
alter table rec_xwbank_cus_info_his add column "credit_home_phone" varchar(24);
|
||
alter table rec_xwbank_cus_info_his add column "credit_comp_phone" varchar(24);
|
||
|
||
comment on column rec_xwbank_cus_info_tmp.cust_ctry is '国籍';
|
||
comment on column rec_xwbank_cus_info_tmp.ready_data is '预留字段';
|
||
comment on column rec_xwbank_cus_info_tmp.living_status is '居住状态';
|
||
comment on column rec_xwbank_cus_info_tmp.degree is '学位';
|
||
comment on column rec_xwbank_cus_info_tmp.cert_area is '身份证区';
|
||
comment on column rec_xwbank_cus_info_tmp.cert_city is '身份证市';
|
||
comment on column rec_xwbank_cus_info_tmp.cert_province is '身份证省';
|
||
comment on column rec_xwbank_cus_info_tmp.spouse_name is '配偶姓名';
|
||
comment on column rec_xwbank_cus_info_tmp.spouse_cert_type is '配偶证件类型';
|
||
comment on column rec_xwbank_cus_info_tmp.spouse_cert_no is '配偶证件号';
|
||
comment on column rec_xwbank_cus_info_tmp.spouse_work_comp_name is '配偶工作单位';
|
||
comment on column rec_xwbank_cus_info_tmp.spouse_work_comp_phone is '配偶工作电话';
|
||
comment on column rec_xwbank_cus_info_tmp.credit_home_address is '征信居住地址';
|
||
comment on column rec_xwbank_cus_info_tmp.credit_comp_address is '征信单位地址';
|
||
comment on column rec_xwbank_cus_info_tmp.credit_home_phone is '征信住宅电话';
|
||
comment on column rec_xwbank_cus_info_tmp.credit_comp_phone is '征信单位电话';
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
|
||
comment on column rec_xwbank_cus_info_his.cust_ctry is '国籍';
|
||
comment on column rec_xwbank_cus_info_his.ready_data is '预留字段';
|
||
|
||
comment on column rec_xwbank_cus_info_his.living_status is '居住状况';
|
||
comment on column rec_xwbank_cus_info_his.degree is '学位';
|
||
comment on column rec_xwbank_cus_info_his.cert_area is '身份证区';
|
||
comment on column rec_xwbank_cus_info_his.cert_city is '身份证市';
|
||
comment on column rec_xwbank_cus_info_his.cert_province is '身份证省';
|
||
comment on column rec_xwbank_cus_info_his.spouse_name is '配偶姓名';
|
||
comment on column rec_xwbank_cus_info_his.spouse_cert_type is '配偶证件类型';
|
||
comment on column rec_xwbank_cus_info_his.spouse_cert_no is '配偶证件号';
|
||
comment on column rec_xwbank_cus_info_his.spouse_work_comp_name is '配偶工作单位';
|
||
comment on column rec_xwbank_cus_info_his.spouse_work_comp_phone is '配偶工作电话';
|
||
comment on column rec_xwbank_cus_info_his.credit_home_address is '征信居住地址';
|
||
comment on column rec_xwbank_cus_info_his.credit_comp_address is '征信单位地址';
|
||
comment on column rec_xwbank_cus_info_his.credit_home_phone is '征信住宅电话';
|
||
comment on column rec_xwbank_cus_info_his.credit_comp_phone is '征信单位电话';
|
||
|
||
|
||
|
||
|
||
alter table rec_xwbank_loandetail_tmp
|
||
add column "loan_order_no" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_tmp
|
||
add column "cust_rate" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_tmp
|
||
add column "loan_ratio" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_tmp
|
||
add column "loan_arrival_time" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_tmp
|
||
add column "clearing_transaction_no" VARCHAR(64);
|
||
|
||
|
||
comment on column rec_xwbank_loandetail_tmp.loan_order_no is '放款订单号';
|
||
comment on column rec_xwbank_loandetail_tmp.cust_rate is '对客利率';
|
||
comment on column rec_xwbank_loandetail_tmp.loan_ratio is '出资比例';
|
||
comment on column rec_xwbank_loandetail_tmp.loan_arrival_time is '贷款到账时间';
|
||
comment on column rec_xwbank_loandetail_tmp.clearing_transaction_no is '清算交易编号';
|
||
|
||
|
||
|
||
alter table rec_xwbank_loandetail_his
|
||
add column "loan_order_no" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_his
|
||
add column "cust_rate" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_his
|
||
add column "loan_ratio" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_his
|
||
add column "loan_arrival_time" VARCHAR(64);
|
||
alter table rec_xwbank_loandetail_his
|
||
add column "clearing_transaction_no" VARCHAR(64);
|
||
|
||
|
||
|
||
comment on column rec_xwbank_loandetail_his.loan_order_no is '放款订单号';
|
||
comment on column rec_xwbank_loandetail_his.cust_rate is '对客利率';
|
||
comment on column rec_xwbank_loandetail_his.loan_ratio is '出资比例';
|
||
comment on column rec_xwbank_loandetail_his.loan_arrival_time is '贷款到账时间';
|
||
comment on column rec_xwbank_loandetail_his.clearing_transaction_no is '清算交易编号';
|
||
|
||
|
||
|
||
alter table rec_xwbank_credit_his
|
||
add column "credit_order_no" VARCHAR(64);
|
||
|
||
alter table rec_xwbank_credit_tmp
|
||
add column "credit_order_no" VARCHAR(64);
|
||
|
||
|
||
comment on column rec_xwbank_credit_his.credit_order_no is '授信订单编号';
|
||
|
||
|
||
comment on column rec_xwbank_credit_tmp.credit_order_no is '授信订单编号';
|
||
|
||
|
||
|
||
alter table rec_xwbank_repay_tmp
|
||
add column "prin_int_charging_date" varchar(24);
|
||
alter table rec_xwbank_repay_tmp
|
||
add column "liquidation_no" varchar(64);
|
||
alter table rec_xwbank_repay_tmp
|
||
add column "repay_account_type" varchar(12);
|
||
|
||
comment on column rec_xwbank_repay_tmp.prin_int_charging_date is '本息回收时间-本息从借款人账户划出时间';
|
||
comment on column rec_xwbank_repay_tmp.liquidation_no is '清算交易编号-按照清算机构统一规则形成的每笔交易编号(付款机构、清算机构、收款机构可核对交易明细）';
|
||
comment on column rec_xwbank_repay_tmp.repay_account_type is '还款账户类型-支付账户(含支付机构名称)或银行卡 ( 含 开 户 行 名称)';
|
||
|
||
|
||
|
||
alter table rec_xwbank_repay_his
|
||
add column "prin_int_charging_date" varchar(24);
|
||
alter table rec_xwbank_repay_his
|
||
add column "liquidation_no" varchar(64);
|
||
alter table rec_xwbank_repay_his
|
||
add column "repay_account_type" varchar(12);
|
||
|
||
|
||
|
||
comment on column rec_xwbank_repay_his.prin_int_charging_date is '本息回收时间-本息从借款人账户划出时间';
|
||
comment on column rec_xwbank_repay_his.liquidation_no is '清算交易编号-按照清算机构统一规则形成的每笔交易编号(付款机构、清算机构、收款机构可核对交易明细）';
|
||
comment on column rec_xwbank_repay_his.repay_account_type is '还款账户类型-支付账户(含支付机构名称)或银行卡 ( 含 开 户 行 名称)';
|
||
|
||
|
||
|
||
|
||
|
||
alter table rec_xwbank_acct_his
|
||
add column "pre_day_short_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "pre_day_midlong_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_retrieve_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_retrieve_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_short_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_midlong_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_write_off_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_write_off_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_bw_write_off_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_his
|
||
add column "same_day_bw_write_off_midlong_term_loan_prin_amt" dec(20,4);
|
||
|
||
|
||
|
||
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "pre_day_short_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "pre_day_midlong_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_retrieve_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_retrieve_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_short_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_midlong_term_loan_prin_bln" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_write_off_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_write_off_midlong_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_bw_write_off_short_term_loan_prin_amt" dec(20,4);
|
||
alter table rec_xwbank_acct_tmp
|
||
add column "same_day_bw_write_off_midlong_term_loan_prin_amt" dec(20,4);
|
||
|
||
|
||
comment on column rec_xwbank_acct_tmp.pre_day_short_term_loan_prin_bln is '上日短期贷款本金余额 ';
|
||
comment on column rec_xwbank_acct_tmp.pre_day_midlong_term_loan_prin_bln is '上日中长贷款本金余额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_short_term_loan_prin_amt is '当日发放短期贷款本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_midlong_term_loan_prin_amt is '当日发放中长期贷款本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_retrieve_short_term_loan_prin_amt is '当日回收短期贷款本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_retrieve_midlong_term_loan_prin_amt is '当日回收中长期贷款本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_short_term_loan_prin_bln is '当日短期贷款本金余额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_midlong_term_loan_prin_bln is '当日中长期贷款本金余额 ';
|
||
comment on column rec_xwbank_acct_tmp.same_day_write_off_short_term_loan_prin_amt is '当日冲销短期本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_write_off_midlong_term_loan_prin_amt is '当日冲销中长期本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_bw_write_off_short_term_loan_prin_amt is '当日表外核销短期本金总额';
|
||
comment on column rec_xwbank_acct_tmp.same_day_bw_write_off_midlong_term_loan_prin_amt is '当日表外核销中长期本金总额';
|
||
|
||
|
||
|
||
comment on column rec_xwbank_acct_his.pre_day_short_term_loan_prin_bln is '上日短期贷款本金余额 ';
|
||
comment on column rec_xwbank_acct_his.pre_day_midlong_term_loan_prin_bln is '上日中长贷款本金余额';
|
||
comment on column rec_xwbank_acct_his.same_day_short_term_loan_prin_amt is '当日发放短期贷款本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_midlong_term_loan_prin_amt is '当日发放中长期贷款本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_retrieve_short_term_loan_prin_amt is '当日回收短期贷款本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_retrieve_midlong_term_loan_prin_amt is '当日回收中长期贷款本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_short_term_loan_prin_bln is '当日短期贷款本金余额';
|
||
comment on column rec_xwbank_acct_his.same_day_midlong_term_loan_prin_bln is '当日中长期贷款本金余额 ';
|
||
comment on column rec_xwbank_acct_his.same_day_write_off_short_term_loan_prin_amt is '当日冲销短期本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_write_off_midlong_term_loan_prin_amt is '当日冲销中长期本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_bw_write_off_short_term_loan_prin_amt is '当日表外核销短期本金总额';
|
||
comment on column rec_xwbank_acct_his.same_day_bw_write_off_midlong_term_loan_prin_amt is '当日表外核销中长期本金总额';
|
||
|
||
|
||
|
||
|
||
alter table rec_xwbank_file_num_tmp add column "enterpriseinfo_total" int;
|
||
alter table rec_xwbank_file_num_tmp add column "billinfo_total" int;
|
||
alter table rec_xwbank_file_num_tmp add column "coborrower_total" int;
|
||
alter table rec_xwbank_file_num_tmp add column "houseinfo_total" int;
|
||
|
||
|
||
alter table rec_xwbank_file_num_his add column "enterpriseinfo_total" int;
|
||
alter table rec_xwbank_file_num_his add column "billinfo_total" int;
|
||
alter table rec_xwbank_file_num_his add column "coborrower_total" int;
|
||
alter table rec_xwbank_file_num_his add column "houseinfo_total" int;
|
||
|
||
|
||
|
||
comment on column rec_xwbank_file_num_tmp.enterpriseinfo_total is '企业客户信息数据总数';
|
||
comment on column rec_xwbank_file_num_tmp.billinfo_total is '票据信息数据总数';
|
||
comment on column rec_xwbank_file_num_tmp.coborrower_total is '共借人信息数据总数';
|
||
comment on column rec_xwbank_file_num_tmp.houseinfo_total is '房产信息数总数';
|
||
|
||
comment on column rec_xwbank_file_num_his.enterpriseinfo_total is '企业客户信息数据总数';
|
||
comment on column rec_xwbank_file_num_his.billinfo_total is '票据信息数据总数';
|
||
comment on column rec_xwbank_file_num_his.coborrower_total is '共借人信息数据总数';
|
||
comment on column rec_xwbank_file_num_his.houseinfo_total is '房产信息数总数';
|
||
|
||
alter table rec_xwbank_buis_info_tmp add column "busi_province" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_tmp add column "busi_city" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_tmp add column "busi_area" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_tmp add column "busi_address" VARCHAR(256);
|
||
alter table rec_xwbank_buis_info_tmp add column "paicl_up_capital" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_tmp add column "tax_credit_level" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_tmp add column "taxable_sales_revenue" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_tmp add column "value_added_tax_paid" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_tmp add column "corporate_income_tax_paid" VARCHAR(32);
|
||
|
||
|
||
alter table rec_xwbank_buis_info_his add column "busi_province" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_his add column "busi_city" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_his add column "busi_area" VARCHAR(12);
|
||
alter table rec_xwbank_buis_info_his add column "busi_address" VARCHAR(256);
|
||
alter table rec_xwbank_buis_info_his add column "paicl_up_capital" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_his add column "tax_credit_level" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_his add column "taxable_sales_revenue" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_his add column "value_added_tax_paid" VARCHAR(32);
|
||
alter table rec_xwbank_buis_info_his add column "corporate_income_tax_paid" VARCHAR(32);
|
||
|
||
|
||
comment on column rec_xwbank_buis_info_his.busi_province is '省-经营单位';
|
||
comment on column rec_xwbank_buis_info_his.busi_city is '市-经营单位';
|
||
comment on column rec_xwbank_buis_info_his.busi_area is '区-经营单位';
|
||
comment on column rec_xwbank_buis_info_his.busi_address is '地址-经营单位';
|
||
comment on column rec_xwbank_buis_info_his.paicl_up_capital is '实收资本 A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_his.tax_credit_level is '纳税征信等级';
|
||
comment on column rec_xwbank_buis_info_his.taxable_sales_revenue is '应税销售收入(年汇总) A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_his.value_added_tax_paid is '增值税已缴税款(年汇总) A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_his.corporate_income_tax_paid is '企业所得税已缴税款(年汇总) A32 单位:万元，无数据来源时为 0，必输';
|
||
|
||
|
||
comment on column rec_xwbank_buis_info_tmp.busi_province is '省-经营单位';
|
||
comment on column rec_xwbank_buis_info_tmp.busi_city is '市-经营单位';
|
||
comment on column rec_xwbank_buis_info_tmp.busi_area is '区-经营单位';
|
||
comment on column rec_xwbank_buis_info_tmp.busi_address is '地址-经营单位';
|
||
comment on column rec_xwbank_buis_info_tmp.paicl_up_capital is '实收资本 A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_tmp.tax_credit_level is '纳税征信等级';
|
||
comment on column rec_xwbank_buis_info_tmp.taxable_sales_revenue is '应税销售收入(年汇总) A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_tmp.value_added_tax_paid is '增值税已缴税款(年汇总) A32 单位:万元，无数据来源时为 0，必输';
|
||
comment on column rec_xwbank_buis_info_tmp.corporate_income_tax_paid is '企业所得税已缴税款(年汇总) A32 单位:万元，无数据来源时为 0，必输'; |