d_sms_service/SQL/删除/删除风险管理数据表.sql

88 lines
3.0 KiB
MySQL
Raw Permalink Normal View History

2024-10-28 13:45:58 +08:00
/*2风险评价计划发布*/
DELETE T_HM_NOTICE_RELEASE_DEPARTMENT
DELETE T_HM_NOTICE_RELEASE_FILE
DELETE T_HM_NOTICE_RELEASE
/*5危险源/风险辨识记录表*/
DELETE T_HM_RISK_RECORD_FILE
DELETE T_HM_RISK_RECORD_IDENTIFYING
DELETE T_HM_RISK_RECORD_USER
DELETE T_HM_RISK_RECORD_DETAIL_WORKDUTY
DELETE T_HM_RISK_RECORD_DETAIL_EQUIPMENT
DELETE T_HM_RISK_RECORD_DETAIL_FACILITIES
DELETE T_HM_RISK_RECORD_DETAIL
DELETE T_HM_RISK_RECORD
/*4危险源/风险辨识任务*/
DELETE T_HM_RISK_TASK_IDENTIFYING
DELETE T_HM_RISK_TASK_USER
DELETE T_HM_RISK_TASK_FILE
DELETE T_HM_RISK_TASK_DETAIL
DELETE T_HM_RISK_TASK_AREA
DELETE T_HM_RISK_TASK
/*职业危辨识任务*/
delete T_HM_HAZARD_TASK_DETAIL_IDENTIFYING
delete T_HM_HAZARD_TASK_DETAIL_USER
DELETE T_HM_HAZARD_TASK_DETAIL
DELETE T_HM_HAZARD_TASK_FILE
DELETE T_HM_HAZARD_TASK
/*职业危辨识记录*/
DELETE T_HM_HAZARD_RECORD_FILE
DELETE T_HM_HAZARD_RECORD_USER
DELETE T_HM_HAZARD_RECORD_DETAIL
DELETE T_HM_HAZARD_RECORD
/*9职业危害评价结果表*/
DELETE T_HM_EVALUATE_RESULT_FILE
DELETE T_HM_EVALUATE_RESULT_HAZARD_INDIVIDUAL_MEASURES
DELETE T_HM_EVALUATE_RESULT_HAZARD_ENGINEERING_MEASURES
DELETE T_HM_EVALUATE_RESULT_HAZARD_MANAGEMENT_MEASURES
DELETE T_HM_EVALUATE_RESULT_HAZARD_EDUCATION_MEASURES
DELETE T_HM_EVALUATE_RESULT_HAZARD_EMERGENCY_MEASURES
DELETE T_HM_EVALUATE_RESULT_HAZARD
DELETE T_HM_EVALUATE_RESULT_RISK_WORKDUTY
DELETE T_HM_EVALUATE_RESULT_RISK_EQUIPMENT
DELETE T_HM_EVALUATE_RESULT_RISK_FACILITIES
DELETE T_HM_EVALUATE_RESULT_RISK_INDIVIDUAL_MEASURES
DELETE T_HM_EVALUATE_RESULT_RISK_ENGINEERING_MEASURES
DELETE T_HM_EVALUATE_RESULT_RISK_MANAGEMENT_MEASURES
DELETE T_HM_EVALUATE_RESULT_RISK_EDUCATION_MEASURES
DELETE T_HM_EVALUATE_RESULT_RISK_EMERGENCY_MEASURES
DELETE T_HM_EVALUATE_RESULT_RISK
DELETE T_HM_EVALUATE_RESULT
/*1年度风险评价计划审核表*/
delete T_HM_EVALUATION_FILE
DELETE T_HM_EVALUATION_DETAIL_AREA
DELETE T_HM_EVALUATION_DETAIL_IDENTIFYING
DELETE T_HM_EVALUATION_DETAIL
DELETE T_HM_EVALUATION_PLAN
delete T_HM_JOBTASK_IDENTIFY
delete T_HM_JOBTASK_IDENTIFY_DETAIL
delete T_HM_JOBTASK_IDENTIFY_DETAIL_POST
delete T_HM_JOBTASK_IDENTIFY_DETAIL_RISK
delete T_HM_JOBTASK_IDENTIFY_USER
delete T_HM_JOBTASK_IDENTIFY_FILE
delete T_HM_OPERATION_TASK_DISTINGUISH_ANALYZE
delete T_HM_OPERATION_TASK_DISTINGUISH_ANALYZE_USER
delete T_HM_OPERATION_TASK_DISTINGUISH_ANALYZE_DETAIL
delete T_HM_OPERATION_TASK_DISTINGUISH_ANALYZE_FILE
delete T_HM_OPERATION_TASK_DISTINGUISH_ANALYZE_RISK
delete T_HM_ORDINARY_TASK_ANALYSIS
delete T_HM_ORDINARY_ANALYSIS_PERSON
delete T_HM_ORDINARY_TASK_DETAIL
delete T_HM_ORDINARY_ANALYSIS_FILE
delete T_HM_ORDINARY_TASK_DETAIL_RISK
delete T_HM_CRUCIAL_TASK_ANALYSIS
delete T_HM_CRUCIAL_ANALYSIS_PERSON
delete T_HM_CRUCIAL_TASK_DETAIL
delete T_HM_CRUCIAL_ANALYSIS_FILE
delete T_HM_CRUCIAL_TASK_DETAIL_RISK
delete T_HM_LICENSE_ANALYSIS
delete T_HM_ANALYSIS_PERSON
delete T_HM_LICENSE_ANALYSIS_DETAIL
delete T_HM_LICENSE_ANALYSIS_FILE
delete T_HM_LICENSE_ANALYSIS_DETAIL_RISK
delete T_HM_FILE_PUBLISH
delete T_HM_FILE_PUBLISH_AREA