1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| CREATE TABLE [dbo].[Production] (
[SERIALNUMBER] CHAR (17) NULL,
[PARTNUMBER] CHAR (12) NULL,
[DATE] DATETIME NULL,
[HEURE] DATETIME NULL,
[TEST_STATION] CHAR (50) NULL,
[TEST_SOFTWARE_VERSION] CHAR (16) NULL,
[DATABASE_VERSION] CHAR (3) NULL,
[SERIALNUMBER_CI] CHAR (17) NULL,
[SOFTWARE_VERSION] CHAR (40) NULL,
[OPERATOR] CHAR (16) NULL,
[DIE_NUMBER] CHAR (16) NULL,
[OF_NUMBER] CHAR (12) NULL,
[OPTION1] NVARCHAR (50) NULL,
[OPTION2] NVARCHAR (50) NULL,
[OPTION3] NVARCHAR (50) NULL,
[OPTION4] NVARCHAR (50) NULL,
[OPTION5] NVARCHAR (50) NULL,
[OPTION6] NVARCHAR (50) NULL,
[OPTION7] NVARCHAR (50) NULL,
[OPTION8] NVARCHAR (50) NULL,
[OPTION9] NVARCHAR (50) NULL,
[OPTION10] NVARCHAR (50) NULL,
[MAC_ADDRESS1] CHAR (12) NULL,
[MAC_ADDRESS2] CHAR (12) NULL,
[AUTOID] INT IDENTITY (1, 1) NOT NULL,
[DATABASE] NVARCHAR (200) NULL
); |
Partager