Ends in:
0 DAY
22 HRS
15 MIN
48 SEC
Ends in:
0 D
22 H
15 M
48 S

Database Tables

This documentation describes all database tables and their purposes. You can read this documentation to get general knowledge of the database tables that come from each module.

Audit Logging Module

AbpAuditLogs

This table stores information about the audit logs in the application. Each record represents an audit log and tracks the actions performed in the application.

AbpAuditLogActions

This table stores information about the actions performed in the application, which are logged for auditing purposes.

Foreign Keys

Table Column Description
AbpAuditLogs Id Links each action to a specific audit log.

AbpEntityChanges

This table stores information about entity changes in the application, which are logged for auditing purposes.

Foreign Keys

Table Column Description
AbpAuditLogs Id Links each entity change to a specific audit log.

AbpEntityPropertyChanges

This table stores information about property changes to entities in the application, which are logged for auditing purposes.

Foreign Keys

Table Column Description
AbpEntityChanges Id Links each property change to a specific entity change.

Background Jobs Module

AbpBackgroundJobs

This table stores information about the background jobs in the application and facilitates their efficient management and tracking. Each entry in the table contains details of a background job, including the job name, arguments, try count, next try time, last try time, abandoned status, and priority.

Blogging Module

BlgUsers

This table stores information about the blog users. When a new identity user is created, a new record will be added to this table.

BlgBlogs

This table serves to store blog information and semantically separates the posts of each blog.

BlgPosts

This table stores information about the blog posts. You can query this table to get blog posts by blogs.

Foreign Keys

Table Column Description
BlgBlogs Id To associate the blog post with the corresponding blog.

BlgComments

This table stores information about the comments made on blog posts. You can query this table to get comments by posts.

Foreign Keys

Table Column Description
BlgPosts Id Links the comment to the corresponding blog post.
BlgComments Id Links the comment to the parent comment.

BlgTags

This table stores information about the tags. When a new tag is used, a new record will be added to this table. You can query this table to get tags by blogs.

BlgPostTags

This table is used to associate tags with blog posts in order to categorize and organize the content. You can query this table to get post tags by posts.

Foreign Keys

Table Column Description
BlgTags Id Links the post tag to the corresponding tag.
BlgPosts Id Links the post tag to the corresponding blog post.

Chat Module (PRO)

ChatUsers

This table stores chat users. When you create a new user, a new identity user is created and a new record is added to this table as well.

ChatConversations

This table stores information about online chat conversations between users. When a user starts a new conversation, a new record is added to this table.

ChatMessages

This table stores information about Chat messages, including the text, creator id, creation date, and other relevant details. It enables filtering and searching for messages, and tracking metrics such as views.

ChatUserMessages

This table can store information about the Chat user messages, including the message id, sender, receiver and other relevant information. It can also be used to filter and search messages, as well as to track the metrics associated with the messages, such as views and response time.

Foreign Keys

Table Column Description
ChatMessages Id Link to the message.

CMS Kit Module

CmsUsers

This table stores information about the CMS Kit module users. When a new identity user is created, a new record will be added to this table.

CmsBlogs

This table serves to store blog information and semantically separates the posts of each blog.

CmsBlogPosts

This table stores information about the blog posts. You can query this table to get blog posts by blogs.

Foreign Keys

Table Column Description
CmsUsers Id Links the blog post to the corresponding author.

CmsBlogFeatures

This table stores information about the blog features. You can query this table to get blog features by blogs.

CmsComments

This table is utilized by the CMS Kit Comment system to store comments made on the blog posts. You can query this table to get comments by posts.

CmsTags

This table stores information about the tags. When a new tag is used, a new record will be added to this table. You can query this table to get tags by blogs.

CmsEntityTags

This table is utilized by the Tag Management system to store tags and their relationship with various entities, thus enabling efficient categorization and organization of content. You can query this table to get entity tags by entities.

CmsGlobalResources

This table is a database table for the CMS Kit Global Resources system, allowing dynamic addition of global styles and scripts.

CmsMediaDescriptors

This table is utilized by the CMS kit module to manage media files by using the BlobStoring module.

CmsMenuItems

This table is used by the CMS Kit Menu system to manage and store information about dynamic public menus, including details such as menu item display names, URLs, and hierarchical relationships.

