View Source

Class Constants.DatabaseSchema.Tables

Provides constants for Umbraco database table names.

Inheritance

object

Namespace: Umbraco.Cms.Core

Assembly: Umbraco.Core.dll

Syntax

public static class Constants.DatabaseSchema.Tables

Fields

Access

The public access table name.

Declaration

public const string Access = "umbracoAccess"

Field Value

Type	Description
string

AccessRule

The access rule table name.

Declaration

public const string AccessRule = "umbracoAccessRule"

Field Value

Type	Description
string

AuditEntry

The audit entry table name.

Declaration

public const string AuditEntry = "umbracoAudit"

Field Value

Type	Description
string

CacheInstruction

The cache instruction table name.

Declaration

public const string CacheInstruction = "umbracoCacheInstruction"

Field Value

Type	Description
string

Consent

The consent table name.

Declaration

public const string Consent = "umbracoConsent"

Field Value

Type	Description
string

Content

The content table name.

Declaration

public const string Content = "umbracoContent"

Field Value

Type	Description
string

ContentChildType

The content child type (allowed content types) table name.

Declaration

public const string ContentChildType = "cmsContentTypeAllowedContentType"

Field Value

Type	Description
string

ContentSchedule

The content schedule table name.

Declaration

public const string ContentSchedule = "umbracoContentSchedule"

Field Value

Type	Description
string

ContentType

The content type table name.

Declaration

public const string ContentType = "cmsContentType"

Field Value

Type	Description
string

ContentTypeTree

The content type tree (composition) table name.

Declaration

public const string ContentTypeTree = "cmsContentType2ContentType"

Field Value

Type	Description
string

ContentVersion

The content version table name.

Declaration

public const string ContentVersion = "umbracoContentVersion"

Field Value

Type	Description
string

ContentVersionCleanupPolicy

The content version cleanup policy table name.

Declaration

public const string ContentVersionCleanupPolicy = "umbracoContentVersionCleanupPolicy"

Field Value

Type	Description
string

ContentVersionCultureVariation

The content version culture variation table name.

Declaration

public const string ContentVersionCultureVariation = "umbracoContentVersionCultureVariation"

Field Value

Type	Description
string

CreatedPackageSchema

The created package schema table name.

Declaration

public const string CreatedPackageSchema = "umbracoCreatedPackageSchema"

Field Value

Type	Description
string

DataType

The data type table name.

Declaration

public const string DataType = "umbracoDataType"

Field Value

Type	Description
string

DictionaryEntry

The dictionary entry table name.

Declaration

public const string DictionaryEntry = "cmsDictionary"

Field Value

Type	Description
string

DictionaryValue

The dictionary value (language text) table name.

Declaration

public const string DictionaryValue = "cmsLanguageText"

Field Value

Type	Description
string

DistributedJob

The distributed job table name.

Declaration

public const string DistributedJob = "umbracoDistributedJob"

Field Value

Type	Description
string

Document

The document table name.

Declaration

public const string Document = "umbracoDocument"

Field Value

Type	Description
string

DocumentCultureVariation

The document culture variation table name.

Declaration

public const string DocumentCultureVariation = "umbracoDocumentCultureVariation"

Field Value

Type	Description
string

DocumentType

The document type table name.

Declaration

public const string DocumentType = "cmsDocumentType"

Field Value

Type	Description
string

DocumentUrl

The document URL table name.

Declaration

public const string DocumentUrl = "umbracoDocumentUrl"

Field Value

Type	Description
string

DocumentUrlAlias

The document URL alias.

Declaration

public const string DocumentUrlAlias = "umbracoDocumentUrlAlias"

Field Value

Type	Description
string

DocumentVersion

The document version table name.

Declaration

public const string DocumentVersion = "umbracoDocumentVersion"

Field Value

Type	Description
string

Domain

The domain table name.

Declaration

public const string Domain = "umbracoDomain"

Field Value

Type	Description
string

ElementTypeTree

The element type tree table name.

Declaration

[Obsolete("Please use ContentTypeTree instead. Scheduled for removal in Umbraco 18.")]
public const string ElementTypeTree = "cmsContentType2ContentType"

Field Value

Type	Description
string

ExternalLogin

The external login table name.

Declaration

public const string ExternalLogin = "umbracoExternalLogin"

Field Value

Type	Description
string

ExternalLoginToken

The external login token table name.

Declaration

public const string ExternalLoginToken = "umbracoExternalLoginToken"

Field Value

Type	Description
string

KeyValue

The key-value table name.

Declaration

public const string KeyValue = "umbracoKeyValue"

Field Value

Type	Description
string

Language

The language table name.

Declaration

public const string Language = "umbracoLanguage"

Field Value

Type	Description
string

LastSynced

The last synced table name.

Declaration

public const string LastSynced = "umbracoLastSynced"

Field Value

Type	Description
string

Lock

The lock table name.

Declaration

public const string Lock = "umbracoLock"

Field Value

Type	Description
string

Log

The log table name.

Declaration

public const string Log = "umbracoLog"

Field Value

Type	Description
string

LogViewerQuery

The log viewer query table name.

Declaration

public const string LogViewerQuery = "umbracoLogViewerQuery"

Field Value

Type	Description
string

LongRunningOperation

The long-running operation table name.

Declaration

public const string LongRunningOperation = "umbracoLongRunningOperation"

Field Value

Type	Description
string

MediaVersion

The media version table name.

Declaration

public const string MediaVersion = "umbracoMediaVersion"

Field Value

Type	Description
string

Member

The member table name.

Declaration

public const string Member = "cmsMember"

