430/mdc_430_new.git

zhangherong

2025-07-10 6c85448ee73a84b55eac6b77136c61b510c12557

art: 数据库脚本整理

已修改5个文件

	db/430设备管理数据库设计.pdma.json	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	db/ZHR/create_table_zhr.sql	1307 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	db/ZHR/dict_zhr.sql	62 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	db/ZHR/menu_zhr.sql	8 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	lxzn-module-eam-common/src/main/java/org/jeecg/modules/eam/constant/TechnicalStatusEvaluationOrderStatusEnum.java	9 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史

 db/430Éè±¸¹ÜÀíÊý¾Ý¿âÉè¼Æ.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": "",

 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ï¼V2+', '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ï¼V2+',
     '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'


--ææ¯ç¶æé´å®å·¥ååæ´

 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);


 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);

 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, //åæ´ä¸

			@@ -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": "",

			@@ -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);

			@@ -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);

			@@ -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, //åæ´ä¸