CmsPages

This table is utilized by the CMS Kit Page system to store dynamic pages within the application, including information such as page URLs, titles, and content.

CmsRatings

This table is utilized by the CMS Kit Rating system to store ratings made on blog posts. You can query this table to get ratings by posts.

CmsUserReactions

This table is utilized by the CMS Kit Reaction system to store reactions made on blog posts. You can query this table to get reactions by posts.

CMS Kit Pro Module (PRO)

CmsNewsletterPreferences

This table maintains the user's preferred settings for receiving newsletters through the CMS Kit Newsletters system. The information stored in this table helps the CMS system to deliver preferred and specific newsletters to each user, providing a more personalized experience for subscribers.

Foreign Keys

Table Column Description
CmsNewsletterRecords Id Link to the newsletter record.

CmsNewsletterRecords

This table stores information about users that are registered for the newsletter, such as their email addresses. You can query the email addresses of users registered for the newsletter.

CmsPolls

This table stores information about the polls created using the CMS Kit Poll system. Polls can be used to gather user feedback or opinions on a topic, and this table stores details such as the poll question and vote count.

CmsPollOptions

This table stores information about the poll options that are associated with each poll. The CMS kit provides a poll system for creating and managing online polls, and this table helps to keep track of the different options for each poll.

Foreign Keys

Table Column Description
CmsPolls Id To match the poll option with the poll.

CmsPollUserVotes

This table stores the user votes for the polls that are managed by the CMS Kit Module. It allows to keep track of the users who have voted in a particular poll and their selected options.

CmsShortenedUrls

This table stores URL mappings in the system and is used by the URL Forwarding feature of the CMS Kit Module. The URL forwarding system allows the creation of URLs that redirect to other pages or external websites.

Docs Module

DocsProjects

This table stores project information to categorize documents according to different projects.

DocsDocuments

This table retrieves the document if it's not found in the cache. The documentation is being updated when the content is retrieved from the database.

DocsDocumentContributors

This table stores information about the contributors of the documents. You can query this table to get document contributors by documents.

Foreign Keys

Table Column Description
DocsDocuments Id Links the document contributor to the corresponding document.

Feature Management Module

AbpFeatureGroups

This table stores information about the feature groups in the application. For example, you can group all the features in the AbpFeatures table related to the Identity module under the Identity group.

AbpFeatures

This table stores information about the features in the application. You can use the Name column to link each feature with its corresponding feature value in the AbpFeatureValues table, so that you can easily manage and organize the features.

AbpFeatureValues

This table stores the values of the features for different providers. You can use the Name column to link each feature value with its corresponding feature in the AbpFeatures table, so that you can easily manage and organize the features.

File Management Module (PRO)

FmDirectoryDescriptors

This table is utilized by the File Management system to manage directories by using the BlobStoring module.

Foreign Keys

Table Column Description
FmDirectories Id Links the directory descriptor with the directory.

FmFileDescriptors

This table is used by the File Management system to store information about the files and directories in the application, including metadata such as the file name, size, and creation date.

Foreign Keys

Table Column Description
FmDirectoryDescriptors Id Links the file descriptor with the directory.

Form Module (PRO)

FrmForms

This table stores information related to forms created using the Forms Module.

FrmQuestions

This table is used to store information about the questions used in the Forms Module, such as the type of the question, the text of the question. This information is used to build and display forms to the user for data collection and analysis.

FrmChoices

This table stores the choices or options for a form question in the Forms Module. The table is used to store the information needed to display choices in a form question, such as the text and value.

Foreign Keys

Table Column Description
FrmQuestions Id Links the choice with the question.

FrmFormResponses

This table holds information on the results that the users have responded with to the forms. It can be used to calculate statistics such as how many people have answered a form.

FrmAnswers

This table stores the answers provided by application users for a certain form. It can be used to calculate statistics, such as how many people have responded to a particular form question.

Foreign Keys

Table Column Description
FrmFormResponses Id Links the answer with the form response.

Gdpr Module (PRO)

GdprRequests

This table stores requests made by users to access or delete their personal data collected by the application as part of the GDPR compliance.

GdprInfo

This table holds information related to the personal data that has been collected by modules/applications. This information is used when a user requests her/his personal data. Also, when a user requests to delete their personal data, related records with the user are removed from this table.

