Tables [dbo].[ICConfigIncludeRules]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:24 AM Thursday, March 21, 2019
Last Modified1:11:15 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__ICConfig__2CF0D03EC848C525: ConfigIncludeRuleIDConfigIncludeRuleIDint4
False
1 - 1
ConfigNodeIDint4
False
ConfigIDint4
False
LowQtydecimal(14,4)9
False
HighQtydecimal(14,4)9
False
Foreign Keys FK_ICConfigIncludeRules_PrevConfigIncludeRuleID_ICConfigIncludeRules: [dbo].[ICConfigIncludeRules].PrevConfigIncludeRuleIDPrevConfigIncludeRuleIDint4
True
PrevRuleCompareTypechar(3)3
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ICConfig__2CF0D03EC848C525: ConfigIncludeRuleIDPK__ICConfig__2CF0D03EC848C525ConfigIncludeRuleID
True
80
NameColumns
FK_ICConfigIncludeRules_PrevConfigIncludeRuleID_ICConfigIncludeRulesPrevConfigIncludeRuleID->[dbo].[ICConfigIncludeRules].[ConfigIncludeRuleID]
CREATE TABLE [dbo].[ICConfigIncludeRules]
(
[ConfigIncludeRuleID] [int] NOT NULL IDENTITY(1, 1),
[ConfigNodeID] [int] NOT NULL,
[ConfigID] [int] NOT NULL,
[LowQty] [decimal] (14, 4) NOT NULL,
[HighQty] [decimal] (14, 4) NOT NULL,
[PrevConfigIncludeRuleID] [int] NULL,
[PrevRuleCompareType] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigIncludeRules] ADD CONSTRAINT [PK__ICConfig__2CF0D03EC848C525] PRIMARY KEY CLUSTERED  ([ConfigIncludeRuleID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigIncludeRules] ADD CONSTRAINT [FK_ICConfigIncludeRules_PrevConfigIncludeRuleID_ICConfigIncludeRules] FOREIGN KEY ([PrevConfigIncludeRuleID]) REFERENCES [dbo].[ICConfigIncludeRules] ([ConfigIncludeRuleID])
GO