Primary Key Field Type
 ContentID int

Field Field Type Null Notes Description
 ID int  
 ParentID int
 Caption nvarchar(256)
 Tooltip nvarchar(256)
 SitePageID int
 PageTabID int
 URL nvarchar(2048)
 Target nvarchar(256)
 RightImgPad int
 TreeIndex nvarchar(256)
 LinkType tinyint   Default = 0
 CopySourceID int
 CopyBatchGUID uniqueidentifier
 IsActive bit Default = 1
 PageTitle nvarchar(256)
 cssclass nvarchar(100)

Foreign Key Field Type Null Notes Description
 ContentID int   SiteMenu.ContentID

Index Name Field(s) Unique Primary Clustered
 IX_MenuItems ContentID      
 PK_MenuItems ContentID, ID

Entity-Relationship diagram of this table