Foreign Keys

Table Column Description
GdprRequests Id Links the GDPR information with the GDPR request.

Identity Module

AbpUsers

This table stores information about the identity users in the application.

AbpRoles

This table stores information about the roles in the application. Roles are used to manage and control access to different parts of the application by assigning permissions and claims to roles and then assigning those roles to users. This table is important for managing and organizing the roles in the application, and for defining the access rights of the users.

AbpClaimTypes

This table stores information about the claim types used in the application. You can use the Name, Regex columns to filter the claim types by name, and regex pattern respectively, so that you can easily manage and track the claim types in the application.

AbpLinkUsers

This table is useful for linking multiple user accounts across different tenants or applications to a single user, allowing them to easily switch between their accounts.

AbpUserClaims

This table can manage user-based access control by allowing to assign claims to users, which describes the access rights of the individual user.

Foreign Keys

Table Column Description
AbpUsers Id Links the user claim to the corresponding user.

AbpUserLogins

This table can store information about the user's external logins such as login with Facebook, Google, etc. and it can also be used to track the login history of users.

Foreign Keys

Table Column Description
AbpUsers Id Links the user login to the corresponding user.

AbpUserRoles

This table can manage user-based access control by allowing to assign roles to users, which describe the access rights of the individual user.

Foreign Keys

Table Column Description
AbpUsers Id Links the user role to the corresponding user.
AbpRoles Id Links the user role to the corresponding role.

AbpUserTokens

This table can store information about user's refresh tokens, access tokens and other tokens used in the application. It can also be used to invalidate or revoke user tokens.

Foreign Keys

Table Column Description
AbpUsers Id Links the user token to the corresponding user.

AbpOrganizationUnits

This table is useful for creating and managing a hierarchical structure of the organization, allowing to group users and assign roles based on the organization structure. You can use the Code, ParentId columns to filter the organization units by code and parent id respectively, so that you can easily manage and track the organization units in the application.

Foreign Keys

Table Column Description
AbpOrganizationUnits ParentId Links the organization unit to its parent organization unit.

AbpOrganizationUnitRoles

This table is useful for managing role-based access control at the level of organization units, allowing to assign different roles to different parts of the organization structure. You can use the OrganizationUnitId, RoleId columns to filter the roles by organization unit id and role id respectively, so that you can easily manage and track the roles assigned to organization units in the application.

Foreign Keys

Table Column Description
AbpOrganizationUnits Id Links the organization unit role to the corresponding organization unit.
AbpRoles Id Links the organization unit role to the corresponding role.

AbpUserOrganizationUnits

This table stores information about the organization units assigned to the users in the application. This table can manage user-organization unit relationships, and to group users based on the organization structure.

Foreign Keys

Table Column Description
AbpUsers Id Links the user organization unit to the corresponding user.
AbpOrganizationUnits Id Links the user organization unit to the corresponding organization unit.

AbpRoleClaims

This table is useful for managing role-based access control by allowing to assign claims to roles, which describes the access rights of the users that belong to that role.

Foreign Keys

Table Column Description
AbpRoles Id Links the role claim to the corresponding role.

AbpSecurityLogs

This table logs important operations and changes related to user accounts, allowing users to save the security logs for future reference.

IdentityServer

IdentityServerApiResources

This table can store information about the API resources, including the resource name, display name, description, and other relevant information. It can also be used to define the scopes, claims, and properties associated with the API resources, which are then used to control access to protected resources.

IdentityServerIdentityResources

This table can store information about the identity resources, including the name, display name, description, and enabled status.

IdentityServerClients

This table can store information about the clients, including the client id, client name, client URI and other relevant information. It can also be used to define the scopes, claims, and properties associated with the clients, which are then used to control access to protected resources.

IdentityServerApiScopes

This table can store information about the API scopes, including the scope name, display name, description, and other relevant information. It can also be used to define the claims and properties associated with the API scopes, which are then used to control access to protected resources.

IdentityServerApiResourceClaims

This table can store information about the claims of an API resource, including the claim type and API resource id.

Foreign Keys

Table Column Description
IdentityServerApiResources Id Links the claim to the corresponding API resource.

IdentityServerIdentityResourceClaims

This table can store information about the claims of an identity resource, including the claim type and identity resource id.

Foreign Keys

