Tables [dbo].[TCOService]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:20:03 AM Thursday, March 21, 2019
Last Modified1:20:33 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Cluster Primary Key PK_TCOService_TCOValueSetID: TCOValueSetIDForeign Keys FK_TCOService_TCOValueSetID_TCOValueSet_ID: [dbo].[TCOValueSet].TCOValueSetIDTCOValueSetIDint4
False
Misc1Namenvarchar(50)100
True
Misc1ServiceMinutesint4
True
Misc1Yieldint4
True
Misc2Namenvarchar(50)100
True
Misc2ServiceMinutesint4
True
Misc2Yieldint4
True
Misc3Namenvarchar(50)100
True
Misc3ServiceMinutesint4
True
Misc3Yieldint4
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK_TCOService_TCOValueSetID: TCOValueSetIDPK_TCOService_TCOValueSetIDTCOValueSetID
True
NameUpdateDeleteColumns
FK_TCOService_TCOValueSetID_TCOValueSet_IDCascadeCascadeTCOValueSetID->[dbo].[TCOValueSet].[ID]
CREATE TABLE [dbo].[TCOService]
(
[TCOValueSetID] [int] NOT NULL,
[Misc1Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc1ServiceMinutes] [int] NULL,
[Misc1Yield] [int] NULL,
[Misc2Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc2ServiceMinutes] [int] NULL,
[Misc2Yield] [int] NULL,
[Misc3Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Misc3ServiceMinutes] [int] NULL,
[Misc3Yield] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOService] ADD CONSTRAINT [PK_TCOService_TCOValueSetID] PRIMARY KEY CLUSTERED  ([TCOValueSetID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TCOService] ADD CONSTRAINT [FK_TCOService_TCOValueSetID_TCOValueSet_ID] FOREIGN KEY ([TCOValueSetID]) REFERENCES [dbo].[TCOValueSet] ([ID]) ON DELETE CASCADE ON UPDATE CASCADE
GO