CREATE TABLE [dbo].[BillingMajorIncludedReduction]
(
[BillingMajorIncludedReductionID] [int] NOT NULL IDENTITY(1, 1),
[BillingMajorReductionFID] [int] NOT NULL,
[OtherMajorReductionFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BillingMajorIncludedReduction] ADD CONSTRAINT [PK_BillingMajorIncludedReduction] PRIMARY KEY NONCLUSTERED  ([BillingMajorIncludedReductionID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BillingMajorIncludedReduction] ADD CONSTRAINT [IX_BillingMajorIncludedReduction_BillingMajorReductionFID] UNIQUE CLUSTERED  ([BillingMajorReductionFID], [OtherMajorReductionFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BillingMajorIncludedReduction] ADD CONSTRAINT [FK_BillingMajorIncludedReduction_BillingMajorReduction] FOREIGN KEY ([BillingMajorReductionFID]) REFERENCES [dbo].[BillingMajorReduction] ([BillingMajorReductionID])
GO
ALTER TABLE [dbo].[BillingMajorIncludedReduction] ADD CONSTRAINT [FK_ReductionBasisDeduction_OtherMajorReduction] FOREIGN KEY ([OtherMajorReductionFID]) REFERENCES [dbo].[BillingMajorReduction] ([BillingMajorReductionID])
GO
GRANT SELECT ON  [dbo].[BillingMajorIncludedReduction] TO [MssExec]
GRANT INSERT ON  [dbo].[BillingMajorIncludedReduction] TO [MssExec]
GRANT DELETE ON  [dbo].[BillingMajorIncludedReduction] TO [MssExec]
GRANT UPDATE ON  [dbo].[BillingMajorIncludedReduction] TO [MssExec]
GO