Table Column Description
IdentityServerIdentityResources Id Links the claim to the corresponding identity resource.

IdentityServerClientClaims

This table can store information about the claims of a client, including the claim type, claim value and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the claim to the corresponding client.

IdentityServerApiScopeClaims

This table can store information about the claims of an API scope, including the claim type and API scope id.

Foreign Keys

Table Column Description
IdentityServerApiScopes Id Links the claim to the corresponding API scope.

IdentityServerApiResourceProperties

This table can store information about properties, including the property key and value, and the associated API resource. These properties can store additional metadata or configuration information related to the API resources.

Foreign Keys

Table Column Description
IdentityServerApiResources Id Links the property to the corresponding API resource.

IdentityServerIdentityResourceProperties

This table can store information about properties, including the property key and value, and the associated identity resource. These properties can store additional metadata or configuration information related to the identity resources.

Foreign Keys

Table Column Description
IdentityServerIdentityResources Id Links the property to the corresponding identity resource.

IdentityServerClientProperties

This table can be store information about the properties of a client, including the key, value and client id. These properties can store additional metadata or configuration information related to the clients.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the property to the corresponding client.

IdentityServerApiScopeProperties

This table can store information about the properties of an API scope, including the key, value and API scope id. These properties can store additional metadata or configuration information related to the API scopes.

Foreign Keys

Table Column Description
IdentityServerApiScopes Id Links the property to the corresponding API scope.

IdentityServerApiResourceScopes

This table can store information about the scopes of an API resource, including the scope name and API resource id.

Foreign Keys

Table Column Description
IdentityServerApiResources Id Links the scope to the corresponding API resource.

IdentityServerClientScopes

This table can store information about the scopes of a client, including the scope and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the scope to the corresponding client.

IdentityServerApiResourceSecrets

This table can store information about the secrets of an API resource, including the secret value, expiration date, and API resource id.

Foreign Keys

Table Column Description
IdentityServerApiResources Id Links the secret to the corresponding API resource.

IdentityServerClientSecrets

This table can store information about the secrets of a client, including the secret value, expiration date, and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the secret to the corresponding client.

IdentityServerClientCorsOrigins

This table can store information about the CORS origins of a client, including the origin and client id. It can also be used to manage and validate the CORS origins of a client.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the CORS origin to the corresponding client.

IdentityServerClientGrantTypes

This table can store information about the grant types of a client, including the grant type and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the grant type to the corresponding client.

IdentityServerClientIdPRestrictions

This table can store information about the identity provider restrictions of a client, including the identity provider and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the identity provider restriction to the corresponding client.

IdentityServerClientPostLogoutRedirectUris

This table can store information about the post logout redirect URIs of a client, including the post logout redirect URI and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the post logout redirect URI to the corresponding client.

IdentityServerClientRedirectUris

This table can store information about the redirect URIs of a client, including the redirect URI and client id.

Foreign Keys

Table Column Description
IdentityServerClients Id Links the redirect URI to the corresponding client.

IdentityServerDeviceFlowCodes

This table can store information about the device flow codes, including the user code, device code, subject id, client id, creation time, expiration, data and session id.

IdentityServerPersistedGrants

This table can store information about the persisted grants, including the key, type, subject id, client id, creation time, expiration, and data.

Language Management Module (PRO)

AbpLanguages

This table is important for supporting multiple languages in an application and for providing a better user experience by allowing users to switch between different languages.

AbpLanguageTexts

This table is important for providing a better user experience by allowing the application to display text in the user's preferred language.

OpenIddict

OpenIddictApplications

This table can store information about the OpenID Connect applications, including the client id, client secret, redirect URI, and other relevant information. It can also be used to authenticate and authorize clients using OpenID Connect protocol.

OpenIddictAuthorizations

This table stores the OpenID Connect authorization data in the application. It can also be used to manage and validate the authorization grants issued to clients and users.

Foreign Keys

Table Column Description
OpenIddictApplications Id Links the authorization to the corresponding application.

OpenIddictTokens

This table can store information about the OpenID Connect tokens, including the token payload, expiration, type, and other relevant information. It can also be used to manage and validate the tokens issued to clients and users, such as access tokens and refresh tokens, and to control access to protected resources.

Foreign Keys

