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

CREATE TABLE [import].[VPP74] (
   [WORKSHOP_MODEL] [varchar](20) NOT NULL,
   [MAKE_CD] [varchar](2) NULL,
   [STATE_CODE_PARAM] [varchar](10) NOT NULL,
   [TRANSACT_DATE] [datetime] NULL,
   [HANDLER] [varchar](30) NOT NULL,
   [MODEL_TEXT] [varchar](50) NOT NULL,
   [ORIG_MODEL_CODE] [varchar](45) NOT NULL,
   [CLAIM_TYPE] [varchar](20) NOT NULL,
   [PRODUCT_LINE] [varchar](20) NOT NULL,
   [MNEMONIC_1] [varchar](6) NOT NULL,
   [MNEMONIC_2] [varchar](6) NOT NULL,
   [MODEL_TYPE] [varchar](1) NOT NULL,
   [MODEL_GROUP] [varchar](2) NOT NULL,
   [FACTORY_CLAIM_CODE] [int] NULL,
   [MODEL_LINE_OSP] [varchar](3) NOT NULL,
   [CALL_FOR_SERVICE] [int] NULL,
   [FOLLOW_UP_CODE_1] [varchar](2) NOT NULL,
   [FOLLOW_UP_CODE_2] [varchar](2) NOT NULL,
   [FOLLOW_UP_CODE_3] [varchar](2) NOT NULL,
   [FOLLOW_UP_CODE_4] [varchar](2) NOT NULL,
   [FOLLOW_UP_CODE_5] [varchar](2) NOT NULL,
   [MAKE_CODE] [varchar](10) NOT NULL,
   [CARDFILE_PAGE] [numeric](2,0) NULL,
   [timestamp] [binary](8) NOT NULL,
   [UNIQUE_IDENT] [bigint] NOT NULL,
   [CLIENT_DB] [varchar](20) NOT NULL

   ,CONSTRAINT [PK_VPP74_1] PRIMARY KEY CLUSTERED ([WORKSHOP_MODEL], [UNIQUE_IDENT], [CLIENT_DB])
)


GO