342 lines
9.6 KiB
SQL
342 lines
9.6 KiB
SQL
--应用清库即可
|
|
drop table act_business_info;
|
|
drop table act_evt_log;
|
|
drop table act_ge_bytearray;
|
|
drop table act_ge_property;
|
|
drop table act_hi_actinst;
|
|
drop table act_hi_attachment;
|
|
drop table act_hi_comment;
|
|
drop table act_hi_detail;
|
|
drop table act_hi_identitylink;
|
|
drop table act_hi_procinst;
|
|
drop table act_hi_taskinst;
|
|
drop table act_hi_varinst;
|
|
drop table act_id_group;
|
|
drop table act_id_info;
|
|
drop table act_id_membership;
|
|
drop table act_id_user;
|
|
drop table act_make_copy;
|
|
drop table act_procdef_info;
|
|
drop table act_re_deployment;
|
|
drop table act_re_model;
|
|
drop table act_re_procdef;
|
|
drop table act_ru_event_subscr;
|
|
drop table act_ru_execution;
|
|
drop table act_ru_identitylink;
|
|
drop table act_ru_job;
|
|
drop table act_ru_task;
|
|
drop table act_ru_variable;
|
|
drop table bam_file_group;
|
|
drop table bam_file_grp_detail;
|
|
drop table bam_file_store;
|
|
drop table bam_file_store_his;
|
|
drop table bam_file_type;
|
|
drop table bank_no_info;
|
|
drop table batch_job_execution;
|
|
drop table batch_job_execution_context;
|
|
drop table batch_job_execution_params;
|
|
drop table batch_job_execution_seq;
|
|
drop table batch_job_instance;
|
|
drop table batch_job_seq;
|
|
drop table batch_step_execution;
|
|
drop table batch_step_execution_context;
|
|
drop table batch_step_execution_seq;
|
|
drop table biz_adv_fee;
|
|
drop table biz_adv_fee_app;
|
|
drop table biz_agr_tmpl;
|
|
drop table biz_bm_rate;
|
|
drop table biz_bm_rate_chg;
|
|
drop table biz_cfg_audit;
|
|
drop table biz_channel;
|
|
drop table biz_channel_approve;
|
|
drop table biz_cont_signer_config;
|
|
drop table biz_cont_tmpl;
|
|
drop table biz_cont_tmpl_app;
|
|
drop table biz_coop_account;
|
|
drop table biz_coop_account_info;
|
|
drop table biz_coop_asset_config;
|
|
drop table biz_coop_check;
|
|
drop table biz_coop_config;
|
|
drop table biz_coop_config_ref;
|
|
drop table biz_coop_config_staging;
|
|
drop table biz_coop_credit_config;
|
|
drop table biz_coop_fee_adj;
|
|
drop table biz_coop_fee_clr;
|
|
drop table biz_coop_fee_file;
|
|
drop table biz_coop_fund_config;
|
|
drop table biz_coop_prd_config;
|
|
drop table biz_coop_tran_info;
|
|
drop table biz_cus_acct;
|
|
drop table biz_dvt_app;
|
|
drop table biz_dvt_detail;
|
|
drop table biz_dvt_err_chk;
|
|
drop table biz_ext_agr;
|
|
drop table biz_ext_app;
|
|
drop table biz_flow_audit;
|
|
drop table biz_grt_cont_rel;
|
|
drop table biz_info_backup;
|
|
drop table biz_loan_voucher;
|
|
drop table biz_open_tran_log;
|
|
drop table biz_prd_nplr;
|
|
drop table biz_record_result;
|
|
drop table biz_seq_no_tmpl;
|
|
drop table biz_sgl_sts_reg;
|
|
drop table biz_sub_tran_record;
|
|
drop table biz_tran_config;
|
|
drop table biz_tran_record;
|
|
drop table biz_warn_common;
|
|
drop table biz_warn_common_multil;
|
|
drop table biz_warn_coop_acct;
|
|
drop table biz_warn_coop_file;
|
|
drop table biz_warn_coop_file_dtl;
|
|
drop table biz_warn_coop_repay;
|
|
drop table biz_warn_coop_sign;
|
|
drop table biz_warn_duebill_check;
|
|
drop table biz_warn_hxfile_check;
|
|
drop table biz_warn_lmt;
|
|
drop table biz_warn_notice_config;
|
|
drop table biz_warn_payout_cancel;
|
|
drop table biz_warn_payout_check;
|
|
drop table biz_warn_prd_nplr;
|
|
drop table biz_warn_repay_check;
|
|
drop table biz_warn_repay_plan_dtl;
|
|
drop table bth_file_exception;
|
|
drop table bth_job_detail;
|
|
drop table bth_job_status;
|
|
drop table ctr_lmt_cont;
|
|
drop table ctr_loan_cont;
|
|
drop table ctr_loan_cont_exp;
|
|
drop table ctr_loan_cont_sign;
|
|
drop table ctr_loan_cont_sign_exp;
|
|
drop table cus_addr;
|
|
drop table cus_approve_list;
|
|
drop table cus_base_info;
|
|
drop table cus_business_entity;
|
|
drop table cus_ent;
|
|
drop table cus_ent_addr;
|
|
drop table cus_ent_benefit;
|
|
drop table cus_ent_fina_bond;
|
|
drop table cus_ent_fina_stock;
|
|
drop table cus_ent_house;
|
|
drop table cus_ent_mgr;
|
|
drop table cus_ent_relate;
|
|
drop table cus_ent_shr;
|
|
drop table cus_ent_staging;
|
|
drop table cus_ent_veh;
|
|
drop table cus_ext_info;
|
|
drop table cus_fam_liabilities;
|
|
drop table cus_house_info;
|
|
drop table cus_ind_social;
|
|
drop table cus_ind_work;
|
|
drop table cus_indiv;
|
|
drop table cus_info_staging;
|
|
drop table cus_list;
|
|
drop table cus_veh_info;
|
|
drop table efs_para_cfpar9;
|
|
drop table fac_accounting_duebill;
|
|
drop table fac_loan_duebill;
|
|
drop table grt_guar_cont;
|
|
drop table grt_guarantee;
|
|
drop table lmt_crdt_agr;
|
|
drop table lmt_crdt_app;
|
|
drop table lmt_crdt_apply_report;
|
|
drop table lmt_crdt_deel_app;
|
|
drop table lmt_crdt_deel_detail;
|
|
drop table lmt_crdt_lmt;
|
|
drop table lmt_crdt_lmt_his;
|
|
drop table lmt_crdt_risk;
|
|
drop table lmt_cus_addr;
|
|
drop table lmt_cus_business_entity;
|
|
drop table lmt_cus_crdt_deel_app;
|
|
drop table lmt_cus_crdt_deel_detail;
|
|
drop table lmt_cus_crdt_lmt;
|
|
drop table lmt_cus_crdt_lmt_his;
|
|
drop table lmt_cus_ent;
|
|
drop table lmt_cus_ent_mgr;
|
|
drop table lmt_cus_ent_shr;
|
|
drop table lmt_cus_house_info;
|
|
drop table lmt_cus_ind_common;
|
|
drop table lmt_cus_ind_ent;
|
|
drop table lmt_cus_ind_social;
|
|
drop table lmt_cus_ind_work;
|
|
drop table lmt_cus_indiv;
|
|
drop table lmt_cus_veh_info;
|
|
drop table lmt_stop_app;
|
|
drop table pay_credit_app;
|
|
drop table pay_payout_app;
|
|
drop table pay_payout_exp;
|
|
drop table pls_banlance_account;
|
|
drop table pls_coll_task;
|
|
drop table pls_coop_claim_repay;
|
|
drop table pls_cus_acct_chg;
|
|
drop table pls_cus_rpy_acct_chg;
|
|
drop table pls_cus_warn_app;
|
|
drop table pls_cus_warn_auto;
|
|
drop table pls_cus_warn_man;
|
|
drop table pls_due_date_chg;
|
|
drop table pls_dyn_cus_warn_bat;
|
|
drop table pls_dyn_cus_warn_bat_dtl;
|
|
drop table pls_ln_use_chk;
|
|
drop table pls_ln_use_risk_chk;
|
|
drop table pls_loan_canc_asset_mgr;
|
|
drop table pls_loan_canc_duebill;
|
|
drop table pls_loan_canc_plan;
|
|
drop table pls_loan_canc_recov;
|
|
drop table pls_loan_cancel;
|
|
drop table pls_loan_chk;
|
|
drop table pls_loan_grace_chg;
|
|
drop table pls_loan_int_adj;
|
|
drop table pls_loan_rate_chg;
|
|
drop table pls_loan_relief;
|
|
drop table pls_loan_repay_mode_chg;
|
|
drop table pls_loan_term_chg;
|
|
drop table pls_man_repay;
|
|
drop table pls_repay;
|
|
drop table pls_repay_app;
|
|
drop table pls_repay_approve;
|
|
drop table pls_repay_exp;
|
|
drop table pls_repay_result;
|
|
drop table pls_repayment_file;
|
|
drop table pls_risk_class_adjust;
|
|
drop table pls_risk_class_config;
|
|
drop table pls_risk_class_result;
|
|
drop table prd_acct_config;
|
|
drop table prd_agr_tmpl_ref;
|
|
drop table prd_bank_ref;
|
|
drop table prd_base_info;
|
|
drop table prd_chan_ref;
|
|
drop table prd_code_map;
|
|
drop table prd_com_param;
|
|
drop table prd_config_parameters;
|
|
drop table prd_core_prd_map;
|
|
drop table prd_crdt_ctrl;
|
|
drop table prd_crdt_intv;
|
|
drop table prd_crdt_lmt;
|
|
drop table prd_ctrl_grp;
|
|
drop table prd_ctrl_grp_ref;
|
|
drop table prd_declaration_parameters;
|
|
drop table prd_draw_intv;
|
|
drop table prd_draw_lmt;
|
|
drop table prd_draw_plan_day;
|
|
drop table prd_draw_term;
|
|
drop table prd_draw_term_cmm;
|
|
drop table prd_draw_term_rng;
|
|
drop table prd_file_grp_ref;
|
|
drop table prd_fixed_rate;
|
|
drop table prd_float_rate;
|
|
drop table prd_fund_plan_ref;
|
|
drop table prd_lmt_dist;
|
|
drop table prd_main_info;
|
|
drop table prd_org_ref;
|
|
drop table prd_over_ctrl;
|
|
drop table prd_repay;
|
|
drop table prd_repay_mode_map;
|
|
drop table prd_risk_class_model;
|
|
drop table prd_risk_config;
|
|
drop table prd_template;
|
|
drop table prd_tmpl_ref;
|
|
drop table prd_tran_config;
|
|
drop table prd_tree;
|
|
drop table prd_tree_param;
|
|
drop table rec_aml_info_add;
|
|
drop table rec_aml_info_all;
|
|
drop table rec_bas_rate;
|
|
drop table rec_cus_core_info;
|
|
drop table rec_fac_loan_duebill;
|
|
drop table rec_ivoc_crdt_info;
|
|
drop table rec_ln_acct_automatic_compensation;
|
|
drop table rec_ln_acct_bal_detail_eod;
|
|
drop table rec_ln_acct_detail;
|
|
drop table rec_ln_acct_mast;
|
|
drop table rec_ln_acct_repay_arrears;
|
|
drop table rec_ln_acct_repay_plan_add;
|
|
drop table rec_ln_acct_repay_plan_all;
|
|
drop table rec_ln_acct_repay_plan_crdt;
|
|
drop table rec_ln_acct_repay_plan_tmp;
|
|
drop table rec_ln_acct_repayment_mmdd_add;
|
|
drop table rec_ln_acct_repayment_mmdd_all;
|
|
drop table rec_ln_acct_repayment_mmdd_tmp;
|
|
drop table rec_ln_rec_reg_book;
|
|
drop table rec_ln_trace_log_mmdd;
|
|
drop table rec_pay_payout;
|
|
drop table repay_app_list;
|
|
drop table repay_approve_list;
|
|
drop table repay_list;
|
|
drop table rpt_migration_monthly;
|
|
drop table rpt_prd_annual;
|
|
drop table rpt_prd_chan_sum;
|
|
drop table rpt_prd_daily;
|
|
drop table rpt_prd_monthly;
|
|
drop table rpt_prd_org_over_sum;
|
|
drop table rpt_prd_org_sum;
|
|
drop table rpt_prd_quarterly;
|
|
drop table rpt_prd_sum;
|
|
drop table rule_champion_challenger;
|
|
drop table rule_champion_schedule_rel;
|
|
drop table rule_clazz;
|
|
drop table rule_decision_table;
|
|
drop table rule_execute_detail;
|
|
drop table rule_model_var_category;
|
|
drop table rule_pro_model_rel;
|
|
drop table rule_project;
|
|
drop table rule_project_record;
|
|
drop table rule_rule;
|
|
drop table rule_rule_set;
|
|
drop table rule_schedule;
|
|
drop table rule_scheduler_result;
|
|
drop table rule_score_card_new;
|
|
drop table rule_score_detail;
|
|
drop table rule_var_category;
|
|
drop table rule_variable;
|
|
drop table sccola;
|
|
drop table sch_group;
|
|
drop table sch_group_job_ref;
|
|
drop table sch_group_status;
|
|
drop table sch_job_contacts;
|
|
drop table sch_job_detail;
|
|
drop table sch_job_monitor;
|
|
drop table sch_job_status;
|
|
drop table sch_job_system;
|
|
drop table sch_lock;
|
|
drop table sch_task;
|
|
drop table sch_task_group_ref;
|
|
drop table sch_task_status;
|
|
drop table sculda;
|
|
drop table sms_send_person;
|
|
drop table sms_send_record;
|
|
drop table sms_tmpl_config;
|
|
drop table sys_acct_sysdate;
|
|
drop table sys_api_permission;
|
|
drop table sys_app;
|
|
drop table sys_app_api;
|
|
drop table sys_app_button;
|
|
drop table sys_app_cfg_adj_log;
|
|
drop table sys_bank;
|
|
drop table sys_config;
|
|
drop table sys_db_resource;
|
|
drop table sys_delete_log;
|
|
drop table sys_exception_log;
|
|
drop table sys_holiday;
|
|
drop table sys_home_config;
|
|
drop table sys_lock;
|
|
drop table sys_notice_public;
|
|
drop table sys_operation_log;
|
|
drop table sys_option;
|
|
drop table sys_org;
|
|
drop table sys_org_app;
|
|
drop table sys_org_map;
|
|
drop table sys_org_role;
|
|
drop table sys_role;
|
|
drop table sys_role_app;
|
|
drop table sys_role_app_api;
|
|
drop table sys_role_app_btn;
|
|
drop table sys_role_resource;
|
|
drop table sys_select;
|
|
drop table sys_sub_app;
|
|
drop table sys_tree;
|
|
drop table sys_user;
|
|
drop table sys_user_org;
|
|
drop table sys_user_role;
|
|
drop table unl_fund_plan;
|
|
drop table unl_plan_detail;
|
|
drop table unl_reg_detail; |