CREATE TABLE [dbo].[CTCommissionRules]
(
[RuleID] [int] NOT NULL IDENTITY(1, 1),
[RuleTypeID] [int] NOT NULL,
[Name] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SQLID] [int] NULL,
[ExternalActivityID] [int] NULL,
[SumOfRevenue] [bit] NOT NULL CONSTRAINT [DF_CTCommissionRules_SumOfRevenue] DEFAULT ((0)),
[SumOfGP] [bit] NOT NULL CONSTRAINT [DF_CTCommissionRules_SumOfGP] DEFAULT ((0)),
[SumOfGPO] [bit] NOT NULL CONSTRAINT [DF_CTCommissionRules_SumOfGPO] DEFAULT ((0)),
[PeriodTypeID] [int] NOT NULL,
[CommissionCategoryID] [int] NULL,
[EffectiveFrom] [int] NOT NULL,
[EffectiveTo] [int] NULL,
[Hurdle] [money] NULL,
[Active] [bit] NOT NULL CONSTRAINT [DF_CTCommissionRules_Active] DEFAULT ((1)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdaterID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTCommissionRules] ADD CONSTRAINT [PK_CTCommissionRules] PRIMARY KEY CLUSTERED ([RuleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTCommissionRules] ADD CONSTRAINT [IX_CTCommissionRules_Name] UNIQUE NONCLUSTERED ([Name]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTCommissionRules] WITH NOCHECK ADD CONSTRAINT [FK_CTCommissionRules_CommissionCategoryID_CTCommissionCategories] FOREIGN KEY ([CommissionCategoryID]) REFERENCES [dbo].[CTCommissionCategories] ([CommissionCategoryID])
GO
ALTER TABLE [dbo].[CTCommissionRules] WITH NOCHECK ADD CONSTRAINT [FK_CTCommissionRules_ExternalActivityID_CTExternalActivities] FOREIGN KEY ([ExternalActivityID]) REFERENCES [dbo].[CTExternalActivities] ([ActivityID])
GO
ALTER TABLE [dbo].[CTCommissionRules] WITH NOCHECK ADD CONSTRAINT [FK_CTCommissionRules_RuleTypeID_CTRuleTypes] FOREIGN KEY ([RuleTypeID]) REFERENCES [dbo].[CTRuleTypes] ([RuleTypeID])
GO
ALTER TABLE [dbo].[CTCommissionRules] WITH NOCHECK ADD CONSTRAINT [FK_CTCommissionRules_SQLID_CTEligibilityQueries] FOREIGN KEY ([SQLID]) REFERENCES [dbo].[CTEligibilityQueries] ([SQLID])
GO