上传的图像用于项目: 'CST技术支持'
  1. CST技术支持
  2. SLAL2-552

耀华申请正式环境(需要删除相关数据)

XMLWord打印

    • Icon: 任务 任务
    • 解决结果: 完成
    • Icon: Medium Medium
    • 202006
    • Y-易路产品-
    • YCYWTest
    • 基础通用功能
    • 隐藏

      DELETE from hr_recruitment_enroll;
      DELETE from hr_applicant;
      DELETE from hr_contract;
      DELETE from employee_certification;
      DELETE from employee_probation;
      DELETE from job_transfer;
      DELETE from employee_dimission;
      DELETE from hr_termination;
      DELETE from dimission_summary;
      DELETE from termination_process;
      DELETE from hr_attendance;
      DELETE from hr_attendance_health;
      DELETE from hr_attendance_appeal;
      DELETE from hr_attendance_adjustment;
      DELETE from hr_attendance_feedback;
      DELETE from hr_leave_recall;
      DELETE from hr_holiday_leave;
      DELETE from hr_holiday_inquiry;
      DELETE from hr_holiday_adjustment;
      DELETE from hr_holiday_conversion;
      DELETE from hr_overtime;
      DELETE from batch_overtime;
      DELETE from day_calendar;
      DELETE from schedule_application;
      DELETE from payroll_archive;
      DELETE from single_salary_adjustment;
      DELETE from coefficient_adjust_watch;
      DELETE from hr_payslip_run;
      DELETE from hr_travel;
      DELETE from hr_expense_expense;
      DELETE from hr_reimburse_budget;
      DELETE from hr_reimburse_budget_overview;
      DELETE from company_record;
      DELETE from hr_employee_payroll_group_relation;
      DELETE from hr_payslip_info;
      DELETE from hr_payslip_period_result;
      DELETE from x_data_travel_admin;
      DELETE from hr_attendance_import_wizard;
      DELETE from hr_holiday_allot_detail;
      DELETE from hr_holiday_move;
      DELETE from employee_rank_adjust;
      DELETE from automatic_schedule_info;
      DELETE from hr_worked_experience;
      DELETE from hr_employee;

      显示
      DELETE from hr_recruitment_enroll; DELETE from hr_applicant; DELETE from hr_contract; DELETE from employee_certification; DELETE from employee_probation; DELETE from job_transfer; DELETE from employee_dimission; DELETE from hr_termination; DELETE from dimission_summary; DELETE from termination_process; DELETE from hr_attendance; DELETE from hr_attendance_health; DELETE from hr_attendance_appeal; DELETE from hr_attendance_adjustment; DELETE from hr_attendance_feedback; DELETE from hr_leave_recall; DELETE from hr_holiday_leave; DELETE from hr_holiday_inquiry; DELETE from hr_holiday_adjustment; DELETE from hr_holiday_conversion; DELETE from hr_overtime; DELETE from batch_overtime; DELETE from day_calendar; DELETE from schedule_application; DELETE from payroll_archive; DELETE from single_salary_adjustment; DELETE from coefficient_adjust_watch; DELETE from hr_payslip_run; DELETE from hr_travel; DELETE from hr_expense_expense; DELETE from hr_reimburse_budget; DELETE from hr_reimburse_budget_overview; DELETE from company_record; DELETE from hr_employee_payroll_group_relation; DELETE from hr_payslip_info; DELETE from hr_payslip_period_result; DELETE from x_data_travel_admin; DELETE from hr_attendance_import_wizard; DELETE from hr_holiday_allot_detail; DELETE from hr_holiday_move; DELETE from employee_rank_adjust; DELETE from automatic_schedule_info; DELETE from hr_worked_experience; DELETE from hr_employee;

      Dear,

      耀华上线单已签,申请正式环境,需要删除相关数据,请帮忙写下相关SQL,非常感谢。

      具体需要删除内容请见附件邮件正文。

            wenqiang.liu 刘文强
            allen.liu 刘伊伦
            表决:
            0 为这个问题表决

              创建日期:
              已更新:
              已解决: