Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
TabID |
int |
X |
|
|
|
TabOrder |
int |
|
|
0 |
|
FK
|
PortalID |
int |
|
X |
|
|
TabName |
nvarchar(200) |
|
|
|
|
IsVisible |
bit |
|
|
1 |
|
FK
|
ParentId |
int |
|
X |
|
|
IconFile |
nvarchar(100) |
|
X |
|
|
DisableLink |
bit |
|
|
0 |
|
Title |
nvarchar(200) |
|
X |
|
|
Description |
nvarchar(500) |
|
X |
|
|
KeyWords |
nvarchar(500) |
|
X |
|
|
IsDeleted |
bit |
|
|
0 |
|
Url |
nvarchar(255) |
|
X |
|
|
SkinSrc |
nvarchar(200) |
|
X |
|
|
ContainerSrc |
nvarchar(200) |
|
X |
|
|
StartDate |
datetime |
|
X |
|
|
EndDate |
datetime |
|
X |
|
|
RefreshInterval |
int |
|
X |
|
|
PageHeadText |
nvarchar(max) |
|
X |
|
|
IsSecure |
bit |
|
|
0 |
|
PermanentRedirect |
bit |
|
|
0 |
|
SiteMapPriority |
float |
|
|
0.5 |
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
|
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
|
|
IconFileLarge |
nvarchar(100) |
|
X |
|
|
CultureCode |
nvarchar(10) |
|
X |
|
|
FK
|
ContentItemID |
int |
|
X |
|
|
UK
|
UniqueId |
uniqueidentifier |
|
|
newid() |
|
VersionGuid |
uniqueidentifier |
|
|
newid() |
|
DefaultLanguageGuid |
uniqueidentifier |
|
X |
|
|
LocalizedVersionGuid |
uniqueidentifier |
|
|
newid() |
|
Level |
int |
|
|
0 |
|
TabPath |
nvarchar(255) |
|
|
'' |
Indexes:
-
PK_Tabs
- (Primary Key)
- (Clustered)
-
IX_Tabs_UniqueId
-
IX_Tabs_ContentID
- ContentItemID
- TabID
(Included)
- TabName
(Included)
- Title
(Included)
- IsVisible
(Included)
- IsDeleted
(Included)
- UniqueId
(Included)
- CultureCode
(Included)
-
IX_Tabs_ParentId_IsDeleted
- ParentId
- IsDeleted
- CreatedOnDate
(Included)
-
IX_Tabs_PortalLevelParentOrder
- PortalID
- Level
- ParentId
- TabOrder
- IsDeleted
- TabID
(Included)
- TabName
(Included)
- IsVisible
(Included)
- IconFile
(Included)
- DisableLink
(Included)
- Title
(Included)
- Description
(Included)
- KeyWords
(Included)
- Url
(Included)
- SkinSrc
(Included)
- ContainerSrc
(Included)
- StartDate
(Included)
- EndDate
(Included)
- RefreshInterval
(Included)
- PageHeadText
(Included)
- IsSecure
(Included)
- PermanentRedirect
(Included)
- SiteMapPriority
(Included)
- CreatedByUserID
(Included)
- CreatedOnDate
(Included)
- LastModifiedByUserID
(Included)
- LastModifiedOnDate
(Included)
- IconFileLarge
(Included)
- CultureCode
(Included)
- ContentItemID
(Included)
- UniqueId
(Included)
- VersionGuid
(Included)
- DefaultLanguageGuid
(Included)
- LocalizedVersionGuid
(Included)
- TabPath
(Included)
References:
Referenced by:
Used by:
- Function
dbo.HasChildTab
- Function
dbo.SuperUserTabID
- Procedure
dbo.AddTab
- Procedure
dbo.AddTabAfter
- Procedure
dbo.AddTabBefore
- Procedure
dbo.AddTabToEnd
- Procedure
dbo.BuildTabLevelAndPath
- Procedure
dbo.CanDeleteSkin
- Procedure
dbo.ConvertTabToNeutralLanguage
- Procedure
dbo.DeleteTab
- Procedure
dbo.DeleteTabPermissionsByUserID
- Procedure
dbo.DeleteTranslatedTabs
- Procedure
dbo.EnsureNeutralLanguage
- Procedure
dbo.GetModuleByDefinition
- Procedure
dbo.GetModulePackagesInUse
- Procedure
dbo.GetModulePermissionsByTabID
- Procedure
dbo.GetSearchModules
- Procedure
dbo.GetSearchResultModules
- Procedure
dbo.GetSiteLog2
- Procedure
dbo.GetSiteLog9
- Procedure
dbo.GetTabCustomAliases
- Procedure
dbo.GetTabSettings
- Procedure
dbo.GetTabUrls
- Procedure
dbo.LocalizeTab
- Procedure
dbo.MoveTabAfter
- Procedure
dbo.MoveTabBefore
- Procedure
dbo.MoveTabToParent
- Procedure
dbo.UpdateTab
- Procedure
dbo.UpdateTabOrder
- Procedure
dbo.UpdateTabTranslationStatus
- Procedure
dbo.UpdateTabVersion
- View
- View
- View
- View