Generated using SQL Data Dictionary demo version.
| |
Column |
Data Type |
Identity |
Nullable |
Default |
| PK |
TabModuleID |
int |
X |
|
|
|
UK
,
FK
|
TabID |
int |
|
|
|
|
UK
,
FK
|
ModuleID |
int |
|
|
|
|
PaneName |
nvarchar(50) |
|
|
|
|
ModuleOrder |
int |
|
|
|
|
CacheTime |
int |
|
|
|
|
Alignment |
nvarchar(10) |
|
X |
|
|
Color |
nvarchar(20) |
|
X |
|
|
Border |
nvarchar(1) |
|
X |
|
|
IconFile |
nvarchar(100) |
|
X |
|
|
Visibility |
int |
|
|
|
|
ContainerSrc |
nvarchar(200) |
|
X |
|
|
DisplayTitle |
bit |
|
|
1 |
|
DisplayPrint |
bit |
|
|
1 |
|
DisplaySyndicate |
bit |
|
|
1 |
|
IsWebSlice |
bit |
|
|
0 |
|
WebSliceTitle |
nvarchar(256) |
|
X |
|
|
WebSliceExpiryDate |
datetime |
|
X |
|
|
WebSliceTTL |
int |
|
X |
|
|
CreatedByUserID |
int |
|
X |
|
|
CreatedOnDate |
datetime |
|
X |
getdate() |
|
LastModifiedByUserID |
int |
|
X |
|
|
LastModifiedOnDate |
datetime |
|
X |
getdate() |
|
IsDeleted |
bit |
|
|
0 |
|
CacheMethod |
varchar(50) |
|
X |
|
|
ModuleTitle |
nvarchar(256) |
|
X |
|
|
Header |
nvarchar(max) |
|
X |
|
|
Footer |
nvarchar(max) |
|
X |
|
|
CultureCode |
nvarchar(10) |
|
X |
|
|
UK
|
UniqueId |
uniqueidentifier |
|
|
newid() |
|
VersionGuid |
uniqueidentifier |
|
|
newid() |
|
DefaultLanguageGuid |
uniqueidentifier |
|
X |
|
|
LocalizedVersionGuid |
uniqueidentifier |
|
|
newid() |
Indexes:
-
PK_TabModules
- (Primary Key)
- (Clustered)
-
IX_TabModules_TabID
- TabID
- ModuleID
- IsDeleted
(Included)
- CultureCode
(Included)
- ModuleTitle
(Included)
-
IX_TabModules_UniqueId
-
IX_TabModules_ModuleID
- ModuleID
- TabID
- IsDeleted
(Included)
- CultureCode
(Included)
- ModuleTitle
(Included)
-
IX_TabModules_ModuleOrder
- TabID
- PaneName
- ModuleOrder
- TabModuleID
(Included)
- ModuleID
(Included)
- CacheTime
(Included)
- Alignment
(Included)
- Color
(Included)
- Border
(Included)
- IconFile
(Included)
- Visibility
(Included)
- ContainerSrc
(Included)
- DisplayTitle
(Included)
- DisplayPrint
(Included)
- DisplaySyndicate
(Included)
- IsWebSlice
(Included)
- WebSliceTitle
(Included)
- WebSliceExpiryDate
(Included)
- WebSliceTTL
(Included)
- CreatedByUserID
(Included)
- CreatedOnDate
(Included)
- LastModifiedByUserID
(Included)
- LastModifiedOnDate
(Included)
- IsDeleted
(Included)
- CacheMethod
(Included)
- ModuleTitle
(Included)
- Header
(Included)
- Footer
(Included)
- CultureCode
(Included)
- UniqueId
(Included)
- VersionGuid
(Included)
- DefaultLanguageGuid
(Included)
- LocalizedVersionGuid
(Included)
References:
Referenced by:
Used by:
- Procedure
dbo.AddTabModule
- Procedure
dbo.CanDeleteSkin
- Procedure
dbo.DeleteTabModule
- Procedure
dbo.DeleteTranslatedTabs
- Procedure
dbo.GetAllTabsModules
- Procedure
dbo.GetExtensionUrlProviders
- Procedure
dbo.GetModulePermissionsByTabID
- Procedure
dbo.GetModuleSettingsByTab
- Procedure
dbo.GetSearchResultModules
- Procedure
dbo.GetTabModuleOrder
- Procedure
dbo.GetTabModuleSettingsByTab
- Procedure
dbo.GetTabPanes
- Procedure
dbo.GetTabsByModuleID
- Procedure
dbo.GetTabsByTabModuleID
- Procedure
dbo.LocalizeTab
- Procedure
dbo.MoveTabModule
- Procedure
dbo.RestoreTabModule
- Procedure
dbo.UpdateModuleOrder
- Procedure
dbo.UpdateTabModule
- Procedure
dbo.UpdateTabModuleTranslationStatus
- Procedure
dbo.UpdateTabModuleVersion
- Procedure
dbo.UpdateTabModuleVersionByModule
- View
- View