Tables [dbo].[SHExportModulePSNDataTranslationLists]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:42 AM Thursday, March 21, 2019
Last Modified1:15:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_SHExportModulePSNDataTranslationLists_compound: DataItemID\PSNVendorID\ListIndexForeign Keys FK_SHExportModulePSNDataTranslationLists_DataItemID_SHExportModulePSNDataTranslationItems: [dbo].[SHExportModulePSNDataTranslationItems].DataItemID\PSNVendorIDDataItemIDint4
False
Cluster Primary Key PK_SHExportModulePSNDataTranslationLists_compound: DataItemID\PSNVendorID\ListIndexForeign Keys FK_SHExportModulePSNDataTranslationLists_DataItemID_SHExportModulePSNDataTranslationItems: [dbo].[SHExportModulePSNDataTranslationItems].DataItemID\PSNVendorIDPSNVendorIDint4
False
Cluster Primary Key PK_SHExportModulePSNDataTranslationLists_compound: DataItemID\PSNVendorID\ListIndexListIndexint4
False
ListNamevarchar(15)15
False
ListDescriptionvarchar(63)63
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SHExportModulePSNDataTranslationLists_compound: DataItemID\PSNVendorID\ListIndexPK_SHExportModulePSNDataTranslationLists_compoundDataItemID, PSNVendorID, ListIndex
True
NameColumns
FK_SHExportModulePSNDataTranslationLists_DataItemID_SHExportModulePSNDataTranslationItemsDataItemID->[dbo].[SHExportModulePSNDataTranslationItems].[DataItemID]
PSNVendorID->[dbo].[SHExportModulePSNDataTranslationItems].[PSNVendorID]
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