1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| 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
| );
|
|
