一.系統概 二.規范性引用文 三.建設原 四.定義和術 五.應用需 六.網絡拓 七.系統功 八.數據庫字段定 九.接口開 十.雙預防與省平臺數據對接規 GB/T31496GB/T33000GB/T21028GB/T20273GB/T20272GB/T20271信息安全技術信息系統通用安全技術要求三.建設原則開放性：整個系統的軟硬件平臺和數據庫系統均具有相當的開放性；系統從設計向其電源64G內存電源128G內存電源64G內存Googlechrome46及以上Safari7Iossafari:8及以上Android8.0/opt/minioBS模式的電腦應用程序和數據可視化展示系統。此外，根據工業領域的特點，根據G30872022特殊作業安全規范，為了企業的安全生產，需建設危險作業（特殊作業）（GB30871-2022）要求，安全管控措施應全部顯示，作業申請人員自行選擇是否涉及，不APP7.13DROPTABLEIFEXISTS`DUTY_CHECK_ORDER_LOG`;CREATETABLE`DUTY_CHECK_ORDER_LOG`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT主鍵`ORDER_NAME`varchar(100DEFAULTNULLCOMMENT排查清單名稱`DUTY_CHECK_ORDER_ID`bigint(20)DEFAULTNULLCOMMENT排查`DUTY_CHECK_ORDER_TYPE_ID`bigint(20)DEFAULTNULL '`DUTY_USER_ID`varchar(36DEFAULTNULLCOMMENT考核人`DUTY_USER_NAME`varchar(200DEFAULTNULLCOMMENT'`APPROVE_USER_ID`bigint(20)DEFAULTNULLCOMMENT'當前需要處`APPROVE_USER_NAME`varchar(200)DEFAULTNULLCOMMENT'當前`BEING_DUTY_USER_ID`varchar(36)DEFAULTNULLCOMMENT'被考核`BEING_DUTY_USER_NAME`varchar(200)DEFAULTNULLCOMMENT`DUTY_USER_SIGN`varchar(200DEFAULTNULLCOMMENT`BEING_DUTY_USER_SIGN`varchar(200)DEFAULTNULLCOMMENT'`CHECK_STATUS`int(11DEFAULTNULLCOMMENT當前狀態`CHECK_TIME`datetimeDEFAULTNULLCOMMENT考核時間`CHECK_RESULT`varchar(200DEFAULTNULLCOMMENT考核結果`HANDLING_SUGGESTION`varchar(300)DEFAULTNULLCOMMENT`APPLY_DESC`varchar(300DEFAULTNULLCOMMENT申訴內容`CREATED_AT`datetimeDEFAULTNULLCOMMENT創建時間`DATA_STATUS`int(11DEFAULT1COMMENT數據狀態`UPDATED_AT`datetimeDEFAULTNULLCOMMENT更新時間',PRIMARYKEY(`ID`)USINGBTREE)ENGINE=InnoDBAUTO_INCREMENT=41199DEFAULTLEC評估DROPTABLEIFEXISTS`BS_LEC_D`;CREATETABLE`BS_LEC_D`(`BS_LEC_D_ID`int(11NOTNULLCOMMENTLEC評估D表`BS_LEC_D_SCOPE_VALUE`varchar(50)DEFAULTNULLCOMMENT`BS_LEC_D_MIN_VALUE`decimal(6,0)DEFAULTNULLCOMMENT'風險`BS_LEC_D_MAX_VALUE`decimal(6,0DEFAULTNULLCOMMENT`BS_LEC_D_LEVEL`varchar(20DEFAULTNULLCOMMENT風險等級`BS_LEC_D_LEVEL_DESC`varchar(50)DEFAULTNULLCOMMENT'風險`BS_LEC_D_SPS`varchar(255)DEFAULTNULLCOMMENT'應采取的行動`BS_LEC_D_DEADLINE`varchar(255DEFAULTNULLCOMMENT'PRIMARYKEY(`BS_LEC_D_ID`)USING)ENGINE=InnoDBDEFAULTCHARSET=utf8mb4COMMENT='LEC風險等級危險化學DROPTABLEIFEXISTS`CHEMICAL_BOOK`;CREATETABLE`CHEMICAL_BOOK`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT主鍵`DANGEROUS_CHEMICAL_LIB_ID`bigint(20)NOTNULLCOMMENT '`BOOK_DUTY_DEPT_ID`bigint(20NOTNULLCOMMENT管控部門`BOOK_DUTY_DEPT_IDS`varchar(30)DEFAULTNULLCOMMENT管控`BOOK_DUTY_DEPT_NAME`varchar(100)NOTNULLCOMMENT'管控部21點4221點42`BOOK_DUTY_USER_ID`bigint(20NOTNULLCOMMENT管控人`BOOK_DUTY_USER_IDS`varchar(30)DEFAULTNULLCOMMENT管控人ID`BOOK_DUTY_USER_NAME`varchar(30)DEFAULTNULLCOMMENT`GOODS_SITE`varchar(30DEFAULTNULLCOMMENT存放位置`GOODS_STORE`varchar(30DEFAULTNULLCOMMENT現在庫存`DATA_STATUS`int(11)DEFAULT`TENANT_ID`bigint(20DEFAULTNULLCOMMENT租戶`CREATED_AT`bigint(20DEFAULTNULLCOMMENT創建時間`UPDATED_AT`bigint(20DEFAULTNULLCOMMENT更新時間`STORE_FACILITY`varchar(50DEFAULTNULLCOMMENT儲存設施 '`CREATOR_ID`varchar(36DEFAULTNULLCOMMENT創建用戶`CREATOR_NAME`varchar(20DEFAULTNULLCOMMENTPRIMARYKEY(`ID`)USING)ENGINE=InnoDBAUTO_INCREMENT=5DEFAULTDROPTABLEIFEXISTS`EMERGENCY_AID_AGENCIES`;CREATETABLE`EMERGENCY_AID_AGENCIES`( AUTO_INCREMENTCOMMENT'應急救援機構ID', COMMENT'機構名稱',`FOUND_DATE_AT`bigint(20DEFAULTNULLCOMMENT（時`BELONGS_DEPT_ID`bigint(20DEFAULTNULLCOMMENT所屬部門id`BELONGS_DEPT_IDS`varchar(20DEFAULTNULLCOMMENT'所屬部門 `BELONGS_DEPT_ANME`varchar(100)DEFAULTNULLCOMMENT'所屬`PRINCIPAL_USER_ID`varchar(36DEFAULTNULLCOMMENT負責人`PRINCIPAL_USER_NAME`varchar(100DEFAULTNULLCOMMENT負責`ORGANIZATIONAL_RESPONSIBILTIES_DESC`textCOMMENT`UPLOAD_ATTACHMENT_URL`varchar(255)DEFAULTNULL`DATA_STATUS`smallint(6)NOTNULLDEFAULT'1'COMMENT數據狀態15刪除`CREATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT創建人`CREATOR_USER_NAME`varchar(50DEFAULTNULLCOMMENT`UPDATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT修改人`UPDATOR_USER_NAME`varchar(50)DEFAULTNULLCOMMENT修改`CREATED_AT`datetimeDEFAULTNULLCOMMENT創建時間`UPDATED_AT`datetimeDEFAULTNULLCOMMENT修改時間`DEPT_ID`bigint(20DEFAULTNULLCOMMENT部門ID`TENANT_ID`bigint(13)unsignedzerofillDEFAULTNULLCOMMENT'租戶PRIMARYKEY(`EMERGENCY_AID_AGENCIES_ID`)USING COMMENT='--應急救援機構DROPTABLEIFEXISTS`EQUIPMENT_FACILITIES_ACCOUNT`;CREATETABLE`EQUIPMENT_FACILITIES_ACCOUNT`(`ID`bigint(20NOTNULLAUTO_INCREMENTCOMMENT序號`EQUIPMENT_NUMBER`varchar(100DEFAULTNULLCOMMENT`EQUIPMENT_NAME`varchar(100DEFAULTNULLCOMMENT設備名稱`EQUIPMENT_TYPE_ID`bigint(20)DEFAULTNULLCOMMENT'設備類型`EQUIPMENT_TYPE`varchar(100DEFAULTNULLCOMMENT設備類型 '`OPERATING_TEMPERATURE`varchar(100)DEFAULTNULLCOMMENT`OPERATING_PRESSURE`varchar(100)DEFAULTNULLCOMMENT'操作`MRDIUM`varchar(100DEFAULTNULLCOMMENT介質`MEDIA_STATUS`varchar(100DEFAULTNULLCOMMENT介質狀態`TEXTURE_OF_MATERIAL`varchar(100)DEFAULTNULLCOMMENT`INSTALLATION_POSITION`varchar(100DEFAULTNULLCOMMENT'`JURISDICTION_DEPT_ID`bigint(20)DEFAULTNULLCOMMENT'管轄部`JURISDICTION_DEPT_IDS`varchar(100)DEFAULTNULLCOMMENT`JURISDICTION_DEPT_NAME`varchar(100)DEFAULTNULLCOMMENT`MANUFACTURER`varchar(100DEFAULTNULLCOMMENT制造廠商`DELIVERY_DATE`datetimeDEFAULTNULLCOMMENT出廠時間`DELIVERY_NUMBER`varchar(100)DEFAULTNULLCOMMENT出廠編`EQUIPMENT_STATUS`smallint(6)DEFAULT'1'COMMENT'設備狀態：23報廢`IS_SPECIAL_EQUIPMENT`smallint(6DEFAULT'2COMMENT'是否特種設備：12否`COMMISSIONING_DATE`datetimeDEFAULTNULLCOMMENT`SPECIAL_EQUIPMENT_MANAGEMENT`varchar(100)DEFAULT'2未備案 '`LICENSE_NO`varchar(100DEFAULTNULLCOMMENT使用證編號`FILE_NUMBER`varchar(100DEFAULTNULLCOMMENT檔案號`FILING_ATTACHMENT`varchar(255DEFAULTNULLCOMMENT`CREATED_AT`datetimeDEFAULTNULLCOMMENT創建時間`UPDATED_AT`datetimeDEFAULTNULLCOMMENT更新時間`DATA_STATUS`smallint(6)NOTNULLDEFAULT'1'COMMENT數據狀態15刪除`CREATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT創建人`CREATED_BY`varchar(50DEFAULTNULLCOMMENT創建人`UPDATOR_USER_ID`varchar(36DEFAULTNULLCOMMENT修改人`UPDATOR_BY`varchar(50DEFAULTNULLCOMMENT修改人',PRIMARYKEY(`ID`)USINGBTREE HiddenDangerReportedControllerPOST/cs/hidden-danger-reported/abarbeitung隱患--整改--提交GET/cs/hidden-danger-reported/delete/{id}隱患刪除GET/cs/hidden-danger-reported/getMyCreate隱患--我的整改任GET/cs/hidden-danger-reported/myProcessedTask隱患--我的整GET/cs/hidden-danger-reported/myTaskSum隱患--我的隱患排GET/cs/hidden-danger-reported/myWaitingTask隱患--我的整改HiddenDangerTaskLogControllerGET/cs/hidden-danger-task/clearData清理數據(之前變更產生垃GET/cs/hidden-danger-task/cLearLogData清理無效記錄數據(之GET/cs/hidden-danger-task/getTask隱患管理-一鍵生成任務GET/cs/hidden-danger-task/myProcessedTask我的隱患排查任GET/cs/hidden-danger-task/myWaitingTask我的隱患排查任務GET/cs/hidden-danger-task/pageRecord隱患排查記錄}HiddenCheckOrderLogControllerGET/newHiddenCheckLog/byAnaLyticId/{id}獲取單元數據統POST/newHiddenCheckLog/commit/task新版-提交隱患排查任GET/newHiddenCheckLog/deLayTask/{time}新版-任務漏查測GET/newHiddenCheckLog/detaiL/{id}新版-獲取隱患排查任務POST/newHiddenCheckLog/myDispose/pageList新版-已處理POST/newHiddenCheckLog/myPending/pageList新版-未處理GET/newHiddenCheckLog/notifyTask/{time}新版-任務到期測POST/newHiddenCheckLog/oneOrder/pageList新版-對應的排POST/newHiddenCheckLog/pageAlLList新版-所有的排查清單GET/newHiddenCheckLog/scan/byOrderId/{id}獲取帶有圣緯GET/newHiddenCheckLog/setOrderAddDutyDeptId排查日志GET/newHiddenCheckLog/setOrderAddUnit清單添加風險分GET/newHiddenCheckLog/testTask/{time}新版-生成任務測試GET/newHiddenCheckLog/totalInfo/{id}新版-某個隱患排查清GET/hiddenCheckOrder/checkMethods/byOrderId/{id}獲取帶GET/hiddenCheckOrder/clear0LdRiskIdentificationData清理以GET/hiddenCheckOrder/delete/{id}GET/hiddenCheckOrder/detaiL/{id}隱患排查清單詳細信息GET/hiddenCheckOrder/disable/{id}禁用用隱患排查清單GET/hiddenCheckOrder/enable/{id}啟用隱患排查清單GET/hiddenCheck0rder/LatiAndLongi/orderList獲取帶有經緯POST/hiddenCheck0rder/LatiAndLongi/orderList重置某個清POST/hiddenCheckOrder/listByType獲取相對應的清單類型的POST/hiddenCheckOrderType/add新增數據GET/hiddenCheckOrderType/delete/{id}刪除數據GET/hiddenCheck0rderType/list列表下拉框查詢所有數據口AnalyticUnitGET/cs/analytic-unit/clearObject清理無效風險對象/cs/analytic-unit/deleteBatch根據list刪除POST/cs/analytic-unit/getAnalytic查看對象/單元詳情POST/cs/anaLytic-unit/getTreeList獲取樹狀數據GET/cs/analytic-unit/objectList分析對象列表/cs/analytic-unit/saveImg添加風險空間分布圖單元POST/cs/analytic-unit/saveObject新增對象POST/cs/analytic-unit/saveUnit新增單元GET/cs/analytic-unit/scanDetail/{id}移動端分析單元掃碼獲取詳GET/cs/analytic-unit/unitList/{id}口RiskIdentificationGET/cs/risk-identification/contort/page風險辨識-管控措施分頁查DELETE/cs/risk-identification/deleteBatch根據list刪除GET/cs/risk-identification/getone詳情UserControllerPOST/sys_user/deleteHiddenUse刪除隱患分配人GET/sys_user/getSysUserByDeptId根據部門ID獲取人員信息GET/sys_user/hiddenUserPage隱患分配人分頁查詢PoitionContrlerDeptControllerGET/sys_dept/getSysDeptHiddenUserTreeList獲取隱患分配GET/sys_dept/getSysDeptTreeList獲取部門tree列表數據GET/sys_dept/getSysDeptTreeListById根據ID獲取部門tree列GET/sys_dept/getSysDeptUserTreeList獲取部門人員tree列表WorkDictDELETE/riskWork/de飛根據list刪除DELETE/riskWork/delete刪除GET/riskWork/getAllListsWithTree危險作業-》危險作業字典表GET/riskWork/getListsWithTree/{name}危險作業-GET/riskWork/getOnt/{id}危險作業-GET/specialwork/certificate/aLLList移動端本地存儲用的DELETE/specialwork/certificate/deLeete/{id}刪除GET/speciaLwork/certificate/detait/{id}詳情POST/specialwork/certificate/pageList分頁列表GET/specialwork/certificate/typeList/{typeId}下拉列表POST/specialwork/certificate/update更新POST/specialWorkTicket/accept/pageList作業驗收分頁列表POST/specialWorkTicket/acceptCLarificaiton接受交底POST/specialWorkTicket/acceptTicket作業驗收POST/specialWorkTicket/add新增POST/specialWorkTicket/approveTicket作業審批