From bcd90314646203b32f73c89c1c2f89eaa96e2c9f Mon Sep 17 00:00:00 2001
From: zhangherong <571457620@qq.com>
Date: 星期五, 18 七月 2025 18:05:35 +0800
Subject: [PATCH] art: 设备台账-查询需要做技术状态鉴定的设备列表
---
db/ZHR/create_table_zhr.sql | 1859 ++++++++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 1,433 insertions(+), 426 deletions(-)
diff --git a/db/ZHR/create_table_zhr.sql b/db/ZHR/create_table_zhr.sql
index 7a2cb5a..dae5b33 100644
--- a/db/ZHR/create_table_zhr.sql
+++ b/db/ZHR/create_table_zhr.sql
@@ -1,416 +1,1295 @@
-- 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'
--鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�
-IF EXISTS (SELECT *
- FROM sys.objects
- WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_order_change]')
- AND type in (N'U'))
- DROP TABLE [dbo].[eam_technical_status_evaluation_order_change];
CREATE TABLE [dbo].[eam_technical_status_evaluation_order_change]
(
- id NVARCHAR(32) NOT NULL,
- create_by NVARCHAR(50),
- create_time DATETIME2,
- update_by NVARCHAR(50),
- update_time DATETIME2,
- del_flag INT,
- order_id NVARCHAR(32),
- change_order_num NVARCHAR(100),
- applicant NVARCHAR(50),
- factory_org_code NVARCHAR(100),
- apply_date DATETIME2,
- change_status NVARCHAR(64),
- apply_reason NVARCHAR(64),
- deferred_maintenance_date DATETIME2,
- equipment_manager_signature NVARCHAR(50),
- equipment_manager_signature_time DATETIME2,
- depart_manager_signature NVARCHAR(50),
- depart_manager_signature_time DATETIME2,
- depart_manager_comment NVARCHAR(255),
- production_support_signature NVARCHAR(50),
- production_support_signature_time DATETIME2,
- production_support_comment NVARCHAR(255),
- hf_code NVARCHAR(100),
- 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_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
+ [equipment_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
+ [change_order_num] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ [applicant] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [factory_org_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ [apply_date] datetime2(7) NULL,
+ [change_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [apply_reason] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [deferred_evaluation_date] datetime2(7) NULL,
+ [equipment_manager_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [equipment_manager_signature_time] datetime2(7) NULL,
+ [equipment_manager_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [equipment_manager_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_manager_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_manager_signature_time] datetime2(7) NULL,
+ [depart_manager_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_manager_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ [production_support_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [production_support_signature_time] datetime2(7) NULL,
+ [production_support_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [production_support_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ CONSTRAINT [PK__eam_tech__3213E83FFE6D6178] 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_change, null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', update_time;
-EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', del_flag;
-EXEC sp_addextendedproperty 'MS_Description', '宸ュ崟ID', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', order_id;
-EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曞彿', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', change_order_num;
-EXEC sp_addextendedproperty 'MS_Description', '鐢宠浜�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', applicant;
-EXEC sp_addextendedproperty 'MS_Description', '鐢宠閮ㄩ棬', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', factory_org_code;
-EXEC sp_addextendedproperty 'MS_Description', '鐢宠鏃ユ湡', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', apply_date;
-EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鐘舵��;寰呮彁浜ゃ�佸緟涓荤瀹℃牳銆佸緟閮ㄩ棬纭銆佸緟淇濋殰閮ㄧ‘璁ゃ�佸凡浣滃簾銆佸凡瀹屾垚',
- 'SCHEMA', dbo, 'table', eam_technical_status_evaluation_order_change, 'column', change_status;
-EXEC sp_addextendedproperty 'MS_Description',
- '鍙樻洿鍘熷洜;鐢熶骇浠诲姟鎬ユ棤娉曞仠鏈恒�佽澶囨晠闅滄澶勪簬缁翠慨鐘舵�併�佽澶囧凡鎶ュ簾銆佽澶囧ぇ淇�佹惉杩併�佹敼閫�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', apply_reason;
-EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿閴村畾鏃ユ湡', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', deferred_maintenance_date;
-EXEC sp_addextendedproperty 'MS_Description', '涓荤棰嗗绛惧瓧', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature;
-EXEC sp_addextendedproperty 'MS_Description', '涓荤棰嗗绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', equipment_manager_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗绛惧瓧;鏍规嵁鍙樻洿鍘熷洜绫诲瀷鍖哄垎涓嶅悓鐨勪汉瀹℃壒', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', depart_manager_signature;
-EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', depart_manager_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '閮ㄩ棬棰嗗鎰忚', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', depart_manager_comment;
-EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', production_support_signature;
-EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛楁椂闂�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', production_support_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵兼剰瑙�', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', production_support_comment;
-EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table',
- eam_technical_status_evaluation_order_change, 'column', hf_code;
+ALTER TABLE [dbo].[eam_technical_status_evaluation_order_change]
+ SET (LOCK_ESCALATION = TABLE)
+GO
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓婚敭',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鏇存柊浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鏇存柊鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒犻櫎鏍囪',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'del_flag'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'宸ュ崟ID',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'order_id'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'璁惧ID',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'equipment_id'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿鍗曞彿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'change_order_num'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢宠浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'applicant'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢宠閮ㄩ棬',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'factory_org_code'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢宠鏃ユ湡',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'apply_date'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿鐘舵��;寰呮彁浜ゃ�佸緟涓荤瀹℃牳銆佸緟閮ㄩ棬纭銆佸緟淇濋殰閮ㄧ‘璁ゃ�佸凡浣滃簾銆佸凡瀹屾垚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'change_status'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿鍘熷洜;鐢熶骇浠诲姟鎬ユ棤娉曞仠鏈恒�佽澶囨晠闅滄澶勪簬缁翠慨鐘舵�併�佽澶囧凡鎶ュ簾銆佽澶囧ぇ淇�佹惉杩併�佹敼閫�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'apply_reason'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿閴村畾鏃ユ湡',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'deferred_evaluation_date'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓荤棰嗗绛惧瓧',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'equipment_manager_signature'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓荤棰嗗绛惧瓧鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'equipment_manager_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓荤棰嗗绛惧瓧缁撴灉',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'equipment_manager_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓荤棰嗗鎰忚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'equipment_manager_comment'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧;鏍规嵁鍙樻洿鍘熷洜绫诲瀷鍖哄垎涓嶅悓鐨勪汉瀹℃壒',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'depart_manager_signature'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'depart_manager_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'閮ㄩ棬棰嗗绛惧瓧缁撴灉',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'depart_manager_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'閮ㄩ棬棰嗗鎰忚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'depart_manager_comment'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'production_support_signature'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛楁椂闂�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'production_support_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵肩瀛楃粨鏋�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'production_support_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢熶骇淇濋殰閮ㄩ瀵兼剰瑙�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'production_support_comment'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'HF缂栫爜',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change',
+ 'COLUMN', N'hf_code'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_evaluation_order_change'
--鎶�鏈姸鎬佸彉鏇寸敵璇�
IF EXISTS (SELECT *
@@ -420,61 +1299,189 @@
DROP TABLE [dbo].[eam_technical_status_change];
CREATE TABLE [dbo].[eam_technical_status_change]
(
- id NVARCHAR(32) NOT NULL,
- create_by NVARCHAR(50),
- create_time DATETIME2,
- update_by NVARCHAR(50),
- update_time DATETIME2,
- del_flag INT,
- change_order_num NVARCHAR(100),
- change_status NVARCHAR(64),
- designer NVARCHAR(50),
- designer_time DATETIME2,
- depart_header_signature NVARCHAR(50),
- depart_header_signature_time DATETIME2,
- depart_header_signature_comment NVARCHAR(255),
- depart_leader_signature NVARCHAR(50),
- depart_leader_signature_time DATETIME2,
- depart_leader_signature_comment NVARCHAR(255),
- hf_code NVARCHAR(100),
- 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,
+ [change_order_num] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ [change_status] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [factory_org_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ [designer] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [designer_time] datetime2(7) NULL,
+ [depart_header_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_header_signature_time] datetime2(7) NULL,
+ [depart_header_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_header_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_leader_signature] nvarchar(50) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_leader_signature_time] datetime2(7) NULL,
+ [depart_leader_signature_result] nvarchar(64) COLLATE Chinese_PRC_CI_AS NULL,
+ [depart_leader_comment] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ [hf_code] nvarchar(100) COLLATE Chinese_PRC_CI_AS NULL,
+ [remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS NULL,
+ CONSTRAINT [PK__eam_tech__3213E83F5B1204F4] 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_change,
- null, null;
-EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column', id;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- create_by;
-EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- create_time;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- update_by;
-EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- update_time;
-EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- del_flag;
-EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曞彿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- change_order_num;
-EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍗曠姸鎬�', 'SCHEMA', dbo, 'table', eam_technical_status_change,
- 'column', change_status;
-EXEC sp_addextendedproperty 'MS_Description', '缂栧埗浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- designer;
-EXEC sp_addextendedproperty 'MS_Description', '缂栧埗鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- designer_time;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠＄瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change,
- 'column', depart_header_signature;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠＄瀛楁椂闂�', 'SCHEMA', dbo, 'table',
- eam_technical_status_change, 'column', depart_header_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠℃剰瑙�', 'SCHEMA', dbo, 'table', eam_technical_status_change,
- 'column', depart_header_signature_comment;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change,
- 'column', depart_leader_signature;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛楁椂闂�', 'SCHEMA', dbo, 'table',
- eam_technical_status_change, 'column', depart_leader_signature_time;
-EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛�', 'SCHEMA', dbo, 'table', eam_technical_status_change,
- 'column', depart_leader_signature_comment;
-EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', eam_technical_status_change, 'column',
- hf_code;
+ALTER TABLE [dbo].[eam_technical_status_change]
+ SET (LOCK_ESCALATION = TABLE)
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'涓婚敭',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'id'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'create_by'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒涘缓鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'create_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鏇存柊浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'update_by'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鏇存柊鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'update_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍒犻櫎鏍囪',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'del_flag'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿鍗曞彿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'change_order_num'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鍙樻洿鍗曠姸鎬�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'change_status'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鐢宠鍗曚綅',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'factory_org_code'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'缂栧埗浜�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'designer'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'缂栧埗鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'designer_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_header_signature'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_header_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤绛惧瓧缁撴灉',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_header_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅瀹ょ骇涓荤鎰忚',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_header_comment'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_leader_signature'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧鏃堕棿',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_leader_signature_time'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧缁撴灉',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_leader_signature_result'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'浣跨敤鍗曚綅閮ㄧ骇涓荤绛惧瓧',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'depart_leader_comment'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'HF缂栫爜',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'hf_code'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'澶囨敞',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change',
+ 'COLUMN', N'remark'
+GO
+
+EXEC sp_addextendedproperty
+ 'MS_Description', N'鎶�鏈姸鎬佸彉鏇寸敵璇�',
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'eam_technical_status_change'
--鎶�鏈姸鎬佸彉鏇寸敵璇锋槑缁�
--
Gitblit v1.9.3