CREATE TABLE [dbo].[SHExportModulePSNDataTranslationLists]
(
[DataItemID] [int] NOT NULL,
[PSNVendorID] [int] NOT NULL,
[ListIndex] [int] NOT NULL,
[ListName] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ListDescription] [varchar] (63) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslationLists] ADD CONSTRAINT [PK_SHExportModulePSNDataTranslationLists_compound] PRIMARY KEY CLUSTERED ([DataItemID], [PSNVendorID], [ListIndex]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslationLists] ADD CONSTRAINT [FK_SHExportModulePSNDataTranslationLists_DataItemID_SHExportModulePSNDataTranslationItems] FOREIGN KEY ([DataItemID], [PSNVendorID]) REFERENCES [dbo].[SHExportModulePSNDataTranslationItems] ([DataItemID], [PSNVendorID])
GO