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 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
|
CREATE TABLE [dbo].[T_TOTO](
[TEST_ID] [bigint] IDENTITY(1,1) NOT NULL,
[TEST_BOI_REF] [varchar](10) NOT NULL,
[TEST_TIMESTAMP] [datetime] NOT NULL,
[SEV_ID] [int] NOT NULL,
[TEST_FILE_NAME] [varchar](255) NOT NULL,
[TEST_CODE_EVENT] [varchar](10) NOT NULL,
[TEST_DATA] [text] NOT NULL,
[TEST_DATE_CREA] [datetime] NOT NULL,
[TEST_DATE_MODIF] [datetime] NOT NULL,
[TEST_PREV_BAT_ID] [varchar](10) NOT NULL,
[TEST_CURR_BAT_ID] [varchar](10) NOT NULL,
[TEST_BAT_VOLT] [int] NOT NULL,
[TEST_BAT_COUNT] [int] NOT NULL,
[TEST_MANUF_DATE] [datetime] NOT NULL,
[TEST_DEVICE_TEMP] [decimal](9, 2) NOT NULL,
[TEST_DEVICE_FIRM] [varchar](10) NOT NULL,
[TEST_MILEAGE_STATUT] [varchar](1) NOT NULL,
[TEST_MILEAGE_CELLID_FREQ] [int] NOT NULL,
[TEST_MILEAGE_BUFF_PACK_MULT] [int] NOT NULL,
[TEST_BFR_SLEEP] [varchar](1) NOT NULL,
[TEST_BFR_SLEEP_WAIT_TIME] [int] NOT NULL,
[TEST_ARBIT_STATUT] [varchar](1) NOT NULL,
[TEST_ARBIT_FREQ] [int] NOT NULL,
[TEST_ZONE_STATUT] [varchar](1) NOT NULL,
[TEST_ZONE_CELLID_FREQ] [int] NOT NULL,
[TEST_HIGH_GFORCE_STATUT] [varchar](1) NOT NULL,
[TEST_HIGH_GFORCE_X] [int] NOT NULL,
[TEST_HIGH_GFORCE_Y] [int] NOT NULL,
[TEST_HIGH_GFORCE_Z] [int] NOT NULL,
[TEST_LOW_GFORCE_STATUT] [varchar](1) NOT NULL,
[TEST_LOW_GFORCE_X] [int] NOT NULL,
[TEST_LOW_GFORCE_Y] [int] NOT NULL,
[TEST_LOW_GFORCE_Z] [int] NOT NULL,
[TEST_REAL_TIME_STATUT] [varchar](1) NOT NULL,
[TEST_REAL_TIME_FREQ_UNIT] [varchar](1) NOT NULL,
[TEST_REAL_TIME_FREQ] [int] NOT NULL,
[TEST_REAL_TIME_COUNT] [int] NOT NULL,
[TEST_REAL_TIME_RTESTRD_STATUT] [varchar](1) NOT NULL,
[COS_ID] [int] NOT NULL,
CONSTRAINT [PK_T_TEST_CONFIG_TEST] PRIMARY KEY CLUSTERED
(
[TEST_ID] ASC
) |
Partager