Tables [dbo].[ICConfigRelationRules]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:26 AM Thursday, March 21, 2019
Last Modified1:11:17 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__ICConfig__62351D189D0FC4C0: ConfigRelationRuleIDConfigRelationRuleIDint4
False
1 - 1
Foreign Keys FK_ICConfigRelationRules_ConfigNodeID_ICConfigNodes: [dbo].[ICConfigNodes].ConfigNodeIDConfigNodeIDint4
False
ConfigNodeRValIDint4
False
Foreign Keys FK_ICConfigRelationRules_ConfigID_ICConfigs: [dbo].[ICConfigs].ConfigIDConfigIDint4
False
LowQtytinyint1
False
HighQtytinyint1
False
Foreign Keys FK_ICConfigRelationRules_PrevConfigRelationRuleID_ICConfigRelationRules: [dbo].[ICConfigRelationRules].PrevConfigRelationRuleIDPrevConfigRelationRuleIDint4
True
PrevRuleCompareTypechar(3)3
True
MatchParentQtybit1
True
((0))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ICConfig__62351D189D0FC4C0: ConfigRelationRuleIDPK__ICConfig__62351D189D0FC4C0ConfigRelationRuleID
True
80
NameColumns
FK_ICConfigRelationRules_ConfigID_ICConfigsConfigID->[dbo].[ICConfigs].[ConfigID]
FK_ICConfigRelationRules_ConfigNodeID_ICConfigNodesConfigNodeID->[dbo].[ICConfigNodes].[ConfigNodeID]
FK_ICConfigRelationRules_PrevConfigRelationRuleID_ICConfigRelationRulesPrevConfigRelationRuleID->[dbo].[ICConfigRelationRules].[ConfigRelationRuleID]
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