Tables [dbo].[SHExportModulePSNDataTranslations]
PropertyValue
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 NullsIdentity
Cluster Primary Key PK_SHExportModulePSNDataTranslations_id: ididint4
False
1 - 1
Foreign Keys FK_SHExportModulePSNDataTranslations_DataItemID_SHExportModulePSNDataTranslationItems: [dbo].[SHExportModulePSNDataTranslationItems].DataItemID\PSNVendorIDForeign Keys FK_SHExportModulePSNDataTranslations_DataMapList_SHExportModulePSNDataTranslationLists: [dbo].[SHExportModulePSNDataTranslationLists].DataItemID\PSNVendorID\ListIndexDataItemIDint4
False
Foreign Keys FK_SHExportModulePSNDataTranslations_DataItemID_SHExportModulePSNDataTranslationItems: [dbo].[SHExportModulePSNDataTranslationItems].DataItemID\PSNVendorIDForeign Keys FK_SHExportModulePSNDataTranslations_DataMapList_SHExportModulePSNDataTranslationLists: [dbo].[SHExportModulePSNDataTranslationLists].DataItemID\PSNVendorID\ListIndexForeign Keys FK_SKExportModulePSNDataranslations_PSNVendorID_SHExportModulePSNVendors: [dbo].[SHExportModulePSNVendors].PSNVendorIDPSNVendorIDint4
False
Foreign Keys FK_SHExportModulePSNDataTranslations_DataMapList_SHExportModulePSNDataTranslationLists: [dbo].[SHExportModulePSNDataTranslationLists].DataItemID\PSNVendorID\ListIndexListIndexint4
False
eautomateIDint4
False
KeyNameKey ColumnsUnique
Cluster Primary Key PK_SHExportModulePSNDataTranslations_id: idPK_SHExportModulePSNDataTranslations_idid
True
NameColumns
FK_SHExportModulePSNDataTranslations_DataItemID_SHExportModulePSNDataTranslationItemsDataItemID->[dbo].[SHExportModulePSNDataTranslationItems].[DataItemID]
PSNVendorID->[dbo].[SHExportModulePSNDataTranslationItems].[PSNVendorID]
FK_SHExportModulePSNDataTranslations_DataMapList_SHExportModulePSNDataTranslationListsDataItemID->[dbo].[SHExportModulePSNDataTranslationLists].[DataItemID]
PSNVendorID->[dbo].[SHExportModulePSNDataTranslationLists].[PSNVendorID]
ListIndex->[dbo].[SHExportModulePSNDataTranslationLists].[ListIndex]
FK_SKExportModulePSNDataranslations_PSNVendorID_SHExportModulePSNVendorsPSNVendorID->[dbo].[SHExportModulePSNVendors].[VendorID]
CREATE TABLE [dbo].[SHExportModulePSNDataTranslations]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[DataItemID] [int] NOT NULL,
[PSNVendorID] [int] NOT NULL,
[ListIndex] [int] NOT NULL,
[eautomateID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslations] ADD CONSTRAINT [PK_SHExportModulePSNDataTranslations_id] PRIMARY KEY CLUSTERED  ([id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslations] ADD CONSTRAINT [FK_SHExportModulePSNDataTranslations_DataItemID_SHExportModulePSNDataTranslationItems] FOREIGN KEY ([DataItemID], [PSNVendorID]) REFERENCES [dbo].[SHExportModulePSNDataTranslationItems] ([DataItemID], [PSNVendorID])
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslations] ADD CONSTRAINT [FK_SHExportModulePSNDataTranslations_DataMapList_SHExportModulePSNDataTranslationLists] FOREIGN KEY ([DataItemID], [PSNVendorID], [ListIndex]) REFERENCES [dbo].[SHExportModulePSNDataTranslationLists] ([DataItemID], [PSNVendorID], [ListIndex])
GO
ALTER TABLE [dbo].[SHExportModulePSNDataTranslations] ADD CONSTRAINT [FK_SKExportModulePSNDataranslations_PSNVendorID_SHExportModulePSNVendors] FOREIGN KEY ([PSNVendorID]) REFERENCES [dbo].[SHExportModulePSNVendors] ([VendorID])
GO