From 6c85448ee73a84b55eac6b77136c61b510c12557 Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期四, 10 七月 2025 20:56:57 +0800
Subject: [PATCH] art: 数据库脚本整理

---
 db/430设备管理数据库设计.pdma.json                                                                                         |    4 
 db/ZHR/dict_zhr.sql                                                                                               |   62 ++
 lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java |    9 
 db/ZHR/create_table_zhr.sql                                                                                       | 1307 ++++++++++++++++++++++++++++++++++++++++++------------
 db/ZHR/menu_zhr.sql                                                                                               |    8 
 5 files changed, 1,091 insertions(+), 299 deletions(-)

diff --git "a/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json" "b/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
index 3031dbd..3c07a00 100644
--- "a/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
+++ "b/db/430\350\256\276\345\244\207\347\256\241\347\220\206\346\225\260\346\215\256\345\272\223\350\256\276\350\256\241.pdma.json"
@@ -4,7 +4,7 @@
   "avatar": "",
   "version": "4.9.2",
   "createdTime": "2025-3-10 16:38:19",
-  "updatedTime": "2025-7-10 19:45:43",
+  "updatedTime": "2025-7-10 20:07:59",
   "dbConns": [],
   "profile": {
     "default": {
@@ -24725,7 +24725,7 @@
         {
           "defKey": "evaluation_status",
           "defName": "閴村畾鐘舵��",
-          "comment": "寰呴壌瀹氥�侀壌瀹氫腑銆佺淮淇涓讳换绛惧瓧銆佸伐鑹轰汉鍛樼瀛椼�佷娇鐢ㄥ崟浣嶆妧鏈富绠$瀛椼�佽澶囨楠屽憳绛惧瓧銆佸凡瀹屾垚銆佸凡閿佸畾銆佸彉鏇翠腑銆佸凡杩囨湡",
+          "comment": "寰呴壌瀹氥�侀壌瀹氫腑銆佺淮淇汉绛惧瓧銆佺淮淇涓讳换绛惧瓧銆佸伐鑹轰汉鍛樼瀛椼�佷娇鐢ㄥ崟浣嶆妧鏈富绠$瀛椼�佽澶囨楠屽憳绛惧瓧銆佸凡瀹屾垚銆佸凡閿佸畾銆佸彉鏇翠腑銆佸凡杩囨湡",
           "type": "",
           "len": "",
           "scale": "",
diff --git a/db/ZHR/create_table_zhr.sql b/db/ZHR/create_table_zhr.sql
index 7a2cb5a..a791fce 100644
--- a/db/ZHR/create_table_zhr.sql
+++ b/db/ZHR/create_table_zhr.sql
@@ -1,330 +1,1051 @@
 -- HF缂栫爜缁存姢
 IF EXISTS (SELECT *
-           FROM sys.objects
+           FROM sys.all_objects
            WHERE object_id = OBJECT_ID(N'[dbo].[eam_base_hf_code]')
-             AND type in (N'U'))
-    DROP TABLE [dbo].[eam_base_hf_code];
+             AND type IN ('U'))
+    DROP TABLE [dbo].[eam_base_hf_code]
+GO
+
 CREATE TABLE [dbo].[eam_base_hf_code]
 (
-    id          NVARCHAR(32) NOT NULL,
-    create_by   NVARCHAR(50),
-    create_time DATETIME2,
-    update_by   NVARCHAR(50),
-    update_time DATETIME2,
-    del_flag    INT,
-    hf_code     NVARCHAR(100),
-    hf_name     NVARCHAR(255),
-    hf_category NVARCHAR(64),
-    hf_status   NVARCHAR(64),
-    hf_version  NVARCHAR(50),
-    PRIMARY KEY (id)
-);
+    [id]          nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
+    [create_by]   nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [create_time] datetime2(7)                            NULL,
+    [update_by]   nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [update_time] datetime2(7)                            NULL,
+    [del_flag]    int                                     NULL,
+    [hf_code]     nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_name]     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_category] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [hf_status]   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [hf_version]  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL
+)
+GO
 
-EXEC sp_addextendedproperty 'MS_Description', '鎶ヨ〃HFCode缁存姢', 'SCHEMA', dbo, 'table', eam_base_hf_code, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
-     create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
-     update_time;
-EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', del_flag;
-EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_code;
-EXEC sp_addextendedproperty 'MS_Description', '妯℃澘鍚嶇О', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column', hf_name;
-EXEC sp_addextendedproperty 'MS_Description', '妯℃澘鍒嗙被', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
-     hf_category;
-EXEC sp_addextendedproperty 'MS_Description', '鐘舵��;鍚敤銆佺鐢�', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
-     hf_status;
-EXEC sp_addextendedproperty 'MS_Description', '鐗堟湰;V1锛孷2+', 'SCHEMA', dbo, 'table', eam_base_hf_code, 'column',
-     hf_version;
+ALTER TABLE [dbo].[eam_base_hf_code]
+    SET (LOCK_ESCALATION = TABLE)
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'涓婚敭',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒犻櫎鏍囪',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'del_flag'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'HF缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'hf_code'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妯℃澘鍚嶇О',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'hf_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妯℃澘鍒嗙被',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'hf_category'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鐘舵��;鍚敤銆佺鐢�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'hf_status'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鐗堟湰;V1锛孷2+',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code',
+     'COLUMN', N'hf_version'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鎶ヨ〃HFCode缁存姢',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_base_hf_code'
+GO
+ALTER TABLE [dbo].[eam_base_hf_code]
+    ADD CONSTRAINT [PK__eam_base__3213E83F80327B31] PRIMARY KEY CLUSTERED ([id])
+        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+        ON [PRIMARY]
+GO
 
 --鎶�鏈壌瀹氳鑼�
 IF EXISTS (SELECT *
-           FROM sys.objects
+           FROM sys.all_objects
            WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard]')