Field Value

Type	Description
string

Member2MemberGroup

The member to member group mapping table name.

Declaration

public const string Member2MemberGroup = "cmsMember2MemberGroup"

Field Value

Type	Description
string

MemberPropertyType

The member property type table name.

Declaration

public const string MemberPropertyType = "cmsMemberType"

Field Value

Type	Description
string

Node

The node table name.

Declaration

public const string Node = "umbracoNode"

Field Value

Type	Description
string

NodeData

The node data table name.

Declaration

public const string NodeData = "cmsContentNu"

Field Value

Type	Description
string

PropertyData

The property data table name.

Declaration

public const string PropertyData = "umbracoPropertyData"

Field Value

Type	Description
string

PropertyType

The property type table name.

Declaration

public const string PropertyType = "cmsPropertyType"

Field Value

Type	Description
string

PropertyTypeGroup

The property type group table name.

Declaration

public const string PropertyTypeGroup = "cmsPropertyTypeGroup"

Field Value

Type	Description
string

RedirectUrl

The redirect URL table name.

Declaration

public const string RedirectUrl = "umbracoRedirectUrl"

Field Value

Type	Description
string

Relation

The relation table name.

Declaration

public const string Relation = "umbracoRelation"

Field Value

Type	Description
string

RelationType

The relation type table name.

Declaration

public const string RelationType = "umbracoRelationType"

Field Value

Type	Description
string

RepositoryCacheVersion

The repository cache version table name.

Declaration

public const string RepositoryCacheVersion = "umbracoRepositoryCacheVersion"

Field Value

Type	Description
string

Server

The server registration table name.

Declaration

public const string Server = "umbracoServer"

Field Value

Type	Description
string

Tag

The tag table name.

Declaration

public const string Tag = "cmsTags"

Field Value

Type	Description
string

TagRelationship

The tag relationship table name.

Declaration

public const string TagRelationship = "cmsTagRelationship"

Field Value

Type	Description
string

Template

The template table name.

Declaration

public const string Template = "cmsTemplate"

Field Value

Type	Description
string

TwoFactorLogin

The two-factor login table name.

Declaration

public const string TwoFactorLogin = "umbracoTwoFactorLogin"

Field Value

Type	Description
string

User

The user table name.

Declaration

public const string User = "umbracoUser"

Field Value

Type	Description
string

User2ClientId

The user to client ID mapping table name.

Declaration

public const string User2ClientId = "umbracoUser2ClientId"

Field Value

Type	Description
string

User2NodeNotify

The user to node notification table name.

Declaration

public const string User2NodeNotify = "umbracoUser2NodeNotify"

Field Value

Type	Description
string

User2UserGroup

The user to user group mapping table name.

Declaration

public const string User2UserGroup = "umbracoUser2UserGroup"

Field Value

Type	Description
string

UserData

The user data table name.

Declaration

public const string UserData = "umbracoUserData"

Field Value

Type	Description
string

UserGroup

The user group table name.

Declaration

public const string UserGroup = "umbracoUserGroup"

Field Value

Type	Description
string

UserGroup2App

The user group to application mapping table name.

Declaration

public const string UserGroup2App = "umbracoUserGroup2App"

Field Value

Type	Description
string

UserGroup2GranularPermission

The user group to granular permission mapping table name.

Declaration

public const string UserGroup2GranularPermission = "umbracoUserGroup2GranularPermission"

Field Value

Type	Description
string

UserGroup2Language

The user group to language mapping table name.

Declaration

public const string UserGroup2Language = "umbracoUserGroup2Language"

Field Value

Type	Description
string

UserGroup2Node

The user group to node mapping table name.

Declaration

[Obsolete("Scheduled for removal in Umbraco 18 as this table hasn't existed since Umbraco 14.")]
public const string UserGroup2Node = "umbracoUserGroup2Node"

Field Value

Type	Description
string

UserGroup2NodePermission

The user group to node permission mapping table name.

Declaration

[Obsolete("Scheduled for removal in Umbraco 18 as this table hasn't existed since Umbraco 14.")]
public const string UserGroup2NodePermission = "umbracoUserGroup2NodePermission"

Field Value

Type	Description
string

UserGroup2Permission

The user group to permission mapping table name.

Declaration

public const string UserGroup2Permission = "umbracoUserGroup2Permission"

Field Value

Type	Description
string

UserLogin

The user login table name.

Declaration

public const string UserLogin = "umbracoUserLogin"

Field Value

Type	Description
string

UserStartNode

The user start node table name.

Declaration

public const string UserStartNode = "umbracoUserStartNode"

Field Value

Type	Description
string

Webhook

The webhook table name.

Declaration

public const string Webhook = "umbracoWebhook"

Field Value

Type	Description
string

Webhook2ContentTypeKeys

The webhook to content type keys mapping table name.

Declaration

public const string Webhook2ContentTypeKeys = "umbracoWebhook2ContentTypeKeys"

Field Value

Type	Description
string

Webhook2Events

The webhook to events mapping table name.

Declaration

public const string Webhook2Events = "umbracoWebhook2Events"

Field Value

Type	Description
string

Webhook2Headers

The webhook to headers mapping table name.

Declaration

public const string Webhook2Headers = "umbracoWebhook2Headers"

Field Value

Type	Description
string

WebhookLog

The webhook log table name.

Declaration

public const string WebhookLog = "umbracoWebhookLog"

Field Value

Type	Description
string

WebhookRequest

The webhook request table name.

Declaration

public const string WebhookRequest = "umbracoWebhookRequest"

Field Value

Type	Description
string