CREATE TABLE [optima].[ECC_Status] (
   [CLIENT_DB] [varchar](20) NOT NULL,
   [ECC_STATUS] [varchar](10) NOT NULL,
   [SPECIFY] [varchar](50) NOT NULL,
   [Bereich] [varchar](10) NULL,
   [Auftragsstatus] [varchar](20) NULL,
   [Fahrzeugstatus] [varchar](100) NOT NULL,
   [timestamp] [timestamp] NULL

   ,CONSTRAINT [PK_ECC_Status] PRIMARY KEY CLUSTERED ([CLIENT_DB], [ECC_STATUS])
)


GO