Tables [dbo].[SAConfigVolumeMap]
PropertyValue
Row Count (~)0
Created12:58:59 AM Thursday, March 21, 2019
Last Modified1:14:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SAConfigVolumeMap: ConfigVolumeMapIDConfigVolumeMapIDint4
False
1 - 1
Foreign Keys FK_SAConfigVolumeMap_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
False
Foreign Keys FK_SAConfigVolumeMap_ConfigPrinterID_SAConfigPrinterDetails: [dbo].[SAConfigPrinterDetails].ConfigPrinterID\DetailIDConfigPrinterIDint4
True
Foreign Keys FK_SAConfigVolumeMap_ConfigPrinterID_SAConfigPrinterDetails: [dbo].[SAConfigPrinterDetails].ConfigPrinterID\DetailIDDetailIDint4
True
Foreign Keys FK_SAConfigVolumeMap_CurrentTCODetailID_SAConfigCurrentTCODetails: [dbo].[SAConfigCurrentTCODetails].CurrentTCODetailIDCurrentTCODetailIDint4
True
Foreign Keys FK_SAConfigVolumeMap_ConfigVolumeMapDeviceID_SAConfigVolumeMapDevices: [dbo].[SAConfigVolumeMapDevices].ConfigVolumeMapDeviceIDConfigVolumeMapDeviceIDint4
False
MappedBlackVolumeint4
True
MappedColorVolumeint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigVolumeMap: ConfigVolumeMapIDPK_SAConfigVolumeMapConfigVolumeMapID
True
80
NameColumns
FK_SAConfigVolumeMap_ConfigPrinterID_SAConfigPrinterDetailsConfigPrinterID->[dbo].[SAConfigPrinterDetails].[ConfigPrinterID]
DetailID->[dbo].[SAConfigPrinterDetails].[DetailID]
FK_SAConfigVolumeMap_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
FK_SAConfigVolumeMap_ConfigVolumeMapDeviceID_SAConfigVolumeMapDevicesConfigVolumeMapDeviceID->[dbo].[SAConfigVolumeMapDevices].[ConfigVolumeMapDeviceID]
FK_SAConfigVolumeMap_CurrentTCODetailID_SAConfigCurrentTCODetailsCurrentTCODetailID->[dbo].[SAConfigCurrentTCODetails].[CurrentTCODetailID]
CREATE TABLE [dbo].[SAConfigVolumeMap]
(
[ConfigVolumeMapID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[ConfigPrinterID] [int] NULL,
[DetailID] [int] NULL,
[CurrentTCODetailID] [int] NULL,
[ConfigVolumeMapDeviceID] [int] NOT NULL,
[MappedBlackVolume] [int] NULL,
[MappedColorVolume] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMap] ADD CONSTRAINT [PK_SAConfigVolumeMap] PRIMARY KEY CLUSTERED  ([ConfigVolumeMapID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigVolumeMap] ADD CONSTRAINT [FK_SAConfigVolumeMap_ConfigPrinterID_SAConfigPrinterDetails] FOREIGN KEY ([ConfigPrinterID], [DetailID]) REFERENCES [dbo].[SAConfigPrinterDetails] ([ConfigPrinterID], [DetailID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMap] ADD CONSTRAINT [FK_SAConfigVolumeMap_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMap] ADD CONSTRAINT [FK_SAConfigVolumeMap_ConfigVolumeMapDeviceID_SAConfigVolumeMapDevices] FOREIGN KEY ([ConfigVolumeMapDeviceID]) REFERENCES [dbo].[SAConfigVolumeMapDevices] ([ConfigVolumeMapDeviceID])
GO
ALTER TABLE [dbo].[SAConfigVolumeMap] ADD CONSTRAINT [FK_SAConfigVolumeMap_CurrentTCODetailID_SAConfigCurrentTCODetails] FOREIGN KEY ([CurrentTCODetailID]) REFERENCES [dbo].[SAConfigCurrentTCODetails] ([CurrentTCODetailID])
GO