C11/System/OPTIMA/SQL/schema/GC/tables/data.GC_Activity_Codes.sql

CREATE TABLE [data].[GC_Activity_Codes] (
   [Client_DB] [varchar](20) NOT NULL,
   [Activity_Code] [varchar](20) NOT NULL,
   [Activity_Desc] [varchar](50) NOT NULL,
   [Activity_Category] [varchar](20) NOT NULL,
   [Present] [int] NOT NULL,
   [Zeitkategorie_1] [varchar](50) NULL,
   [Zeitkategorie_2] [varchar](50) NULL,
   [Fabrikat] [varchar](50) NULL

   ,CONSTRAINT [PK_GC_Activity_Codes] PRIMARY KEY CLUSTERED ([Client_DB], [Activity_Code])
)


GO