From 3c0a80bda0b0a19e576a56963a719072219579b5 Mon Sep 17 00:00:00 2001 From: zhangherong <571457620@qq.com> Date: 星期四, 10 七月 2025 10:02:27 +0800 Subject: [PATCH] art: 上线SQL整理 --- db/ZHR/dict_zhr.sql | 0 db/ZHR/create_table_zhr.sql | 722 +++++++++++++++++++++++++++++++++++++++++++++++++++++++ db/ZHR/menu_zhr.sql | 0 3 files changed, 722 insertions(+), 0 deletions(-) diff --git a/db/ZHR/create_table_zhr.sql b/db/ZHR/create_table_zhr.sql new file mode 100644 index 0000000..7a2cb5a --- /dev/null +++ b/db/ZHR/create_table_zhr.sql @@ -0,0 +1,722 @@ +-- HF缂栫爜缁存姢 +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_base_hf_code]') + AND type in (N'U')) + DROP TABLE [dbo].[eam_base_hf_code]; +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) +); + +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; + +--鎶�鏈壌瀹氳鑼� +IF EXISTS (SELECT * + FROM sys.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]; +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) +); + +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; + +--鎶�鏈姸鎬侀壌瀹氳鑼冩槑缁� +IF EXISTS (SELECT * + FROM sys.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]; +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) +); + +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; + +--鎶�鏈姸鎬侀壌瀹氬伐鍗� +IF EXISTS (SELECT * + FROM sys.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]; +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) +); + +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; + +--鎶�鏈姸鎬侀壌瀹氬伐鍗曟槑缁� +IF EXISTS (SELECT * + FROM sys.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]; +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) +); + +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; + + +--鎶�鏈姸鎬侀壌瀹氬伐鍗曞彉鏇� +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) +); + +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; + + +--鎶�鏈姸鎬佸彉鏇寸敵璇� +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_change]') + AND type in (N'U')) + 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) +); + +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; + + +--鎶�鏈姸鎬佸彉鏇寸敵璇锋槑缁� +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_change_detail]') + AND type in (N'U')) + DROP TABLE [dbo].[eam_technical_status_change_detail]; +CREATE TABLE [dbo].[eam_technical_status_change_detail] +( + id NVARCHAR(32) NOT NULL, + create_by NVARCHAR(50), + create_time DATETIME2, + update_by NVARCHAR(50), + update_time DATETIME2, + equipment_id NVARCHAR(32), + change_category NVARCHAR(64), + change_date DATETIME2, + change_technical_status NVARCHAR(64), + acceptance_checker NVARCHAR(50), + acceptance_check_time DATETIME2, + acceptance_check_result NVARCHAR(64), + order_id NVARCHAR(32), + PRIMARY KEY (id) +); + +EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬佸彉鏇寸敵璇锋槑缁�', 'SCHEMA', dbo, 'table', + eam_technical_status_change_detail, null, null; +EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', id; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', create_by; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', create_time; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', update_by; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', update_time; +EXEC sp_addextendedproperty 'MS_Description', '璁惧ID', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', equipment_id; +EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍘熷洜;鎼縼銆佸ぇ淇�佹敼閫犮�佸叾浠�', 'SCHEMA', dbo, 'table', + eam_technical_status_change_detail, 'column', change_category; +EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鏃ユ湡', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', change_date; +EXEC sp_addextendedproperty 'MS_Description', '鍙樻洿鍚庢妧鏈姸鎬�;鍙樻洿閫氳繃鍚庨粯璁よ澶囨妧鏈姸鎬佹敼涓虹鐢�', 'SCHEMA', dbo, + 'table', eam_technical_status_change_detail, 'column', change_technical_status; +EXEC sp_addextendedproperty 'MS_Description', '楠屾敹妫�鏌ヤ汉', 'SCHEMA', dbo, 'table', eam_technical_status_change_detail, + 'column', acceptance_checker; +EXEC sp_addextendedproperty 'MS_Description', '楠屾敹妫�鏌ユ椂闂�', 'SCHEMA', dbo, 'table', + eam_technical_status_change_detail, 'column', acceptance_check_time; +EXEC sp_addextendedproperty 'MS_Description', + '楠屾敹妫�鏌ョ粨鏋�;澶т慨銆佹敼閫� 闇�瑕佸～鍐欓獙鏀剁粨鏋滐紝鎼縼鎸夌収鎶�鏈姸鎬侀壌瀹氬伐鍗曠淮鎶わ紝鍏朵粬鏆傛湭浣跨敤鍒帮紝鍙鐣欐绫诲瀷', 'SCHEMA', dbo, + 'table', eam_technical_status_change_detail, 'column', acceptance_check_result; +EXEC sp_addextendedproperty 'MS_Description', '鎶�鏈姸鎬侀壌瀹氬伐鍗旾D;鎼縼浣跨敤', 'SCHEMA', dbo, 'table', + eam_technical_status_change_detail, 'column', order_id; + + +--鍔犲伐璁惧鎶�鏈壌瀹氱敵璇� +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_evaluation_application]') + AND type in (N'U')) + DROP TABLE [dbo].[eam_technical_status_evaluation_application]; +CREATE TABLE [dbo].[eam_technical_status_evaluation_application] +( + id NVARCHAR(32) NOT NULL, + create_by NVARCHAR(50), + create_time DATETIME2, + update_by NVARCHAR(50), + update_time DATETIME2, + del_flag INT, + application_order_num NVARCHAR(100), + applicant NVARCHAR(50), + factory_org_code NVARCHAR(100), + apply_date DATETIME2, + application_status NVARCHAR(64), + depart_header_signature NVARCHAR(50), + depart_header_signature_time DATETIME2, + depart_header_comment NVARCHAR(255), + production_header_signature NVARCHAR(50), + production_header_signature_time DATETIME2, + production_header_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) +); + +EXEC sp_addextendedproperty 'MS_Description', '鍔犲伐璁惧鎶�鏈壌瀹氱敵璇�;绂佺敤鐘舵�佺殑璁惧鎴栦复鏃惰繘琛屾妧鏈壌瀹氭椂浣跨敤', 'SCHEMA', + dbo, 'table', eam_technical_status_evaluation_application, null, null; +EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', id; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', create_by; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', create_time; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', update_by; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', update_time; +EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', del_flag; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鍗曞彿', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', application_order_num; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠浜�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', applicant; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠閮ㄩ棬', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', factory_org_code; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鏃ユ湡', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', apply_date; +EXEC sp_addextendedproperty 'MS_Description', + '鐢宠鍗曠姸鎬�;寰呮彁浜ゃ�佸緟鍗曚綅瀹ょ骇棰嗗瀹℃牳銆佺敓浜ц澶囩鐞嗕富绠″鏍搞�佸緟淇濋殰閮ㄩ瀵煎鏍搞�佸凡浣滃簾銆佸凡瀹屾垚', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', application_status; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鍗曚綅瀹ょ骇棰嗗绛惧瓧', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', depart_header_signature; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鍗曚綅瀹ょ骇棰嗗绛惧瓧鏃堕棿', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', depart_header_signature_time; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鍗曚綅瀹ょ骇棰嗗鎰忚', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', depart_header_comment; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇璁惧绠＄悊涓荤绛惧瓧', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_header_signature; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇璁惧绠＄悊涓荤绛惧瓧鍥涗欢', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_header_signature_time; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇璁惧绠＄悊涓荤鎰忚', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_header_comment; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_support_signature; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵肩瀛楁椂闂�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_support_signature_time; +EXEC sp_addextendedproperty 'MS_Description', '鐢熶骇淇濋殰閮ㄩ瀵兼剰瑙�', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', production_support_comment; +EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', + eam_technical_status_evaluation_application, 'column', hf_code; + +--鍋滅敤鍔犲伐璁惧鐢宠鍗� +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_deactivate]') + AND type in (N'U')) + DROP TABLE [dbo].[eam_technical_status_deactivate]; +CREATE TABLE [dbo].[eam_technical_status_deactivate] +( + id NVARCHAR(32) NOT NULL, + create_by NVARCHAR(50), + create_time DATETIME2, + update_by NVARCHAR(50), + update_time DATETIME2, + del_flag INT, + deactivate_order_num NVARCHAR(100), + applicant NVARCHAR(50), + factory_org_code NVARCHAR(100), + apply_date DATETIME2, + application_status NVARCHAR(64), + 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) +); + +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鍔犲伐璁惧鐢宠鍗�;鐢宠鍗曚綅鐢宠鍋滅敤璁惧锛屽鎵归�氳繃鍚庝慨鏀硅澶囩姸鎬佷负绂佺敤', + 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, null, null; +EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, 'column', + id; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', create_by; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', create_time; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', update_by; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', update_time; +EXEC sp_addextendedproperty 'MS_Description', '鍒犻櫎鏍囪', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', del_flag; +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鍗曞彿', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', deactivate_order_num; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠浜�', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', applicant; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠閮ㄩ棬', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', factory_org_code; +EXEC sp_addextendedproperty 'MS_Description', '鐢宠鏃ユ湡', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', apply_date; +EXEC sp_addextendedproperty 'MS_Description', + '鐢宠鍗曠姸鎬�;寰呮彁浜ゃ�佸緟鍗曚綅瀹ょ骇棰嗗瀹℃牳銆佺敓浜ц澶囩鐞嗕富绠″鏍搞�佸緟淇濋殰閮ㄩ瀵煎鏍搞�佸凡浣滃簾銆佸凡瀹屾垚', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', application_status; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠＄瀛�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_header_signature; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠＄瀛楁椂闂�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_header_signature_time; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅瀹や富绠℃剰瑙�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_header_signature_comment; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_leader_signature; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛楁椂闂�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_leader_signature_time; +EXEC sp_addextendedproperty 'MS_Description', '浣跨敤鍗曚綅閮ㄤ富绠＄瀛�', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate, 'column', depart_leader_signature_comment; +EXEC sp_addextendedproperty 'MS_Description', 'HF缂栫爜', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate, + 'column', hf_code; + + +--鍋滅敤鍔犲伐璁惧鏄庣粏 +IF EXISTS (SELECT * + FROM sys.objects + WHERE object_id = OBJECT_ID(N'[dbo].[eam_technical_status_deactivate_detail]') + AND type in (N'U')) + DROP TABLE [dbo].[eam_technical_status_deactivate_detail]; +CREATE TABLE [dbo].[eam_technical_status_deactivate_detail] +( + id NVARCHAR(32) NOT NULL, + create_by NVARCHAR(50), + create_time DATETIME2, + update_by NVARCHAR(50), + update_time DATETIME2, + equipment_id NVARCHAR(32), + deactivate_reason NVARCHAR(255), + deactivate_duration NUMERIC(24, 4), + deactivate_duration_unit NVARCHAR(64), + PRIMARY KEY (id) +); + +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鍔犲伐璁惧鏄庣粏', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, null, null; +EXEC sp_addextendedproperty 'MS_Description', '涓婚敭', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, + 'column', id; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓浜�', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, + 'column', create_by; +EXEC sp_addextendedproperty 'MS_Description', '鍒涘缓鏃堕棿', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, 'column', create_time; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊浜�', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, + 'column', update_by; +EXEC sp_addextendedproperty 'MS_Description', '鏇存柊鏃堕棿', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, 'column', update_time; +EXEC sp_addextendedproperty 'MS_Description', '璁惧ID', 'SCHEMA', dbo, 'table', eam_technical_status_deactivate_detail, + 'column', equipment_id; +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鍘熷洜', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, 'column', deactivate_reason; +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鏃堕暱', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, 'column', deactivate_duration; +EXEC sp_addextendedproperty 'MS_Description', '鍋滅敤鏃堕暱鍗曚綅;澶┿�佹湀銆佸勾', 'SCHEMA', dbo, 'table', + eam_technical_status_deactivate_detail, 'column', deactivate_duration_unit; diff --git a/db/ZHR/dict_zhr.sql b/db/ZHR/dict_zhr.sql new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/db/ZHR/dict_zhr.sql diff --git a/db/ZHR/menu_zhr.sql b/db/ZHR/menu_zhr.sql new file mode 100644 index 0000000..e69de29 --- /dev/null +++ b/db/ZHR/menu_zhr.sql -- Gitblit v1.9.3