/*
|
Navicat Premium Data Transfer
|
|
Source Server : sqlser
|
Source Server Type : SQL Server
|
Source Server Version : 13001601 (13.00.1601)
|
Source Host : 30036q420j.yicp.fun:11047
|
Source Catalog : LXZN_TEST_430
|
Source Schema : dbo
|
|
Target Server Type : SQL Server
|
Target Server Version : 13001601 (13.00.1601)
|
File Encoding : 65001
|
|
Date: 13/11/2023 13:48:04
|
*/
|
|
|
-- ----------------------------
|
-- Table structure for mom_eam_fault_info
|
-- ----------------------------
|
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[mom_eam_fault_info]') AND type IN ('U'))
|
DROP TABLE [dbo].[mom_eam_fault_info]
|
GO
|
|
CREATE TABLE [dbo].[mom_eam_fault_info] (
|
[id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL,
|
[num] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[q_id] int NULL,
|
[cost] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[is_certificate] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[is_outage] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[factor] text COLLATE Chinese_PRC_CI_AS NULL,
|
[modify_content] text COLLATE Chinese_PRC_CI_AS NULL,
|
[equipment_process] text COLLATE Chinese_PRC_CI_AS NULL,
|
[phenomenon] text COLLATE Chinese_PRC_CI_AS NULL,
|
[method1] text COLLATE Chinese_PRC_CI_AS NULL,
|
[method2] text COLLATE Chinese_PRC_CI_AS NULL,
|
[method3] text COLLATE Chinese_PRC_CI_AS NULL,
|
[result] text COLLATE Chinese_PRC_CI_AS NULL,
|
[start_check_time] datetime2(7) NULL,
|
[equipment_status] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[anlysis] text COLLATE Chinese_PRC_CI_AS NULL,
|
[check_result] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[active] text COLLATE Chinese_PRC_CI_AS NULL,
|
[suggest] text COLLATE Chinese_PRC_CI_AS NULL,
|
[judgment] text COLLATE Chinese_PRC_CI_AS NULL,
|
[different_judgment] text COLLATE Chinese_PRC_CI_AS NULL,
|
[update_method] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[final_result] text COLLATE Chinese_PRC_CI_AS NULL,
|
[operater] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[engineer] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[mechanic] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[work_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[center_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[team_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[repair_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[equip_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[guarantee_leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[e_name] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[e_model] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[e_num] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
|
)
|
GO
|
|
ALTER TABLE [dbo].[mom_eam_fault_info] SET (LOCK_ESCALATION = TABLE)
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'主键ID',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'id'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'编码',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'num'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'质量隐患确认单ID',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'q_id'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'维修费用',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'cost'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'操作员是否有操作证',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'is_certificate'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'是否断电重启',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'is_outage'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'加工过程中的变动因素',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'factor'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'具体更改内容',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'modify_content'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'发生事故时设备所执行的程序',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'equipment_process'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'发生事故时的现象',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'phenomenon'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'采取措施1',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'method1'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'采取措施2',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'method2'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'采取措施3',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'method3'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'事故所造成的结果',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'result'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'开始检查时间',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'start_check_time'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'发生事故后设备的状态',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'equipment_status'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'维修人员对事故的分析',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'anlysis'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'维修人员检查结果',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'check_result'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'事故原因分析过程中所采取的相关行为',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'active'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'建议采取的措施及时间节点',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'suggest'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'事故发生原因分析的核对',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'judgment'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'不同的意见及分析',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'different_judgment'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'整改措施',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'update_method'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'事故结论',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'final_result'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'操作者',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'operater'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'维修责任人',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'engineer'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'技术负责人',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'mechanic'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'工长',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'work_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'中心主任',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'center_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'组长',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'team_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'维修站站长',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'repair_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'管理室业务经理',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'equip_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'运行保障部主管领导',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'guarantee_leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'设备名称',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'e_name'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'设备型号',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'e_model'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'设备编码',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_fault_info',
|
'COLUMN', N'e_num'
|
GO
|
|
|
-- ----------------------------
|
-- Primary Key structure for table mom_eam_fault_info
|
-- ----------------------------
|
ALTER TABLE [dbo].[mom_eam_fault_info] ADD CONSTRAINT [PK__mom_eam___3213E83FB193087F] 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
|
