USE [RF_Production_DM_DEV]
GO

/****** Object:  Table [dbo].[MP_Keyence2_Data]    Script Date: 13.03.2023 12:21:41 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MP_Keyence2_Data](
	[UUID] [uniqueidentifier] NULL,
	[Time] [datetime] NULL,
	[SN_Equipment] [nvarchar](50) NULL,
	[Value] [float] NULL,
	[Unit] [nvarchar](50) NULL,
	[Name] [nvarchar](50) NULL,
	[LSL] [float] NULL,
	[Target] [float] NULL,
	[USL] [float] NULL,
	[Result] [nvarchar](50) NULL,
	[MMC] [bit] NULL
) ON [PRIMARY]
GO





USE [RF_Production_DM_DEV]
GO

/****** Object:  Table [dbo].[MP_Keyence2_Header]    Script Date: 13.03.2023 12:21:53 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MP_Keyence2_Header](
	[UUID] [uniqueidentifier] NOT NULL,
	[Time] [datetime] NOT NULL,
	[Program] [nvarchar](150) NOT NULL,
	[PANr] [nvarchar](50) NULL,
	[Counter] [nvarchar](50) NULL,
	[Operator] [nvarchar](50) NULL,
	[PASS] [nvarchar](50) NULL,
	[SN_Equipment] [nvarchar](50) NULL,
	[Software_Version] [nvarchar](50) NULL,
	[SN] [nvarchar](50) NULL,
	[Charge] [nvarchar](50) NULL,
	[Label_1] [nvarchar](150) NULL,
	[Label_2] [nvarchar](150) NULL,
	[Inactive] [bit] NULL,
	[AD_1_Value] [nvarchar](50) NULL,
	[AD_1_Name] [nvarchar](50) NULL,
	[AD_2_Value] [nvarchar](50) NULL,
	[AD_2_Name] [nvarchar](50) NULL,
	[AD_3_Value] [nvarchar](50) NULL,
	[AD_3_Name] [nvarchar](50) NULL,
	[AD_4_Value] [nvarchar](50) NULL,
	[AD_4_Name] [nvarchar](50) NULL,
 CONSTRAINT [PK_UUID] PRIMARY KEY CLUSTERED 
(
	[UUID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO





USE [RF_Production_DM_DEV]
GO

/****** Object:  Table [dbo].[MP_Keyence2_SPC_Limits]    Script Date: 13.03.2023 12:22:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MP_Keyence2_SPC_Limits](
	[Program] [nvarchar](50) NOT NULL,
	[Name] [nvarchar](50) NOT NULL,
	[Sample_Size] [int] NULL,
	[LCL] [float] NULL,
	[UCL] [float] NULL
) ON [PRIMARY]
GO



USE [RF_Production_DM_DEV]
GO

/****** Object:  Table [dbo].[MP_Keyence2_Hide_Column]    Script Date: 13.03.2023 12:22:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[MP_Keyence2_Hide_Column](
	[Program] [nvarchar](50) NOT NULL,
	[Column_Name] [nvarchar](50) NOT NULL
) ON [PRIMARY]
GO