1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[eam_third_maintenance_work_plan_sheet]') AND type in (N'U')) DROP TABLE [dbo].[eam_third_maintenance_work_plan_sheet];
| CREATE TABLE [dbo].[eam_third_maintenance_work_plan_sheet](
| id NVARCHAR(32) NOT NULL,
| create_by NVARCHAR(50),
| create_time DATETIME2,
| update_by NVARCHAR(50),
| update_time DATETIME2,
| del_flag INT,
| equipment_code NVARCHAR(255),
| equipment_name NVARCHAR(255),
| factory_org_code NVARCHAR(255),
| equipment_model NVARCHAR(255),
| maintenance_date DATETIME2,
| hf_code NVARCHAR(255),
| PRIMARY KEY (id)
| );
|
| EXEC sp_addextendedproperty 'MS_Description', '三级保养工作计划单', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, null, null;
| EXEC sp_addextendedproperty 'MS_Description', '主键', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', id;
| EXEC sp_addextendedproperty 'MS_Description', '创建人', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', create_by;
| EXEC sp_addextendedproperty 'MS_Description', '创建时间', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', create_time;
| EXEC sp_addextendedproperty 'MS_Description', '更新人', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', update_by;
| EXEC sp_addextendedproperty 'MS_Description', '更新时间', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', update_time;
| EXEC sp_addextendedproperty 'MS_Description', '删除标记', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', del_flag;
| EXEC sp_addextendedproperty 'MS_Description', '设备统一编号', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_code;
| EXEC sp_addextendedproperty 'MS_Description', '设备名称', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_name;
| EXEC sp_addextendedproperty 'MS_Description', '使用部门', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', factory_org_code;
| EXEC sp_addextendedproperty 'MS_Description', '设备型号', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', equipment_model;
| EXEC sp_addextendedproperty 'MS_Description', '保养日期', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', maintenance_date;
| EXEC sp_addextendedproperty 'MS_Description', 'hf编码', 'SCHEMA', dbo, 'table', eam_third_maintenance_work_plan_sheet, 'column', hf_code;
|
|
|
| INSERT INTO [sys_dict_item]([id], [dict_id], [item_text], [item_value], [description], [sort_order], [status], [create_by], [create_time], [update_by], [update_time]) VALUES (N'1962764933997375489', N'1941372067586695170', N'三级保养工作计划单', N'THIRD_MAINTENANCE_WORK_PLAN_SHEET', N'', 18, 1, N'admin', '2025-09-02 14:30:01.0000000', N'admin', '2025-09-02 14:36:28.3440000'); GO
|
|
