Tables [dbo].[SAConfigVolumeMapDevices]
PropertyValue
Row Count (~)0
Created12:58:59 AM Thursday, March 21, 2019
Last Modified1:14:16 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SAConfigVolumeMapDevices: ConfigVolumeMapDeviceIDConfigVolumeMapDeviceIDint4
False
1 - 1
Foreign Keys FK_SAConfigVolumeMapDevices_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
True
Foreign Keys FK_SAConfigVolumeMapDevices_ConfigPrinterID_SAConfigPrinterDetails: [dbo].[SAConfigPrinterDetails].ConfigPrinterID\DetailIDConfigPrinterIDint4
True
Foreign Keys FK_SAConfigVolumeMapDevices_ConfigPrinterID_SAConfigPrinterDetails: [dbo].[SAConfigPrinterDetails].ConfigPrinterID\DetailIDDetailIDint4
True
Foreign Keys FK_SAConfigVolumeMapDevices_ConfigQuoteDetailID_SAConfigQuoteDetails: [dbo].[SAConfigQuoteDetails].ConfigQuoteDetailIDConfigQuoteDetailIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigVolumeMapDevices: ConfigVolumeMapDeviceIDPK_SAConfigVolumeMapDevicesConfigVolumeMapDeviceID
True
80
NameColumns
FK_SAConfigVolumeMapDevices_ConfigPrinterID_SAConfigPrinterDetailsConfigPrinterID->[dbo].[SAConfigPrinterDetails].[ConfigPrinterID]
DetailID->[dbo].[SAConfigPrinterDetails].[DetailID]
FK_SAConfigVolumeMapDevices_ConfigQuoteDetailID_SAConfigQuoteDetailsConfigQuoteDetailID->[dbo].[SAConfigQuoteDetails].[ConfigQuoteDetailID]
FK_SAConfigVolumeMapDevices_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
CREATE TABLE [dbo].[SAConfigVolumeMapDevices]
(
[ConfigVolumeMapDeviceID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NULL,
[ConfigPrinterID] [int] NULL,
[DetailID] [int] NULL,
[ConfigQuoteDetailID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [PK_SAConfigVolumeMapDevices] PRIMARY KEY CLUSTERED  ([ConfigVolumeMapDeviceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigPrinterID_SAConfigPrinterDetails] FOREIGN KEY ([ConfigPrinterID], [DetailID]) REFERENCES [dbo].[SAConfigPrinterDetails] ([ConfigPrinterID], [DetailID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigQuoteDetailID_SAConfigQuoteDetails] FOREIGN KEY ([ConfigQuoteDetailID]) REFERENCES [dbo].[SAConfigQuoteDetails] ([ConfigQuoteDetailID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMapDevices] ADD CONSTRAINT [FK_SAConfigVolumeMapDevices_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO