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