C11/System/ARI/SQL/schema/GC_DWH_ARI/tables/Modellgruppe.sql

CREATE TABLE [dbo].[Modellgruppe] (
   [Client_DB] [varchar](20) NOT NULL,
   [VIN] [varchar](20) NOT NULL,
   [Model No_] [varchar](30) NULL,
   [Make Code] [varchar](20) NOT NULL,
   [Model] [varchar](50) NULL,
   [Model_Group_Code] [varchar](20) NULL,
   [Fabrikat] [varchar](100) NOT NULL,
   [Fabrikat_Sortierung] [varchar](10) NULL,
   [Modellgruppe_1] [varchar](50) NULL,
   [Modellgruppe_1_Sortierung] [varchar](5) NULL,
   [Modellgruppe_2] [varchar](73) NULL,
   [Modellgruppe_2_Sortierung] [varchar](50) NULL

   ,CONSTRAINT [PK_Modellgruppe] PRIMARY KEY CLUSTERED ([Client_DB], [VIN])
)


GO