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 | 552 +++++++++++++++++++++++++++++++++++++++++-------------
1 files changed, 419 insertions(+), 133 deletions(-)
diff --git a/db/ZHR/create_table_zhr.sql b/db/ZHR/create_table_zhr.sql
index a791fce..dae5b33 100644
--- a/db/ZHR/create_table_zhr.sql
+++ b/db/ZHR/create_table_zhr.sql
@@ -1049,89 +1049,247 @@
--鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇�
-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 *
@@ -1141,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