CREATE TABLE [dbo].[SpotCheck] (
    [ID] INT IDENTITY (1, 1) NOT NULL,
    [BeginTime] DATETIME NULL,
	TotalQty INT NULL,
	FinishedQty INT NULL,
	PickCount INT NULL,
	LastBreakProductQty INT NULL,
	LastProductQty INT NULL
);


CREATE TABLE [dbo].[SpotCheckDetail] (
    [ID] INT IDENTITY (1, 1) NOT NULL,
    [PickTime] DATETIME NULL,
    [ProductNo] varchar(50) NULL,
	[ProductHeight]       FLOAT (53)    NULL,
    [ProductLength]       FLOAT (53)    NULL,
    [ProductWidth]        FLOAT (53)    NULL,
	[Type] NVARCHAR(10) NULL
);