C11/System/OPTIMA/SQL/schema/OPTIMA/tables/import.CALENDAR_PATTERN.sql

CREATE TABLE [import].[CALENDAR_PATTERN] (
   [CALENDAR_INFO_ID] [numeric](12,0) NOT NULL,
   [CALENDAR_TYPE_ID] [smallint] NOT NULL,
   [RECURRING_PATTERN_ID] [varchar](10) NOT NULL,
   [RECURRING_PATTERN_PRIORITY] [smallint] NOT NULL,
   [TRANSACT_DATE] [datetime] NOT NULL,
   [HANDLER] [char](4) NOT NULL,
   [PROGRAM] [char](6) NOT NULL,
   [FUNCTION_CODE] [char](4) NOT NULL,
   [timestamp] [binary](8) NOT NULL,
   [CONV_FLAG] [char](1) NULL,
   [UNIQUE_ID] [int] NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_CALENDAR_PATTERNUNIQUE_ID] PRIMARY KEY CLUSTERED ([UNIQUE_ID], [CLIENT_DB])
)


GO