CREATE TABLE dbo.TEST_DATA (
  ID decimal(10,0)  IDENTITY(1,1) NOT NULL,
  TIMESTAMP datetime NULL default getdate(),
  DATE_TIME_STAMP datetime NULL default getdate(),
  DATA_SOURCE_NAME nvarchar(64) NULL,
  DEVICE_ID nvarchar(128) NULL,
  PATIENT_SEQ_NUM nvarchar(32) NULL,
  PATIENT_ID nvarchar(32) NULL,
  PATIENT_NAME nvarchar(128) NULL,
  PATIENT_NAME_LAST nvarchar(128) NULL,
  PATIENT_NAME_MIDDLE nvarchar(128) NULL,
  PATIENT_NAME_FIRST nvarchar(128) NULL,
  PATIENT_NAME_SEX nvarchar(12) NULL,
  PATIENT_ADDRESS nvarchar(128) NULL,
  PATIENT_PHONE nvarchar(128) NULL,
  PATIENT_RACE nvarchar(32) NULL,
  RESULT_SEQ_NUM nvarchar(12) NULL,
  RESULT_TEST_ID nvarchar(32) NULL,
  RESULT_TEST_ID1 nvarchar(32) NULL,
  RESULT_TEST_ID2 nvarchar(32) NULL,
  RESULT_TEST_ID3 nvarchar(32) NULL,
  RESULT_TEST_ID4 nvarchar(32) NULL,
  RESULT_VALUE nvarchar(32) NULL,
  RESULT_UNIT nvarchar(32) NULL,
  RESULT_ABNORMAL nvarchar(32) NULL,
  RESULT_STATUS nvarchar(32) NULL,
  RESULT_OPERATOR_ID nvarchar(32) NULL,
  CONSTRAINT [PK_TEST_DATA] PRIMARY KEY
  (
     [ID] ASC
  )WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

/**** split line *****/GO 
CREATE INDEX [TEST_DATA_DEVICE_ID_IDX] ON TEST_DATA ([DEVICE_ID]);

/**** split line *****/GO 
CREATE INDEX [TEST_DATA_TIMESTAMP_IDX] ON TEST_DATA ([TIMESTAMP]);
