Database reference - DotNetNuke 5.6
DotNetNuke 5.6
- tables
Table overview
name
columns
indexes
triggers
constraints
refers to
refers from
dependents
comment
Affiliates
8
1
0
2
1
0
7
AnonymousUsers
5
1
0
3
1
0
3
aspnet_Applications
4
4
0
3
0
3
35
aspnet_Membership
21
2
0
3
2
0
16
aspnet_Profile
5
1
0
2
1
0
6
aspnet_Roles
5
2
0
2
1
1
13
aspnet_SchemaVersions
3
1
0
2
0
0
4
aspnet_Users
7
3
0
2
1
3
31
aspnet_UsersInRoles
2
2
0
4
2
0
10
Assemblies
4
1
0
2
1
0
3
Authentication
11
1
0
2
1
0
9
Banners
19
3
0
2
1
0
12
Classification
3
2
0
2
1
1
3
ContentItems
11
1
0
2
1
4
10
ContentItems_MetaData
4
1
0
3
2
0
4
ContentItems_Tags
3
3
0
3
2
0
7
ContentTypes
2
1
0
1
0
1
5
Dashboard_Controls
8
1
0
2
1
0
6
DesktopModulePermission
10
2
0
8
3
0
8
DesktopModules
18
3
0
3
1
2
18
EventLog
12
2
0
3
2
0
10
EventLogConfig
11
2
0
2
1
1
10
EventLogTypes
5
1
0
1
0
2
7
EventQueue
14
1
0
1
0
0
5
Files
18
4
0
6
2
0
31
FolderPermission
10
6
0
8
3
0
13
Folders
13
3
0
5
1
2
18
HostSettings
7
1
0
1
0
0
5
HtmlText
10
1
0
3
2
2
8
HtmlTextLog
7
1
0
3
2
0
3
HtmlTextUsers
7
1
0
2
1
0
4
LanguagePacks
8
2
0
3
2
0
6
Languages
8
2
0
1
0
2
7
Links
8
2
0
2
1
0
7
Lists
15
4
0
5
0
0
12
Messaging_Messages
18
1
0
1
0
0
9
MetaData
3
1
0
1
0
1
3
ModuleControls
14
3
0
5
1
0
12
ModuleDefinitions
8
3
0
3
1
2
15
ModulePermission
10
5
0
8
3
0
12
Modules
13
2
0
4
3
6
20
ModuleSettings
7
1
0
3
1
0
7
Packages
19
2
0
2
1
7
4
PackageTypes
4
1
0
1
0
1
3
Permission
10
2
0
4
0
4
18
PortalAlias
7
2
0
3
1
0
12
PortalDesktopModules
7
2
0
5
2
1
6
PortalLanguages
8
2
0
3
2
0
6
PortalLocalization
19
0
0
1
1
0
7
Portals
24
3
0
1
0
21
17
PortalSettings
8
1
0
4
1
0
7
Profile
5
2
0
3
2
0
6
ProfilePropertyDefinition
18
3
0
2
1
1
11
RoleGroups
8
2
0
4
1
1
8
Roles
19
3
0
5
2
1
20
Schedule
17
1
0
1
0
2
11
ScheduleHistory
8
3
0
2
1
0
9
ScheduleItemSettings
3
1
0
3
1
0
3
SearchCommonWords
3
1
0
1
0
0
6
SearchIndexer
2
1
0
1
0
0
2
SearchItem
10
2
0
2
1
1
10
SearchItemWord
4
2
0
5
2
1
11
SearchItemWordPosition
3
1
0
2
1
0
7
SearchWord
4
2
0
2
0
1
8
SiteLog
11
2
0
2
1
0
14
SkinControls
11
1
0
2
1
0
8
SkinPackages
9
1
0
2
1
1
6
Skins
3
1
0
2
1
0
5
SystemMessages
4
2
0
4
1
0
7
TabModules
33
3
0
6
2
1
22
TabModuleSettings
7
1
0
3
1
0
7
TabPermission
10
6
0
8
3
0
13
Tabs
35
6
0
5
3
3
30
TabSettings
7
1
0
1
1
0
7
Taxonomy_ScopeTypes
2
1
0
1
0
1
5
Taxonomy_Terms
12
1
0
3
2
1
11
Taxonomy_Vocabularies
12
1
0
3
2
1
5
Taxonomy_VocabularyTypes
2
1
0
1
0
1
1
UrlLog
4
1
0
2
1
0
3
Urls
3
2
0
4
1
0
6
UrlTracking
11
2
0
5
1
1
10
UserAuthentication
8
2
0
2
1
0
5
UserPortals
7
2
0
4
2
0
10
UserProfile
7
3
0
3
2
0
5
UserRoles
10
3
0
3
2
0
11
Users
15
4
0
2
0
10
34
UsersOnline
5
1
0
4
2
0
5
VendorClassification
3
3
0
5
2
0
6
Vendors
23
2
0
4
1
3
10
Version
6
2
0
4
0
0
7
WebServers
7
1
0
1
0
0
6
Workflow
5
2
0
1
0
1
7
WorkflowStates
6
2
0
2
1
2
8
Tables referenced by views, procedures, or functions
name
references
Affiliates
6
AnonymousUsers
2
aspnet_Applications
31
aspnet_Membership
14
aspnet_Profile
5
aspnet_Roles
11
aspnet_SchemaVersions
3
aspnet_Users
28
aspnet_UsersInRoles
8
Assemblies
2
Authentication
8
Banners
9
Classification
1
ContentItems
9
ContentItems_MetaData
3
ContentItems_Tags
4
ContentTypes
4
Dashboard_Controls
5
DesktopModulePermission
6
DesktopModules
15
EventLog
8
EventLogConfig
8
EventLogTypes
6
EventQueue
4
Files
27
FolderPermission
7
Folders
15
HostSettings
4
HtmlText
7
HtmlTextLog
2
HtmlTextUsers
3
LanguagePacks
4
Languages
5
Links
5
Lists
8
Messaging_Messages
8
MetaData
2
ModuleControls
9
ModuleDefinitions
12
ModulePermission
7
Modules
18
ModuleSettings
6
Packages
2
PackageTypes
2
Permission
16
PortalAlias
10
PortalDesktopModules
4
PortalLanguages
4
PortalLocalization
7
Portals
14
PortalSettings
6
Profile
4
ProfilePropertyDefinition
8
RoleGroups
6
Roles
17
Schedule
10
ScheduleHistory
6
ScheduleItemSettings
2
SearchCommonWords
5
SearchIndexer
1
SearchItem
8
SearchItemWord
9
SearchItemWordPosition
6
SearchWord
6
SiteLog
12
SkinControls
7
SkinPackages
5
Skins
4
SystemMessages
5
TabModules
19
TabModuleSettings
6
TabPermission
7
Tabs
24
TabSettings
6
Taxonomy_ScopeTypes
4
Taxonomy_Terms
10
Taxonomy_Vocabularies
4
UrlLog
2
Urls
4
UrlTracking
8
UserAuthentication
3
UserPortals
8
UserProfile
2
UserRoles
8
Users
30
UsersOnline
4
VendorClassification
3
Vendors
8
Version
5
WebServers
5
Workflow
5
WorkflowStates
6
Tables not referenced by views, procedures, or functions
name
Taxonomy_VocabularyTypes
Generated by DotNetNukeRu