   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，必输';