EnVisageOnline/Main/Source/iniPHIClientControlAPI/iniPHIClientControlDatabase/dbo/SubscriptionFeature2Group.sql

10 lines
463 B
Transact-SQL

CREATE TABLE [dbo].[SubscriptionFeature2Group] (
[SubscriptionFeatureId] UNIQUEIDENTIFIER NOT NULL,
[SubscriptionGroupId] UNIQUEIDENTIFIER NOT NULL,
CONSTRAINT [FK_SubscriptionFeature2Group_SubscriptionFeature] FOREIGN KEY ([SubscriptionFeatureId]) REFERENCES [dbo].[SubscriptionFeature] ([Id]),
CONSTRAINT [FK_SubscriptionFeature2Group_SubscriptionGroup] FOREIGN KEY ([SubscriptionGroupId]) REFERENCES [dbo].[SubscriptionGroup] ([Id])
);