Tables [dbo].[TCODeliveryAndSetup]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:32 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_TCODeliveryAndSetup_TCOValueSetID: TCOValueSetIDForeign Keys FK_TCODeliveryAndSetup_TCOValueSetID_TCOValueSet_ID: [dbo].[TCOValueSet].TCOValueSetIDTCOValueSetIDint4
False
Shippingdecimal(12,5)9
True
Installationdecimal(12,5)9
True
Customizationdecimal(12,5)9
True
NetworkConnectiondecimal(12,5)9
True
Misc1Namenvarchar(50)100
True
Misc1Costdecimal(12,5)9
True
Misc2Namenvarchar(50)100
True
Misc2Costdecimal(12,5)9
True
Misc3Namenvarchar(50)100
True
Misc3Costdecimal(12,5)9
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_TCODeliveryAndSetup_TCOValueSetID: TCOValueSetIDPK_TCODeliveryAndSetup_TCOValueSetIDTCOValueSetID
True
NameUpdateDeleteColumns
FK_TCODeliveryAndSetup_TCOValueSetID_TCOValueSet_IDCascadeCascadeTCOValueSetID->[dbo].[TCOValueSet].[ID]
CREATE TABLE [dbo].[TCODeliveryAndSetup]
(
[TCOValueSetID] [int] NOT NULL,
[Shipping] [decimal] (12, 5) NULL,
[Installation] [decimal] (12, 5) NULL,
[Customization] [decimal] (12, 5) NULL,
[NetworkConnection] [decimal] (12, 5) NULL,
[Misc1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc1Cost] [decimal] (12, 5) NULL,
[Misc2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc2Cost] [decimal] (12, 5) NULL,
[Misc3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc3Cost] [decimal] (12, 5) NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCODeliveryAndSetup] ADD CONSTRAINT [PK_TCODeliveryAndSetup_TCOValueSetID] PRIMARY KEY CLUSTERED  ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCODeliveryAndSetup] ADD CONSTRAINT [FK_TCODeliveryAndSetup_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO