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