Table Column Description
OpenIddictApplications Id Links the token to the corresponding application.
OpenIddictAuthorizations Id Links the token to the corresponding authorization.

OpenIddictScopes

This table can store information about the OpenID Connect scopes, including the name and description of the scope. It can also be used to define the permissions or access rights associated with the scopes, which are then used to control access to protected resources.

Payment Module (PRO)

PayPaymentRequests

This table stores information about the payment requests initiated by users.

PayPaymentRequestProducts

This table keeps track of the products associated with each payment request. You can use this table to collect metrics, such as how many products have been bought in a time interval.

Foreign Keys

Table Column Description
PayPaymentRequests Id Links the payment request product with the payment request.

PayPlans

This table contains information about the different plans offered within the application for recurring payments through the Payment Module.

PayGatewayPlans

This table maps the plans offered in the application to the corresponding plans available in the integrated payment gateway to process recurring payments.

Foreign Keys

Table Column Description
PayPlans Id Links the gateway plan with the plan.

Permission Management

AbpPermissionGroups

This table is important for managing and organizing the permissions in the application, by grouping them into logical categories.

AbpPermissions

This table is important for managing and controlling access to different parts of the application and for defining the granular permissions that make up the larger permissions or roles.

AbpPermissionGrants

The table stores and manage the permissions in the application and to keep track of permissions that are granted, to whom and when. Columns such as Name, ProviderName, ProviderKey, TenantId can be used to filter the granted permissions by name, provider name, provider key, and tenant id respectively, so that you can easily manage and track the granted permissions in the application.

SaaS Module (PRO)

SaasEditions

This table stores information about the different editions of the application. Each record represents an edition and contains information about the edition, such as the name and other details.

SaasTenants

This table stores information about the tenants. Each record represents a tenant and contains information about the tenant, such as the name, password, and all other relevant details.

SaasTenantConnectionStrings

This table stores information about the tenant database connection strings. When you define a connection string for a tenant, a new record will be added to this table. You can query this database to get connection strings by tenants.

Foreign Keys

Table Column Description
SaasTenants Id Links the connection string with the tenant.

Setting Management

AbpSettings

This table stores key-value pairs of settings for the application, and it allows dynamic configuration of the application without the need for recompilation.

Tenant Management Module

AbpTenants

This table stores information about the tenants. Each record represents a tenant and contains information about the tenant, such as name and other details.

AbpTenantConnectionStrings

This table stores information about the tenant database connection strings. When you define a connection string for a tenant, a new record will be added to this table. You can query this database to get connection strings by tenants.

Foreign Keys

Table Column Description
AbpTenants Id The Id column in the AbpTenants table is used to associate the tenant connection string with the corresponding tenant.

Text Template Management Module (PRO)

AbpTextTemplateContents

This table can store reusable text templates that can be easily referenced and rendered by the application at runtime. Each record in the table represents a text template content and allows to manage and track the text template contents effectively.

Others

AbpBlobContainers

This table is important for providing a better user experience by allowing the application to support multiple containers and providing BLOB-specific features.

AbpBlobs

This table stores the binary data of BLOBs (binary large objects) in the application. Each BLOB is related to a container in the AbpBlobContainers table, where the container name, tenant id and other properties of the container can be found.

Foreign Keys

Table Column Description
AbpBlobContainers Id Links the BLOB to the corresponding container.

AbpLocalizationResources

This table stores the localization resources for the application. This table is important for providing a better user experience by allowing the application to support multiple resources and providing localized text and other localization-specific features.

AbpLocalizationTexts

The table contains the resource name, culture name, and a json encoded value which holds the key-value pair of localization text. It allows for efficient storage and management of localization texts and allows for easy update or addition of new translations for specific resources and cultures.

Contributors


Last updated: August 26, 2024 Edit this page on GitHub

Was this page helpful?

Please make a selection.

To help us improve, please share your reason for the negative feedback in the field below.

Please enter a note.

Thank you for your valuable feedback!

Please note that although we cannot respond to feedback, our team will use your comments to improve the experience.

In this document
Community Talks

What’s New with .NET 9 & ABP 9?

21 Nov, 17:00
Online
Watch the Event
Mastering ABP Framework Book
Mastering ABP Framework

This book will help you gain a complete understanding of the framework and modern web application development techniques.

Learn More