Primary Key
| Primary Key |
Field Type |
| ContentID |
int |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| ID |
int |
|
|
|
| ParentID |
int |
yes |
|
|
| Caption |
nvarchar(256) |
yes |
|
|
| Tooltip |
nvarchar(256) |
yes |
|
|
| SitePageID |
int |
yes |
|
|
| PageTabID |
int |
yes |
|
|
| URL |
nvarchar(2048) |
yes |
|
|
| Target |
nvarchar(256) |
yes |
|
|
| RightImgPad |
int |
yes |
|
|
| TreeIndex |
nvarchar(256) |
yes |
|
|
| LinkType |
tinyint |
|
Default = 0 |
|
| CopySourceID |
int |
yes |
|
|
| CopyBatchGUID |
uniqueidentifier |
yes |
|
|
| IsActive |
bit |
yes |
Default = 1 |
|
| PageTitle |
nvarchar(256) |
yes |
|
|
| cssclass |
nvarchar(100) |
yes |
|
|
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_MenuItems |
ContentID |
|
|
|
| PK_MenuItems |
ContentID, ID |
yes |
yes |
yes |