Tables [dbo].[RTFeatureOptions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:54 AM Thursday, March 21, 2019
Last Modified1:14:06 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_RTFeatureOptions: RTFeatureOptionIDRTFeatureOptionIDint4
False
1 - 1
Indexes IX_RTFeatureOptions_RTFeatureIDForeign Keys FK_RTFeatureOptions_RTFeatureID_RTFeatures: [dbo].[RTFeatures].RTFeatureIDRTFeatureIDint4
False
Indexes IX_RTFeatureOptions_RTFeatureIDForeign Keys FK_RTFeatureOptions_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
True
Indexes IX_RTFeatureOptions_RTFeatureIDNamevarchar(50)50
False
Valuevarchar(4000)4000
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_RTFeatureOptions: RTFeatureOptionIDPK_RTFeatureOptionsRTFeatureOptionID
True
80
IX_RTFeatureOptions_RTFeatureIDRTFeatureID, TechnicianID, Name
True
NameColumns
FK_RTFeatureOptions_RTFeatureID_RTFeaturesRTFeatureID->[dbo].[RTFeatures].[RTFeatureID]
FK_RTFeatureOptions_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
CREATE TABLE [dbo].[RTFeatureOptions]
(
[RTFeatureOptionID] [int] NOT NULL IDENTITY(1, 1),
[RTFeatureID] [int] NOT NULL,
[TechnicianID] [int] NULL,
[Name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Value] [varchar] (4000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions] ADD CONSTRAINT [PK_RTFeatureOptions] PRIMARY KEY CLUSTERED  ([RTFeatureOptionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions] ADD CONSTRAINT [IX_RTFeatureOptions_RTFeatureID] UNIQUE NONCLUSTERED  ([RTFeatureID], [TechnicianID], [Name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions] ADD CONSTRAINT [FK_RTFeatureOptions_RTFeatureID_RTFeatures] FOREIGN KEY ([RTFeatureID]) REFERENCES [dbo].[RTFeatures] ([RTFeatureID])
GO
ALTER TABLE [dbo].[RTFeatureOptions] ADD CONSTRAINT [FK_RTFeatureOptions_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO