Tables [dbo].[ICConfigNodes]
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__AE1433C32ED83E9C: ConfigNodeIDConfigNodeIDint4
False
1 - 1
Foreign Keys FK_ICConfigNodes_ConfigID_ICConfigs: [dbo].[ICConfigs].ConfigIDConfigIDint4
False
Foreign Keys FK_ICConfigNodes_ConfigNodeParentID_ICConfigNodes: [dbo].[ICConfigNodes].ConfigNodeParentIDConfigNodeParentIDint4
True
ConfigNodeTypeIDint4
False
Foreign Keys FK_ICConfigNodes_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
ConfigTitleIDint4
True
Descriptionvarchar(255)255
True
Ordinalint4
False
DefaultValuetinyint1
True
Exclusivitybit1
False
((0))
Requiredbit1
False
((0))
StartDatedatetime8
True
ExpDatedatetime8
True
EvenOnlybit1
True
MaxValuetinyint1
True
MinValuetinyint1
True
OptionsTextvarchar(50)50
True
RelationRulesTextvarchar(2000)2000
True
AutoCostbit1
False
((1))
AutoPricebit1
False
((1))
RollUpbit1
False
((1))
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__ICConfig__AE1433C32ED83E9C: ConfigNodeIDPK__ICConfig__AE1433C32ED83E9CConfigNodeID
True
80
NameColumns
FK_ICConfigNodes_ConfigID_ICConfigsConfigID->[dbo].[ICConfigs].[ConfigID]
FK_ICConfigNodes_ConfigNodeParentID_ICConfigNodesConfigNodeParentID->[dbo].[ICConfigNodes].[ConfigNodeID]
FK_ICConfigNodes_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
CREATE TABLE [dbo].[ICConfigNodes]
(
[ConfigNodeID] [int] NOT NULL IDENTITY(1, 1),
[ConfigID] [int] NOT NULL,
[ConfigNodeParentID] [int] NULL,
[ConfigNodeTypeID] [int] NOT NULL,
[ItemID] [int] NULL,
[ConfigTitleID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Ordinal] [int] NOT NULL,
[DefaultValue] [tinyint] NULL,
[Exclusivity] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_Exclusivity] DEFAULT ((0)),
[Required] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_Required] DEFAULT ((0)),
[StartDate] [datetime] NULL,
[ExpDate] [datetime] NULL,
[EvenOnly] [bit] NULL,
[MaxValue] [tinyint] NULL,
[MinValue] [tinyint] NULL,
[OptionsText] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[RelationRulesText] [varchar] (2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AutoCost] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_AutoCost] DEFAULT ((1)),
[AutoPrice] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_AutoPrice] DEFAULT ((1)),
[RollUp] [bit] NOT NULL CONSTRAINT [DF_ICConfigNodes_RollUp] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [PK__ICConfig__AE1433C32ED83E9C] PRIMARY KEY CLUSTERED  ([ConfigNodeID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ConfigID_ICConfigs] FOREIGN KEY ([ConfigID]) REFERENCES [dbo].[ICConfigs] ([ConfigID])
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ConfigNodeParentID_ICConfigNodes] FOREIGN KEY ([ConfigNodeParentID]) REFERENCES [dbo].[ICConfigNodes] ([ConfigNodeID])
GO
ALTER TABLE [dbo].[ICConfigNodes] ADD CONSTRAINT [FK_ICConfigNodes_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO