Merge remote-tracking branch 'origin/master'
¶Ô±ÈÐÂÎļþ |
| | |
| | | -- 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ï¼V2+', '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', 'ææ¯ç¶æé´å®å·¥åID;æ¬è¿ä½¿ç¨', '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; |