/*
|
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:47:13
|
*/
|
|
|
-- ----------------------------
|
-- Table structure for mom_eam_quanlity_confirm
|
-- ----------------------------
|
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[mom_eam_quanlity_confirm]') AND type IN ('U'))
|
DROP TABLE [dbo].[mom_eam_quanlity_confirm]
|
GO
|
|
CREATE TABLE [dbo].[mom_eam_quanlity_confirm] (
|
[id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NOT NULL,
|
[num] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[report_id] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[condition] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[condition_analysis] text COLLATE Chinese_PRC_CI_AS NULL,
|
[part_number] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[batch_no] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[quantity] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[operator] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[create_time] datetime NULL,
|
[leader] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL,
|
[confirm_time] datetime NULL,
|
[is_confirm] nvarchar(32) COLLATE Chinese_PRC_CI_AS NULL
|
)
|
GO
|
|
ALTER TABLE [dbo].[mom_eam_quanlity_confirm] SET (LOCK_ESCALATION = TABLE)
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'主键ID',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'id'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'编码',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'num'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'故障报修单ID',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'report_id'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'产品损失情况',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'condition'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'损失情况分析',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'condition_analysis'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'零件号',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'part_number'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'批次号',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'batch_no'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'件数',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'quantity'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'操作员',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'operator'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'创建时间',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'create_time'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'确认领导',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'leader'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'领导确认时间',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'confirm_time'
|
GO
|
|
EXEC sp_addextendedproperty
|
'MS_Description', N'是否已确认',
|
'SCHEMA', N'dbo',
|
'TABLE', N'mom_eam_quanlity_confirm',
|
'COLUMN', N'is_confirm'
|
GO
|
|
|
-- ----------------------------
|
-- Primary Key structure for table mom_eam_quanlity_confirm
|
-- ----------------------------
|
ALTER TABLE [dbo].[mom_eam_quanlity_confirm] ADD CONSTRAINT [PK__mom_eam___3213E83FCD6C813D] 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
|