-             AND type in (N'U'))
-    DROP TABLE [dbo].[eam_technical_status_evaluation_standard];
+             AND type IN ('U'))
+    DROP TABLE [dbo].[eam_technical_status_evaluation_standard]
+GO
+
 CREATE TABLE [dbo].[eam_technical_status_evaluation_standard]
 (
-    id                         NVARCHAR(32) NOT NULL,
-    create_by                  NVARCHAR(50),
-    create_time                DATETIME2,
-    update_by                  NVARCHAR(50),
-    update_time                DATETIME2,
-    del_flag                   INT,
-    standard_name              NVARCHAR(255),
-    standard_code              NVARCHAR(50),
-    evaluation_period          INT,
-    equipment_id               NVARCHAR(32),
-    standard_status            NVARCHAR(64),
-    has_safety_equipment_check NVARCHAR(64),
-    has_precision_check        NVARCHAR(64),
-    has_other_check            NVARCHAR(64),
-    standard_version           NVARCHAR(50),
-    remark                     NVARCHAR(255),
-    PRIMARY KEY (id)
-);
+    [id]                         nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
+    [create_by]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [create_time]                datetime2(7)                            NULL,
+    [update_by]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [update_time]                datetime2(7)                            NULL,
+    [del_flag]                   int                                     NULL,
+    [standard_name]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [standard_code]              nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [evaluation_period]          int                                     NULL,
+    [equipment_id]               nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
+    [standard_status]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [has_safety_equipment_check] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [has_precision_check]        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [has_other_check]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [standard_version]           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [remark]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL
+)
+GO
 
-EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氳鑼�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard,
-     'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', update_time;
-EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', del_flag;
-EXEC sp_addextendedproperty 'MS_Description', '瑙勮寖鍚嶇О', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', standard_name;
-EXEC sp_addextendedproperty 'MS_Description', '瑙勮寖缂栫爜', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', standard_code;
-EXEC sp_addextendedproperty 'MS_Description', '閴村畾鍛ㄦ湡', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', evaluation_period;
-EXEC sp_addextendedproperty 'MS_Description', '璁惧ID', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', equipment_id;
-EXEC sp_addextendedproperty 'MS_Description', '瑙勮寖鐘舵��;寰呮彁浜ゃ�佸惎鐢ㄣ�佷綔搴�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', standard_status;
-EXEC sp_addextendedproperty 'MS_Description', '鏄惁鏈夊畨鍏ㄨ缃鏌�;鏄惁', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', has_safety_equipment_check;
-EXEC sp_addextendedproperty 'MS_Description', '鏄惁鏈夎澶囩簿搴︽鏌�;鏄惁', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', has_precision_check;
-EXEC sp_addextendedproperty 'MS_Description', '鏄惁鏈夊叾浠栨鏌�;鏄惁', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', has_other_check;
-EXEC sp_addextendedproperty 'MS_Description', '鐗堟湰;V1,V2+', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard, 'column', standard_version;
-EXEC sp_addextendedproperty 'MS_Description', '澶囨敞', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_standard,
-     'column', remark;
+ALTER TABLE [dbo].[eam_technical_status_evaluation_standard]
+    SET (LOCK_ESCALATION = TABLE)
+GO
 
+EXEC sp_addextendedproperty
+     'MS_Description', N'涓婚敭',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒犻櫎鏍囪',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'del_flag'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瑙勮寖鍚嶇О',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'standard_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瑙勮寖缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'standard_code'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'閴村畾鍛ㄦ湡',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'evaluation_period'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧ID',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'equipment_id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瑙勮寖鐘舵��;寰呮彁浜ゃ�佸惎鐢ㄣ�佷綔搴�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'standard_status'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏄惁鏈夊畨鍏ㄨ缃鏌�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'has_safety_equipment_check'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏄惁鏈夎澶囩簿搴︽鏌�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'has_precision_check'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏄惁鏈夊叾浠栨鏌�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'has_other_check'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鐗堟湰;V1,V2+',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'standard_version'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'澶囨敞',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard',
+     'COLUMN', N'remark'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鎶�鏈姸鎬侀壌瀹氳鑼�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard'
+GO
+ALTER TABLE [dbo].[eam_technical_status_evaluation_standard]
+    ADD CONSTRAINT [PK__eam_tech__3213E83FB7E202C0] PRIMARY KEY CLUSTERED ([id])
+        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+        ON [PRIMARY]
+GO
 --鎶�鏈姸鎬侀壌瀹氳鑼冩槑缁�
 IF EXISTS (SELECT *
-           FROM sys.objects
+           FROM sys.all_objects
            WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_standard_detail]')
-             AND type in (N'U'))
-    DROP TABLE [dbo].[eam_technical_status_evaluation_standard_detail];
+             AND type IN ('U'))
+    DROP TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
+GO
+
 CREATE TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
 (
-    id              NVARCHAR(32) NOT NULL,
-    create_by       NVARCHAR(50),
-    create_time     DATETIME2,
-    update_by       NVARCHAR(50),
-    update_time     DATETIME2,
-    standard_id     NVARCHAR(32),
-    check_category  NVARCHAR(64),
-    item_code       INT,
-    item_name       NVARCHAR(255),
-    tolerance_value NVARCHAR(100),
-    sub_item_name   NVARCHAR(255),
-    PRIMARY KEY (id)
-);
+    [id]              nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
+    [create_by]       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [create_time]     datetime2(7)                            NULL,
+    [update_by]       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [update_time]     datetime2(7)                            NULL,
+    [standard_id]     nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
+    [check_category]  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [item_code]       int                                     NULL,
+    [item_name]       nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [tolerance_value] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [sub_item_name]   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL
+)
+GO
 
-EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氳鑼冩槑缁�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', update_time;
-EXEC sp_addextendedproperty 'MS_Description', '瑙勮寖ID', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', standard_id;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ュ垎绫�;绮惧害妫�鏌ャ�佸畨鍏ㄨ缃鏌ャ�佸叾浠栨鏌�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', check_category;
-EXEC sp_addextendedproperty 'MS_Description', '椤圭洰搴忓彿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', item_code;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ラ」鐩�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', item_name;
-EXEC sp_addextendedproperty 'MS_Description', '鍏佸樊鍊�;绮惧害妫�鏌ュ睍绀�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', tolerance_value;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ュ瓙椤圭洰;绮惧害妫�鏌ュ睍绀猴紝鍙互涓虹┖', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_standard_detail, 'column', sub_item_name;
+ALTER TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
+    SET (LOCK_ESCALATION = TABLE)
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'涓婚敭',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瑙勮寖ID',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'standard_id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ュ垎绫�;绮惧害妫�鏌ャ�佸畨鍏ㄨ缃鏌ャ�佸叾浠栨鏌�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'check_category'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'椤圭洰搴忓彿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'item_code'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ラ」鐩�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'item_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏佸樊鍊�;绮惧害妫�鏌ュ睍绀�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'tolerance_value'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ュ瓙椤圭洰;绮惧害妫�鏌ュ睍绀猴紝鍙互涓虹┖',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail',
+     'COLUMN', N'sub_item_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鎶�鏈姸鎬侀壌瀹氳鑼冩槑缁�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_standard_detail'
+GO
+
+ALTER TABLE [dbo].[eam_technical_status_evaluation_standard_detail]
+    ADD CONSTRAINT [PK__eam_tech__3213E83F6C420333] PRIMARY KEY CLUSTERED ([id])
+        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+        ON [PRIMARY]
+GO
 
 --鎶�鏈姸鎬侀壌瀹氬伐鍗�
 IF EXISTS (SELECT *
-           FROM sys.objects
+           FROM sys.all_objects
            WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order]')
-             AND type in (N'U'))
-    DROP TABLE [dbo].[eam_technical_status_evaluation_order];
+             AND type IN ('U'))
+    DROP TABLE [dbo].[eam_technical_status_evaluation_order]
+GO
+
 CREATE TABLE [dbo].[eam_technical_status_evaluation_order]
 (
-    id                                NVARCHAR(32) NOT NULL,
-    create_by                         NVARCHAR(50),
-    create_time                       DATETIME2,
-    update_by                         NVARCHAR(50),
-    update_time                       DATETIME2,
-    del_flag                          INT,
-    order_num                         NVARCHAR(50),
-    equipment_id                      NVARCHAR(32),
-    standard_id                       NVARCHAR(32),
-    evaluation_date                   DATETIME2,
-    freeze_order_date                 DATETIME2,
-    order_expiration_date             DATETIME2,
-    actual_start_time                 DATETIME2,
-    actual_end_time                   DATETIME2,
-    evaluator                         NVARCHAR(50),
-    evaluation_status                 NVARCHAR(64),
-    creation_method                   NVARCHAR(64),
-    safety_equipment_check_result     NVARCHAR(64),
-    precision_check_result            NVARCHAR(64),
-    functional_check_result           NVARCHAR(64),
-    other_check_result                NVARCHAR(64),
-    repair_manager_signature          NVARCHAR(50),
-    repair_manager_signature_time_1   DATETIME2,
-    sample_check_result               NVARCHAR(64),
-    process_technician_signature      NVARCHAR(50),
-    process_technician_signature_time DATETIME2,
-    evaluation_result                 NVARCHAR(64),
-    evaluation_reason                 NVARCHAR(64),
-    inspector_signature               NVARCHAR(50),
-    inspector_signature_time          DATETIME2,
-    hf_code_a                         NVARCHAR(100),
-    hf_code_b                         NVARCHAR(100),
-    hf_code_c                         NVARCHAR(100),
-    hf_code_d                         NVARCHAR(100),
-    remark                            NVARCHAR(255),
-    PRIMARY KEY (id)
-);
+    [id]                                       nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
+    [create_by]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [create_time]                              datetime2(7)                            NULL,
+    [update_by]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [update_time]                              datetime2(7)                            NULL,
+    [del_flag]                                 int                                     NULL,
+    [order_num]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [equipment_id]                             nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
+    [standard_id]                              nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
+    [evaluation_date]                          datetime2(7)                            NULL,
+    [freeze_order_date]                        datetime2(7)                            NULL,
+    [order_expiration_date]                    datetime2(7)                            NULL,
+    [actual_start_time]                        datetime2(7)                            NULL,
+    [actual_end_time]                          datetime2(7)                            NULL,
+    [evaluator]                                nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [evaluation_status]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [creation_method]                          nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [safety_check_completed]                   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [precision_check_completed]                nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [other_check_completed]                    nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [safety_check_confirm]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [safety_check_confirm_time]                datetime2(7)                            NULL,
+    [safety_check_result]                      nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [safety_check_comment]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [precision_check_confirm]                  nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [precision_check_confirm_time]             datetime2(7)                            NULL,
+    [precision_check_confirm_result]           nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [precision_check_confirm_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [other_check_confirm]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [other_check_confirm_time]                 datetime2(7)                            NULL,
+    [other_check_confirm_result]               nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [other_check_confirm_comment]              nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [safety_equipment_check_result]            nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [precision_check_result]                   nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [functional_check_result]                  nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [other_check_result]                       nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [repairer_signature]                       nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [repairer_signature_time]                  datetime2(7)                            NULL,
+    [repair_manager_signature]                 nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [repair_manager_signature_time]            datetime2(7)                            NULL,
+    [repair_manager_signature_result]          nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [repair_manager_comment]                   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [sample_check_result]                      nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [process_technician_signature]             nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [process_technician_signature_time]        datetime2(7)                            NULL,
+    [process_technician_comment]               nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [depart_technical_leader_signature]        nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [depart_technical_leader_signature_time]   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [depart_technical_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [depart_technical_leader_comment]          nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [evaluation_result]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [evaluation_reason]                        nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [inspector_signature]                      nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [inspector_signature_time]                 datetime2(7)                            NULL,
+    [inspector_comment]                        nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_code_a]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_code_b]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_code_c]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [hf_code_d]                                nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [remark]                                   nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    CONSTRAINT [PK__eam_tech__3213E83F3B4971F7] PRIMARY KEY CLUSTERED ([id])
+        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+        ON [PRIMARY]
+)
+    ON [PRIMARY]
+GO
 
-EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氬伐鍗�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', update_time;
-EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', del_flag;
-EXEC sp_addextendedproperty 'MS_Description', '宸ュ崟鍙�', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', order_num;
-EXEC sp_addextendedproperty 'MS_Description', '璁惧ID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', equipment_id;
-EXEC sp_addextendedproperty 'MS_Description', '瑙勮寖ID', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', standard_id;
-EXEC sp_addextendedproperty 'MS_Description', '璁″垝閴村畾鏃ユ湡;鎻愬墠70澶╃敓鎴愬伐鍗�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', evaluation_date;
-EXEC sp_addextendedproperty 'MS_Description', '閿佸畾宸ュ崟鏃ユ湡;鎻愬墠55澶╅攣瀹氬伐鍗�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', freeze_order_date;
-EXEC sp_addextendedproperty 'MS_Description', '宸ュ崟杩囨湡鏃ユ湡;鍒版湡鏈仛鐩存帴杩囨湡锛屽苟淇敼璁惧鎶�鏈姸鎬佷负绂佺敤', 'SCHEMA', dbo,
-     'table', eam_technical_status_evaluation_order, 'column', order_expiration_date;
-EXEC sp_addextendedproperty 'MS_Description', '瀹為檯寮�濮嬫椂闂�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', actual_start_time;
-EXEC sp_addextendedproperty 'MS_Description', '瀹為檯缁撴潫鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', actual_end_time;
-EXEC sp_addextendedproperty 'MS_Description', '閴村畾浜�', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', evaluator;
-EXEC sp_addextendedproperty 'MS_Description',
-     '閴村畾鐘舵��;寰呴壌瀹氥�侀壌瀹氫腑銆佺淮淇涓讳换绛惧瓧銆佸伐鑹轰汉鍛樼瀛椼�佹妧鏈富绠$瀛椼�佽澶囨楠屽憳绛惧瓧銆佸凡瀹屾垚銆佸凡閿佸畾銆佸彉鏇翠腑銆佸凡杩囨湡',
-     'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order, 'column', evaluation_status;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏂瑰紡', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', creation_method;
-EXEC sp_addextendedproperty 'MS_Description', '瀹夊叏瑁呯疆妫�鏌ョ粨鏋�;鏄�佸惁', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', safety_equipment_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '绮惧害鍙傛暟妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', precision_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '鍔熻兘鐘舵�佹鏌ョ粨鏋�;鏄�佸惁', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', functional_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '鍏朵粬妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', other_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '缁翠慨瀹や富浠荤瀛�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', repair_manager_signature;
-EXEC sp_addextendedproperty 'MS_Description', '缁翠慨瀹や富浠荤瀛楁椂闂�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', repair_manager_signature_time_1;
-EXEC sp_addextendedproperty 'MS_Description', '璇曚欢妫�鏌ョ粨鏋�;鍚堟牸銆佷笉鍚堟牸', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', sample_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '宸ヨ壓鍛樼瀛�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', process_technician_signature;
-EXEC sp_addextendedproperty 'MS_Description', '宸ヨ壓鍛樼瀛楁椂闂�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', process_technician_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '閴村畾缁撴灉;鍚堟牸銆侀檺鐢ㄣ�佺鐢�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', evaluation_result;
-EXEC sp_addextendedproperty 'MS_Description', '闄怽绂佺敤鍘熷洜(澶氶��);瀹夊叏瑁呯疆銆佽澶囧姛鑳姐�佺簿搴︺�佽瘯浠躲�佸叾浠�', 'SCHEMA', dbo,
-     'table', eam_technical_status_evaluation_order, 'column', evaluation_reason;
-EXEC sp_addextendedproperty 'MS_Description', '璁惧妫�鏌ヤ汉绛惧瓧', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', inspector_signature;
-EXEC sp_addextendedproperty 'MS_Description', '璁惧妫�鏌ヤ汉绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', inspector_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '闄勫綍A HF缂栫爜', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', hf_code_a;
-EXEC sp_addextendedproperty 'MS_Description', '闄勫綍B HF缂栫爜', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', hf_code_b;
-EXEC sp_addextendedproperty 'MS_Description', '闄勫綍C HF缂栫爜', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', hf_code_c;
-EXEC sp_addextendedproperty 'MS_Description', '闄勫綍D HF缂栫爜', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order, 'column', hf_code_d;
-EXEC sp_addextendedproperty 'MS_Description', '澶囨敞', 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order,
-     'column', remark;
+ALTER TABLE [dbo].[eam_technical_status_evaluation_order]
+    SET (LOCK_ESCALATION = TABLE)
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'涓婚敭',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒犻櫎鏍囪',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'del_flag'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ュ崟鍙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'order_num'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧ID',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'equipment_id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瑙勮寖ID',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'standard_id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁″垝閴村畾鏃ユ湡;鎻愬墠70澶╃敓鎴愬伐鍗�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'evaluation_date'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'閿佸畾宸ュ崟鏃ユ湡;鎻愬墠55澶╅攣瀹氬伐鍗�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'freeze_order_date'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ュ崟杩囨湡鏃ユ湡;鍒版湡鏈仛鐩存帴杩囨湡锛屽苟淇敼璁惧鎶�鏈姸鎬佷负绂佺敤',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'order_expiration_date'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹為檯寮�濮嬫椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'actual_start_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹為檯缁撴潫鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'actual_end_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'閴村畾浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'evaluator'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description',
+     N'閴村畾鐘舵��;寰呴壌瀹氥�侀壌瀹氫腑銆佺淮淇涓讳换绛惧瓧銆佸伐鑹轰汉鍛樼瀛椼�佷娇鐢ㄥ崟浣嶆妧鏈富绠$瀛椼�佽澶囨楠屽憳绛惧瓧銆佸凡瀹屾垚銆佸凡閿佸畾銆佸彉鏇翠腑銆佸凡杩囨湡',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'evaluation_status'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏂瑰紡',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'creation_method'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ユ槸鍚﹀畬鎴�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_check_completed'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧绮惧害妫�鏌ユ槸鍚﹀畬鎴�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_completed'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ユ槸鍚﹀畬鎴�;鏄惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_completed'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ‘璁や汉',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_check_confirm'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ‘璁ゆ椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_check_confirm_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ‘璁ょ粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ‘璁ゆ剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_check_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧绮惧害妫�鏌ョ‘璁や汉',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_confirm'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧绮惧害妫�鏌ョ‘璁ゆ椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_confirm_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧绮惧害妫�鏌ョ‘璁ょ粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_confirm_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧绮惧害妫�鏌ョ‘璁ゆ剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_confirm_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ‘璁や汉',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_confirm'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ‘璁ゆ椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_confirm_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ‘璁ょ粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_confirm_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ‘璁ゆ剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_confirm_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ粨鏋�;鏄�佸惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'safety_equipment_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'绮惧害鍙傛暟妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'precision_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍔熻兘鐘舵�佹鏌ョ粨鏋�;鏄�佸惁',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'functional_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'other_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨浜虹瀛�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repairer_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨浜虹瀛楁椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repairer_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨瀹や富浠荤瀛�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repair_manager_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨瀹や富浠荤瀛楁椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repair_manager_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨瀹や富浠荤瀛楃粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repair_manager_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨瀹や富浠绘剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'repair_manager_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璇曚欢妫�鏌ョ粨鏋�;鍚堟牸銆佷笉鍚堟牸',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'sample_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ヨ壓鍛樼瀛�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'process_technician_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ヨ壓鍛樼瀛楁椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'process_technician_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ヨ壓鍛樻剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'process_technician_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'浣跨敤鍗曚綅鎶�鏈富绠$瀛�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'depart_technical_leader_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'浣跨敤鍗曚綅鎶�鏈富绠$瀛楁椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'depart_technical_leader_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'浣跨敤鍗曚綅鎶�鏈富绠$瀛楃粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'depart_technical_leader_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'浣跨敤鍗曚綅鎶�鏈富绠℃剰瑙�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'depart_technical_leader_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'閴村畾缁撴灉;鍚堟牸銆侀檺鐢ㄣ�佺鐢�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'evaluation_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'闄�/绂佺敤鍘熷洜(澶氶��);瀹夊叏瑁呯疆銆佽澶囧姛鑳姐�佺簿搴︺�佽瘯浠躲�佸叾浠�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'evaluation_reason'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧妫�鏌ヤ汉绛惧瓧',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'inspector_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧妫�鏌ヤ汉绛惧瓧鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'inspector_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'璁惧妫�鏌ヤ汉鎰忚',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'inspector_comment'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'闄勫綍A HF缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'hf_code_a'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'闄勫綍B HF缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'hf_code_b'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'闄勫綍C HF缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'hf_code_c'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'闄勫綍D HF缂栫爜',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'hf_code_d'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'澶囨敞',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order',
+     'COLUMN', N'remark'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鎶�鏈姸鎬侀壌瀹氬伐鍗�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order'
 
 --鎶�鏈姸鎬侀壌瀹氬伐鍗曟槑缁�
 IF EXISTS (SELECT *
-           FROM sys.objects
+           FROM sys.all_objects
            WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_detail]')
-             AND type in (N'U'))
-    DROP TABLE [dbo].[eam_technical_status_evaluation_order_detail];
+             AND type IN ('U'))
+    DROP TABLE [dbo].[eam_technical_status_evaluation_order_detail]
+GO
+
 CREATE TABLE [dbo].[eam_technical_status_evaluation_order_detail]
 (
-    id                            NVARCHAR(32) NOT NULL,
-    create_by                     NVARCHAR(50),
-    create_time                   DATETIME2,
-    update_by                     NVARCHAR(50),
-    update_time                   DATETIME2,
-    item_code                     INT,
-    check_category                NVARCHAR(64),
-    item_name                     NVARCHAR(255),
-    tolerance_value               NVARCHAR(100),
-    sub_item_name                 NVARCHAR(255),
-    safety_equipment_check_result NVARCHAR(64),
-    other_check_result            NVARCHAR(255),
-    precision_check_result        NUMERIC(24, 4),
-    repairman_signature           NVARCHAR(50),
-    repairman_signature_time      DATETIME2,
-    PRIMARY KEY (id)
-);
+    [id]                            nvarchar(32) COLLATE Chinese_PRC_CI_AS  NOT NULL,
+    [create_by]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [create_time]                   datetime2(7)                            NULL,
+    [update_by]                     nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [update_time]                   datetime2(7)                            NULL,
+    [order_id]                      nvarchar(32) COLLATE Chinese_PRC_CI_AS  NULL,
+    [item_code]                     int                                     NULL,
+    [check_category]                nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [item_name]                     nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [tolerance_value]               nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+    [sub_item_name]                 nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [safety_equipment_check_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS  NULL,
+    [other_check_result]            nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+    [precision_check_result]        numeric(24, 4)                          NULL,
+    [repairman_signature]           nvarchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
+    [repairman_signature_time]      datetime2(7)                            NULL,
+    CONSTRAINT [PK__eam_tech__3213E83F680090BC] PRIMARY KEY CLUSTERED ([id])
+        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
+        ON [PRIMARY]
+)
+    ON [PRIMARY]
+GO
 
-EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氬伐鍗曟槑缁�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', update_time;
-EXEC sp_addextendedproperty 'MS_Description', '搴忓彿', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', item_code;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ュ垎绫�;绮惧害妫�鏌ャ�佸畨鍏ㄨ缃鏌ャ�佸叾浠栨鏌�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', check_category;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ラ」鐩�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', item_name;
-EXEC sp_addextendedproperty 'MS_Description', '鍏佸樊鍊�;绮惧害妫�鏌ュ睍绀�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', tolerance_value;
-EXEC sp_addextendedproperty 'MS_Description', '妫�鏌ュ瓙椤圭洰;绮惧害妫�鏌ュ睍绀猴紝鍙互涓虹┖', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', sub_item_name;
-EXEC sp_addextendedproperty 'MS_Description', '瀹夊叏瑁呯疆妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', safety_equipment_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '鍏朵粬妫�鏌ョ粨鏋�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', other_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '绮惧害妫�楠岀粨鏋�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', precision_check_result;
-EXEC sp_addextendedproperty 'MS_Description', '缁翠慨浜�/绮惧害妫�鏌ヨ�呯瀛�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', repairman_signature;
-EXEC sp_addextendedproperty 'MS_Description', '缁翠慨浜�/绮惧害妫�鏌ヨ�呯瀛楁椂闂�', 'SCHEMA', dbo, 'table',
-     eam_technical_status_evaluation_order_detail, 'column', repairman_signature_time;
+ALTER TABLE [dbo].[eam_technical_status_evaluation_order_detail]
+    SET (LOCK_ESCALATION = TABLE)
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'涓婚敭',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍒涘缓鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊浜�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鏇存柊鏃堕棿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'宸ュ崟ID',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'order_id'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'搴忓彿',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'item_code'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ュ垎绫�;绮惧害妫�鏌ャ�佸畨鍏ㄨ缃鏌ャ�佸叾浠栨鏌�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'check_category'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ラ」鐩�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'item_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏佸樊鍊�;绮惧害妫�鏌ュ睍绀�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'tolerance_value'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'妫�鏌ュ瓙椤圭洰;绮惧害妫�鏌ュ睍绀猴紝鍙互涓虹┖',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'sub_item_name'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'瀹夊叏瑁呯疆妫�鏌ョ粨鏋�;鏄�佸惁銆佹棤',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'safety_equipment_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鍏朵粬妫�鏌ョ粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'other_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'绮惧害妫�楠岀粨鏋�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'precision_check_result'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨浜�/绮惧害妫�鏌ヨ�呯瀛�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'repairman_signature'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'缁翠慨浜�/绮惧害妫�鏌ヨ�呯瀛楁椂闂�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail',
+     'COLUMN', N'repairman_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+     'MS_Description', N'鎶�鏈姸鎬侀壌瀹氬伐鍗曟槑缁�',
+     'SCHEMA', N'dbo',
+     'TABLE', N'eam_technical_status_evaluation_order_detail'
 
 
 --鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�
