/*
 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

