C11/System/ARI/SQL/schema/GC_CONFIG/tables/ari.Mitarbeiter.sql

CREATE TABLE [ari].[Mitarbeiter] (
   [Client_DB] [varchar](20) NOT NULL,
   [Employee No_] [varchar](20) NOT NULL,
   [Name] [varchar](100) NULL,
   [First Name] [varchar](100) NULL,
   [Last Name] [varchar](100) NULL,
   [Employment Date] [varchar](20) NULL,
   [Leaving Date] [varchar](20) NULL,
   [Task Type Group] [varchar](20) NULL,
   [Function Code] [varchar](20) NULL,
   [Group No_ 1] [varchar](20) NULL,
   [Group No_ 2] [varchar](20) NULL,
   [Group No_ 3] [varchar](20) NULL,
   [aktiv] [int] NULL,
   [Erstellungsdatum] [datetime] NULL,
   [Monteur_Gruppe] [varchar](50) NULL,
   [Monteur_Gruppe_2] [varchar](50) NULL

   ,CONSTRAINT [PK_Mitarbeiter] PRIMARY KEY CLUSTERED ([Client_DB], [Employee No_])
)


GO