optima.ECC_Status.sql 392 B

1234567891011121314
  1. CREATE TABLE [optima].[ECC_Status] (
  2. [CLIENT_DB] [varchar](20) NOT NULL,
  3. [ECC_STATUS] [varchar](10) NOT NULL,
  4. [SPECIFY] [varchar](50) NOT NULL,
  5. [Bereich] [varchar](10) NULL,
  6. [Auftragsstatus] [varchar](20) NULL,
  7. [Fahrzeugstatus] [varchar](100) NOT NULL,
  8. [timestamp] [timestamp] NULL
  9. ,CONSTRAINT [PK_ECC_Status] PRIMARY KEY CLUSTERED ([CLIENT_DB], [ECC_STATUS])
  10. )
  11. GO