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