diff --git a/db/ZHR/dict_zhr.sql b/db/ZHR/dict_zhr.sql
index e69de29..6a8b19b 100644
--- a/db/ZHR/dict_zhr.sql
+++ b/db/ZHR/dict_zhr.sql
@@ -0,0 +1,62 @@
+--鎶�鏈姸鎬侀壌瀹氬伐鍗曠姸鎬�
+delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status';
+delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_order_status');
+
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1943282255763828737', N'鎶�鏈姸鎬侀壌瀹氬伐鍗曠姸鎬�', N'technical_status_evaluation_order_status', N'璁惧绠$悊浣跨敤', 0, N'admin', '2025-07-10 20:12:48.8660000', NULL, NULL, NULL);
+
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282353361088513', N'1943282255763828737', N'寰呴壌瀹�', N'WAIT_EVALUATION', '', 1, 1, N'admin', '2025-07-10 20:13:12.1370000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282402136649730', N'1943282255763828737', N'閴村畾涓�', N'UNDER_EVALUATION', '', 2, 1, N'admin', '2025-07-10 20:13:23.7750000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282529404416002', N'1943282255763828737', N'缁翠慨浜虹瀛椾腑', N'REPAIRER_SIGNING', '', 3, 1, N'admin', '2025-07-10 20:13:54.1090000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282588527325186', N'1943282255763828737', N'缁翠慨瀹や富浠荤瀛椾腑', N'REPAIR_MANAGER_SIGNING', '', 4, 1, N'admin', '2025-07-10 20:14:08.2040000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282688888631297', N'1943282255763828737', N'宸ヨ壓鍛樼瀛椾腑', N'PROCESS_TECHNICIAN_SIGNING', '', 5, 1, N'admin', '2025-07-10 20:14:32.1330000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282764902002689', N'1943282255763828737', N'浣跨敤鍗曚綅鎶�鏈富绠$瀛椾腑', N'DEPART_TECHNICAL_LEADER_SIGNING', '', 6, 1, N'admin', '2025-07-10 20:14:50.2570000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282836200976386', N'1943282255763828737', N'INSPECTOR_SIGNING', N'璁惧妫�楠屽憳绛惧瓧涓�', '', 7, 1, N'admin', '2025-07-10 20:15:07.2550000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282897358123009', N'1943282255763828737', N'宸插畬鎴�', N'COMPLETED', '', 8, 1, N'admin', '2025-07-10 20:15:21.8360000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943282982930313218', N'1943282255763828737', N'宸查攣瀹�', N'LOCKED', '', 9, 1, N'admin', '2025-07-10 20:15:42.2430000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283076018696194', N'1943282255763828737', N'鍙樻洿涓�', N'CHANGING', '', 10, 1, N'admin', '2025-07-10 20:16:04.4340000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943283135447789569', N'1943282255763828737', N'EXPIRED', N'宸茶繃鏈�', '', 11, 1, N'admin', '2025-07-10 20:16:18.6020000', NULL, NULL);
+
+--鎶�鏈姸鎬佹鏌ラ」鍒嗙被
+delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category';
+delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_check_category');
+
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942406054790733826', N'鎶�鏈姸鎬佹鏌ラ」鍒嗙被', N'technical_status_evaluation_check_category', N'璁惧绠$悊浣跨敤', 0, N'admin', '2025-07-08 10:11:06.2770000', NULL, NULL, NULL);
+
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406262689800193', N'1942406054790733826', N'瀹夊叏瑁呯疆妫�鏌�', N'SAFETY_EQUIPMENT_CHECK', '', 1, 1, N'admin', '2025-07-08 10:11:55.8440000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406374128263170', N'1942406054790733826', N'绮惧害妫�鏌�', N'PRECISION_CHECK', '', 2, 1, N'admin', '2025-07-08 10:12:22.4130000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942406681549774850', N'1942406054790733826', N'鍏朵粬妫�鏌�', N'OTHER_CHECK', '', 3, 1, N'admin', '2025-07-08 10:13:35.7220000', NULL, NULL);
+
+--鎶�鏈姸鎬侀壌瀹氳鑼冪姸鎬�
+delete from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status';
+delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='technical_status_evaluation_standard_status');
+
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1942405419550810113', N'鎶�鏈姸鎬侀壌瀹氳鑼冪姸鎬�', N'technical_status_evaluation_standard_status', N'璁惧绠$悊浣跨敤', 0, N'admin', '2025-07-08 10:08:34.8250000', NULL, NULL, NULL);
+
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405572965867522', N'1942405419550810113', N'寰呮彁浜�', N'WAIT_SUBMIT', '', 1, 1, N'admin', '2025-07-08 10:09:11.4020000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405638514450434', N'1942405419550810113', N'鍚敤', N'ENABLE', '', 2, 1, N'admin', '2025-07-08 10:09:27.0300000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1942405710740365313', N'1942405419550810113', N'绂佺敤', N'DISABLE', '', 3, 1, N'admin', '2025-07-08 10:09:44.2500000', NULL, NULL);
+
+--HF妯℃澘鍒嗙被
+delete from [dbo].[sys_dict] where dict_code='hf_template_category';
+delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='hf_template_category');
+
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941372067586695170', N'HF妯℃澘鍒嗙被', N'hf_template_category', N'璁惧绠$悊浣跨敤', 0, N'admin', '2025-07-05 13:42:24.5310000', NULL, NULL, NULL);
+
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372224336224258', N'1941372067586695170', N'鐐规', N'INSPECTION', '', 1, 1, N'admin', '2025-07-05 13:43:01.9000000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372326169731074', N'1941372067586695170', N'浜屼繚', N'SECOND_MAINTENANCE', '', 2, 1, N'admin', '2025-07-05 13:43:26.1820000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941372412710805506', N'1941372067586695170', N'涓変繚绉讳氦鍗�', N'THIRD_MAINTENANCE_HANDOVER', '', 3, 1, N'admin', '2025-07-05 13:43:46.0000000', N'admin', '2025-07-10 15:26:39.3940000');
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210356597813250', N'1941372067586695170', N'涓変繚楠屾敹鍗�', N'THIRD_MAINTENANCE_ACCEPTANCE', '', 4, 1, N'admin', '2025-07-10 15:27:06.7660000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210616086818818', N'1941372067586695170', N'鎶�鏈姸鎬侀壌瀹氳〃', N'TECHNICAL_STATUS_EVALUATION', '', 5, 1, N'admin', '2025-07-10 15:28:08.0000000', N'admin', '2025-07-10 15:31:13.3650000');
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943210729806983169', N'1941372067586695170', N'瀹夊叏瑁呯疆妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_SAFETY_CHECK', '', 6, 1, N'admin', '2025-07-10 15:28:35.0000000', N'admin', '2025-07-10 15:29:46.5590000');
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211129419296770', N'1941372067586695170', N'鍏朵粬妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_OTHER_CHECK', '', 7, 1, N'admin', '2025-07-10 15:30:11.0000000', N'admin', '2025-07-10 15:31:23.8110000');
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1943211241587568641', N'1941372067586695170', N'璁惧绮惧害妫�鏌ヨ〃', N'TECHNICAL_STATUS_EVALUATION_PRECISION_CHECK', '', 8, 1, N'admin', '2025-07-10 15:30:37.0000000', N'admin', '2025-07-10 15:31:29.2060000');
+
+--鍚敤绂佺敤
+delete from [dbo].[sys_dict] where dict_code='enable_disable';
+delete from [dbo].[sys_dict_item] where dict_id in (select id from [dbo].[sys_dict] where dict_code='enable_disable');
+
+INSERT INTO [dbo].[sys_dict] ([id], [dict_name], [dict_code], [description], [del_flag], [create_by], [create_time], [update_by], [update_time], [type]) VALUES (N'1941370835371483137', N'鍚敤绂佺敤', N'enable_disable', N'閫氱敤鏁版嵁瀛楀吀', 0, N'admin', '2025-07-05 13:37:30.7420000', NULL, NULL, NULL);
+
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941370959137005570', N'1941370835371483137', N'鍚敤', N'ENABLE', '', 1, 1, N'admin', '2025-07-05 13:38:00.2500000', NULL, NULL);
+INSERT INTO [dbo].[sys_dict_item] ([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1941371030628917250', N'1941370835371483137', N'绂佺敤', N'DISABLE', '', 2, 1, N'admin', '2025-07-05 13:38:17.2920000', NULL, NULL);
+
diff --git a/db/ZHR/menu_zhr.sql b/db/ZHR/menu_zhr.sql
index e69de29..e31a508 100644
--- a/db/ZHR/menu_zhr.sql
+++ b/db/ZHR/menu_zhr.sql
@@ -0,0 +1,8 @@
+--鎶�鏈姸鎬侀壌瀹氱浉鍏宠彍鍗�
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942133491313348610', N'1939897134526668802', N'鎶�鏈姸鎬侀壌瀹氳鑼�', N'/eam/base/technical/standard', N'eam/base/EamTechnicalStatusEvaluationStandardList', NULL, NULL, 1, NULL, N'1', 1, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-07 16:08:02.0830000', NULL, NULL, 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942928966207553537', N'1939877842439544833', N'鎶�鏈姸鎬侀壌瀹�', N'/eam/technical', N'layouts/RouteView', NULL, NULL, 1, NULL, N'1', 3, 0, NULL, 1, 0, 0, 0, 0, NULL, N'admin', '2025-07-09 20:48:58.0000000', N'admin', '2025-07-09 21:06:01.5150000', 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942929298551619586', N'1942928966207553537', N'鎶�鏈姸鎬侀壌瀹氬伐鍗�', N'/eam/technical/order', N'eam/technical/EamTechnicalStatusEvaluationOrderList', NULL, NULL, 1, NULL, N'1', 1, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-09 20:50:17.3260000', NULL, NULL, 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942929536536428545', N'1942928966207553537', N'鎶�鏈姸鎬佸伐鍗曞彉鏇�', N'/eam/technical/order/change', N'eam/technical/EamTechnicalStatusEvaluationOrderChangeList', NULL, NULL, 1, NULL, N'1', 2, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-09 20:51:14.0520000', NULL, NULL, 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942929936559783938', N'1942928966207553537', N'鎶�鏈姸鎬佸彉鏇寸敵璇�', N'/eam/technical/status/change', N'eam/technical/EamTechnicalStatusChangeList', NULL, NULL, 1, NULL, N'1', 3, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-09 20:52:49.4250000', NULL, NULL, 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942930660488265730', N'1942928966207553537', N'鎶�鏈姸鎬侀壌瀹氱敵璇�', N'/eam/technical/evaluation/application', N'eam/technical/EamTechnicalStatusEvaluationApplicationList', NULL, NULL, 1, NULL, N'1', 4, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-09 20:55:42.0220000', NULL, NULL, 0, NULL, N'1', 0);
+INSERT INTO [dbo].[sys_permission] ([id], [parent_id], [name], [url], [component], [component_name], [redirect], [menu_type], [perms], [perms_type], [sort_no], [always_show], [icon], [is_route], [is_leaf], [keep_alive], [hidden], [hide_tab], [description], [create_by], [create_time], [update_by], [update_time], [del_flag], [rule_flag], [status], [internal_or_external]) VALUES (N'1942930964046823425', N'1942928966207553537', N'鍋滅敤鐢宠', N'/eam/technical/deactivate', N'eam/technical/EamTechnicalStatusDeactivateList', NULL, NULL, 1, NULL, N'1', 5, 0, NULL, 1, 1, 0, 0, 0, NULL, N'admin', '2025-07-09 20:56:54.3950000', NULL, NULL, 0, NULL, N'1', 0);
diff --git a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java
index 1234325..483d514 100644
--- a/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java
+++ b/lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java
@@ -3,10 +3,11 @@
 public enum TechnicalStatusEvaluationOrderStatusEnum {
     WAIT_EVALUATION, //寰呴壌瀹�
     UNDER_EVALUATION, //閴村畾涓�
-    repair_manager_signing, //缁翠慨瀹や富浠荤瀛�
-    PROCESS_TECHNICIAN_SIGNING, //宸ヨ壓浜哄憳绛惧瓧
-    DEPART_TECHNICAL_LEADER_SIGNING, //浣跨敤鍗曚綅鎶�鏈富绠$瀛�
-    INSPECTOR_SIGNING, //璁惧妫�楠屽憳绛惧瓧
+    REPAIRER_SIGNING, //缁翠慨浜虹瀛椾腑
+    REPAIR_MANAGER_SIGNING, //缁翠慨瀹や富浠荤瀛椾腑
+    PROCESS_TECHNICIAN_SIGNING, //宸ヨ壓鍛樼瀛椾腑
+    DEPART_TECHNICAL_LEADER_SIGNING, //浣跨敤鍗曚綅鎶�鏈富绠$瀛椾腑
+    INSPECTOR_SIGNING, //璁惧妫�楠屽憳绛惧瓧涓�
     COMPLETED, //宸插畬鎴�
     LOCKED, //宸查攣瀹�
     CHANGING, //鍙樻洿涓�

--
Gitblit v1.9.3