-- 检查整改表
delete from t_inspection;
-- 检查整改明细表
delete from t_inspection_line;
-- 应急演练、教育培训
delete from t_task_handin;
-- 任务下发
delete from t_task;
-- 案件材料报送
delete from t_prevent_material;
-- 风险提示
delete from t_prevent_risk;
-- 考核评价表
delete from t_assessment;
-- 考核评价明细表
delete from t_assessment_detail;
-- 值班备勤
delete from t_duty_records;
-- 值班备勤明细
delete from t_duty_records_lines;
-- 工作报备表
delete from t_work_filing;
-- 工作提醒表
delete from t_note_remind;
-- 非现场检查表
delete from t_scc_check;
--  非现场检查明细表
delete from t_scc_check_lines;
--  整改通知书表
delete from t_scc_unlocale_check;
--  整改通知书明细表
delete from t_scc_unlocale_check_line;
-- 联系接警记录表
delete from t_scc_answer_alarm;
-- 警情处理表
delete from t_scc_alarm_push;
-- 模板管理表
-- delete from t_file_template;
-- 法律法规表
delete from t_law;
-- 设备检查表
delete from t_device_inspection;
-- 设备检查明细表
delete from t_device_inspection_line;
-- 项目管理-预算
delete from t_budget_item;
-- 项目管理-项目信息
delete from t_project;
delete from t_project_check;
delete from t_project_contract;
delete from t_project_establishment;
delete from t_project_implementation;
delete from t_project_over_history;
delete from t_project_pay_plan;
delete from t_project_purchase;
delete from t_publicity;
-- 工作交接记录表
delete from t_handover_history;
-- 交接人员组
delete from t_work_handover_users;
-- 设备信息
delete from t_device;
-- 宣传报道
delete from t_publicity;
-- 相关方公司
delete from t_out_company;
-- 相关方人员
delete from t_out_employee;
delete from t_out_family;
delete from t_out_job_record;
-- 附件表中删除 除模板管理 以外的数据
delete from t_file where link_id not in (select id from t_file_template);
