CREATE TABLE [dbo].[ICConfigRelationRules]
(
[ConfigRelationRuleID] [int] NOT NULL IDENTITY(1, 1),
[ConfigNodeID] [int] NOT NULL,
[ConfigNodeRValID] [int] NOT NULL,
[ConfigID] [int] NOT NULL,
[LowQty] [tinyint] NOT NULL,
[HighQty] [tinyint] NOT NULL,
[PrevConfigRelationRuleID] [int] NULL,
[PrevRuleCompareType] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MatchParentQty] [bit] NULL CONSTRAINT [DF_ICConfigRelationRules_MatchParentQty] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigRelationRules] ADD CONSTRAINT [PK__ICConfig__62351D189D0FC4C0] PRIMARY KEY CLUSTERED ([ConfigRelationRuleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigRelationRules] ADD CONSTRAINT [FK_ICConfigRelationRules_ConfigID_ICConfigs] FOREIGN KEY ([ConfigID]) REFERENCES [dbo].[ICConfigs] ([ConfigID])
GO
ALTER TABLE [dbo].[ICConfigRelationRules] ADD CONSTRAINT [FK_ICConfigRelationRules_ConfigNodeID_ICConfigNodes] FOREIGN KEY ([ConfigNodeID]) REFERENCES [dbo].[ICConfigNodes] ([ConfigNodeID])
GO
ALTER TABLE [dbo].[ICConfigRelationRules] ADD CONSTRAINT [FK_ICConfigRelationRules_PrevConfigRelationRuleID_ICConfigRelationRules] FOREIGN KEY ([PrevConfigRelationRuleID]) REFERENCES [dbo].[ICConfigRelationRules] ([ConfigRelationRuleID])
GO