CREATE TABLE [data].[GC_Mitarbeiter] (
   [Client_DB] [varchar](20) NOT NULL,
   [Employee_ID] [varchar](50) NOT NULL,
   [Name] [varchar](100) NOT NULL,
   [Department] [varchar](50) NOT NULL,
   [Zuordnung_Funktion] [varchar](50) NULL,
   [Zuordnung_Mechanic_Group_1] [varchar](50) NULL,
   [Zuordnung_Mechanic_Group_2] [varchar](50) NULL,
   [Zuordnung_Mechanic_Productive] [varchar](20) NULL,
   [Zuordnung_Department_Name] [varchar](50) NULL

   ,CONSTRAINT [PK_GC_Mitarbeiter] PRIMARY KEY CLUSTERED ([Client_DB], [Employee_ID])
)


GO