Confluence Data Model

Still need help?

The Atlassian Community is here for you.

Ask the community

This document provides a diagram of the Confluence schema and a conceptual overview of the data model.

Notes:

  • The Hibernate mapping files are the authoritative reference for the Confluence data model. These are the *.hbm.xml files which you will find in the main Confluence JAR file (<CONFLUENCE-INSTALLATION>\confluence\WEB-INF\lib\confluence-x.x.x.jar).
  • The tables, columns and other attributes are likely to change with each major release of Confluence. To find the exact DDL of your Confluence site, please run a query after installation.

On this page:

Database diagrams

We find that creating your own visualization of the Confluence database can be useful if you want to  focus on particular tables or relationships. There are a number of tools you can use to create a visualization. Your own database tool may have options to do this.

View our visualization (excludes some tables, including ActiveObjects tables)

We used DbVisualizer. See Viewing Table Relationships in the DbVis documentation to find out how it's done.  

Database tables and references

Expand the link below to see a table of the primary and foreign keys for each table.

Click here to show/hide the table...

Note that Marketplace apps can also add tables to your database.

Primary Key Table NamePrimary Key Column NameForeign Key Table NameForeign Key Column NameForeign Key NamePrimary Key Name
AUDITRECORDAUDITRECORDIDAUDIT_AFFECTED_OBJECTAUDITRECORDIDFK_AFFECTED_OBJECT_RECORDPRIMARY_KEY_D
AUDITRECORDAUDITRECORDIDAUDIT_CHANGED_VALUEAUDITRECORDIDFK_CHANGED_VALUE_RECORDPRIMARY_KEY_D
CONTENTCONTENTIDATTACHMENTDATAATTACHMENTIDFKJNH4YVWEN0176QSVH4RPSRY2JPRIMARY_KEY_6
CONTENTCONTENTIDBODYCONTENTCONTENTIDFKMBYIAYESFP1EIQ6GMOL3MK3YLPRIMARY_KEY_6
CONTENTCONTENTIDCONFANCESTORSDESCENDENTIDFKLMHSIPSWOL8IMEQSG906IH62XPRIMARY_KEY_6
CONTENTCONTENTIDCONFANCESTORSANCESTORIDFKSQB1AF9H7FVQTGY73O8JDCUUEPRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPARENTCOMMENTIDFKAL6O8XWYPD4MDGID9B9NW1Q51PRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPARENTCCIDFKFIYHKA48C7E776QJ90KLBPM9QPRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPREVVERFKK6KBB7SUQELOJ82NX7XDCD803PRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPARENTIDFKOXTT893WEUJKYH0IICOXSM37VPRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPAGEIDFKWJYN6091Q3L1GL7BH143MA2APRIMARY_KEY_6
CONTENTCONTENTIDCONTENT_LABELCONTENTIDFKI8CVAHSU6D2Y285VTRP4NHC3WPRIMARY_KEY_6
CONTENTCONTENTIDCONTENT_PERM_SETCONTENT_IDFK2BUUNK1HOR0I3K0M3NT03HW1WPRIMARY_KEY_6
CONTENTCONTENTIDCONTENT_RELATIONSOURCECONTENTIDFKE2A00URQYXMYAJ3JOP48UB8QDPRIMARY_KEY_6
CONTENTCONTENTIDCONTENT_RELATIONTARGETCONTENTIDFKIPR00838MKLN699CIMD7RG17XPRIMARY_KEY_6
CONTENTCONTENTIDCONTENTPROPERTIESCONTENTIDFK3FLY21XFK13RQH63TXW2T6K2VPRIMARY_KEY_6
CONTENTCONTENTIDEXTRNLNKSCONTENTIDFK5V5LW9X88VM27RVUBSC130NJYPRIMARY_KEY_6
CONTENTCONTENTIDIMAGEDETAILSATTACHMENTIDFK2301QICIUQ6SC32JAJ8TYSG3SPRIMARY_KEY_6
CONTENTCONTENTIDLIKESCONTENTIDFKBDOIWI70I7O3TC7HPBU4VNLMYPRIMARY_KEY_6
CONTENTCONTENTIDLINKSCONTENTIDFKN8MYCKO8FRERNE7BRH5NR1CSRPRIMARY_KEY_6
CONTENTCONTENTIDNOTIFICATIONSCONTENTIDFK_NOTIFICATIONS_CONTENTPRIMARY_KEY_6
CONTENTCONTENTIDSPACESSPACEDESCIDFK7NDEWMRL3HQCPWC8EYDN9MV8JPRIMARY_KEY_6
CONTENTCONTENTIDSPACESHOMEPAGEFKJ4CU5838AQCBW57WY7CKT0T7OPRIMARY_KEY_6
CONTENTCONTENTIDTRACKBACKLINKSCONTENTIDFK1TO6OMJL8NHEVCJBVPT3ED7NTPRIMARY_KEY_6
CONTENTCONTENTIDUSERCONTENT_RELATIONTARGETCONTENTIDFKPWGL85A266IIE5I0ADU8BDBCVPRIMARY_KEY_6
CONTENT_PERM_SETIDCONTENT_PERMCPS_IDFKDE5WL1CUR1SE9281GC0DSAWTBPRIMARY_KEY_BF
CWD_APP_DIR_MAPPINGIDCWD_APP_DIR_GROUP_MAPPINGAPP_DIR_MAPPING_IDFK_APP_DIR_GROUP_MAPPINGPRIMARY_KEY_2A
CWD_APP_DIR_MAPPINGIDCWD_APP_DIR_OPERATIONAPP_DIR_MAPPING_IDFK_APP_DIR_MAPPINGPRIMARY_KEY_2A
CWD_APPLICATIONIDCWD_APP_DIR_GROUP_MAPPINGAPPLICATION_IDFK_APP_DIR_GROUP_APPPRIMARY_KEY_5
CWD_APPLICATIONIDCWD_APP_DIR_MAPPINGAPPLICATION_IDFKSTEKJ41875RGSW8OTFFRAYHPLPRIMARY_KEY_5
CWD_APPLICATIONIDCWD_APPLICATION_ADDRESSAPPLICATION_IDFK_APPLICATION_ADDRESSPRIMARY_KEY_5
CWD_APPLICATIONIDCWD_APPLICATION_ATTRIBUTEAPPLICATION_IDFK_APPLICATION_ATTRIBUTEPRIMARY_KEY_5
CWD_DIRECTORYIDCWD_APP_DIR_GROUP_MAPPINGDIRECTORY_IDFK_APP_DIR_GROUP_DIRPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_APP_DIR_MAPPINGDIRECTORY_IDFK_APP_DIR_DIRPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_DIRECTORY_ATTRIBUTEDIRECTORY_IDFK_DIRECTORY_ATTRIBUTEPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_DIRECTORY_OPERATIONDIRECTORY_IDFK_DIRECTORY_OPERATIONPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_GROUPDIRECTORY_IDFK_DIRECTORY_IDPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_GROUP_ATTRIBUTEDIRECTORY_IDFK_GROUP_ATTR_DIR_IDPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_USERDIRECTORY_IDFK_USER_DIR_IDPRIMARY_KEY_AA
CWD_DIRECTORYIDCWD_USER_ATTRIBUTEDIRECTORY_IDFK_USER_ATTR_DIR_IDPRIMARY_KEY_AA
CWD_GROUPIDCWD_GROUP_ATTRIBUTEGROUP_IDFK_GROUP_ATTR_ID_GROUP_IDPRIMARY_KEY_C
CWD_GROUPIDCWD_MEMBERSHIPCHILD_GROUP_IDFK_CHILD_GRPPRIMARY_KEY_C
CWD_GROUPIDCWD_MEMBERSHIPPARENT_IDFK_PARENT_GRPPRIMARY_KEY_C
CWD_USERIDCWD_MEMBERSHIPCHILD_USER_IDFK_CHILD_USERPRIMARY_KEY_A3
CWD_USERIDCWD_USER_ATTRIBUTEUSER_IDFK_USER_ATTRIBUTE_ID_USER_IDPRIMARY_KEY_A3
CWD_USERIDCWD_USER_CREDENTIAL_RECORDUSER_IDFK2RFDH2AP00B8MHOLDSY1B785BPRIMARY_KEY_A3
EXTERNAL_ENTITIESIDEXTERNAL_MEMBERSEXTENTITYIDFKADLKFU6A03U8F8BS82LM4QLG1PRIMARY_KEY_6D
GROUPSIDEXTERNAL_MEMBERSGROUPIDFK47K0FUDQNBNSBW0YW44UCSU2RPRIMARY_KEY_7D
GROUPSIDLOCAL_MEMBERSGROUPIDFKI71UOMCF4F9SESIBDHSMFDBGHPRIMARY_KEY_7D
KEYSTOREKEYIDTRUSTEDAPPPUBLIC_KEY_IDFKM7N581Y7GROA49TYGAPKMNFIVPRIMARY_KEY_4D
LABELLABELIDCONTENT_LABELLABELIDFK91V3V5NEMR532QQ4GLA9SJ9TFPRIMARY_KEY_44
LABELLABELIDNOTIFICATIONSLABELIDFK4TCCRJAMRJVMD2AOGL3HKLPFJPRIMARY_KEY_44
OS_GROUPIDOS_USER_GROUPGROUP_IDFKM2O7638OJNKI05I3U0N5OEPOPPRIMARY_KEY_DB
OS_USERIDOS_USER_GROUPUSER_IDFK6W5BWO7289K947EE5FWEC30JVPRIMARY_KEY_E6
PAGETEMPLATESTEMPLATEIDCONTENT_LABELPAGETEMPLATEIDFK28KIFOKT21QD9GES0Q0WV0FB9PRIMARY_KEY_BC
PAGETEMPLATESTEMPLATEIDPAGETEMPLATESPREVVERFK4WGWY1DQCI8RCWAD4TNQBGLT8PRIMARY_KEY_BC
SPACESSPACEIDCONTENTSPACEIDFKLMWEU06NFT59G7MW1I1MYORYSPRIMARY_KEY_92
SPACESSPACEIDNOTIFICATIONSSPACEIDFKMQE1PHE52XWQC4HK4IB8P9EH6PRIMARY_KEY_92
SPACESSPACEIDPAGETEMPLATESSPACEIDFK18A1D37PVQ2O9HU5X3TPS97MXPRIMARY_KEY_92
SPACESSPACEIDSPACEPERMISSIONSSPACEIDFKBI3X723M8FBGOKO3S84F9ODDLPRIMARY_KEY_92
TRUSTEDAPPTRUSTEDAPPIDTRUSTEDAPPRESTRICTIONTRUSTEDAPPIDFKJOFK5643721EFTOW3NJWR73AAPRIMARY_KEY_DDB
USER_MAPPINGUSER_KEYCONTENTCREATORFK_CONTENT_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENTLASTMODIFIERFK_CONTENT_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENTUSERNAMEFK_CONTENT_USERNAMEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_LABELOWNERFK_CONTENT_LABEL_OWNERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_PERMCREATORFK_CONTENT_PERM_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_PERMLASTMODIFIERFK_CONTENT_PERM_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_PERMUSERNAMEFK_CONTENT_PERM_USERNAMEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_RELATIONCREATORFK_C2CRELATION_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYCONTENT_RELATIONLASTMODIFIERFK_C2CRELATION_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYEXTRNLNKSCREATORFK_EXTRNLNKS_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYEXTRNLNKSLASTMODIFIERFK_EXTRNLNKS_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYFOLLOW_CONNECTIONSFOLLOWEEFK_FOLLOW_CONNECTIONS_FOLLOWEEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYFOLLOW_CONNECTIONSFOLLOWERFK_FOLLOW_CONNECTIONS_FOLLOWERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYLABELOWNERFK_LABEL_OWNERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYLIKESUSERNAMEFK_LIKES_USERNAMEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYLINKSCREATORFK_LINKS_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYLINKSLASTMODIFIERFK_LINKS_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYLOGININFOUSERNAMEFK_LOGININFO_USERNAMEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYNOTIFICATIONSCREATORFK_NOTIFICATIONS_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYNOTIFICATIONSLASTMODIFIERFK_NOTIFICATIONS_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYNOTIFICATIONSUSERNAMEFK_NOTIFICATIONS_USERNAMEPRIMARY_KEY_13
USER_MAPPINGUSER_KEYPAGETEMPLATESCREATORFK_PAGETEMPLATES_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYPAGETEMPLATESLASTMODIFIERFK_PAGETEMPLATES_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYSPACEPERMISSIONSCREATORFK_SPACEPERMISSIONS_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYSPACEPERMISSIONSLASTMODIFIERFK_SPACEPERMISSIONS_LASTMODIFIPRIMARY_KEY_13
USER_MAPPINGUSER_KEYSPACEPERMISSIONSPERMUSERNAMEFK_SPACEPERMISSIONS_PERMUSERNAPRIMARY_KEY_13
USER_MAPPINGUSER_KEYSPACESCREATORFK_SPACES_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYSPACESLASTMODIFIERFK_SPACES_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYTRACKBACKLINKSCREATORFK_TRACKBACKLINKS_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYTRACKBACKLINKSLASTMODIFIERFK_TRACKBACKLINKS_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSER_RELATIONSOURCEUSERFK_RELATION_U2USUSERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSER_RELATIONTARGETUSERFK_RELATION_U2UTUSERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSER_RELATIONCREATORFK_U2URELATION_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSER_RELATIONLASTMODIFIERFK_U2URELATION_LASTMODIFIERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSERCONTENT_RELATIONSOURCEUSERFK_RELATION_U2CUSERPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSERCONTENT_RELATIONCREATORFK_U2CRELATION_CREATORPRIMARY_KEY_13
USER_MAPPINGUSER_KEYUSERCONTENT_RELATIONLASTMODIFIERFK_U2CRELATION_LASTMODIFIERPRIMARY_KEY_13
USERSIDLOCAL_MEMBERSUSERID

FKRCUYOPTNAD1POS41GP1B1F3PI

PRIMARY_KEY_4D4

The following sections describe the principal tables involved in each logical area of Confluence – authentication, content, system information, and so on.

Authentication

This section describes the tables involved in user authentication, which is implemented via the Atlassian Crowd framework embedded in Confluence.

TableDescription
cwd_userInformation for each user in Confluence.
cwd_groupThe groups to which users can belong.
cwd_membershipMapping the membership of users to groups.

cwd_directory

The user directories in your Confluence site. Examples of directories are the Confluence internal directory, or an LDAP directory.
cwd_applicationThe applications (Jira, Confluence, and so on) defined in the authentication framework.

Content

This section describes the tables involved in storing content. Content is the information that Confluence users are storing and sharing.

TableDescription
attachmentdataThe binary data for attached files. This table is only used in older Confluence versions where Confluence was configured to store attachments in the database. Otherwise, attachments are stored in the local file system.

attachments

Metadata for the files attached to Confluence pages.
bodycontentThe content of Confluence pages. No version information or other metadata is stored here. That is all in the content table.
contentA persistence table for the ContentEntityObject class of objects. The subclass is indicated by the contenttype column.
content_labelArbitrary text labels for content.
labelThe other half of the content_label system.

content_perm

Content-level permissions objects.
content_perm_setA one-to-many mapping for content items and their permissions, with added metadata.
pagetemplatesThe back end of the templates feature.
likesThe pages and other content liked by a particular user.
follow_connectionsA mapping of users who are following other users.

Clustering

The following table contains information about clustered Confluence sites.

TableDescription

clustersafety

Normally, this table only contains one row. The value of the safetynumber is what Confluence uses to find out whether another Confluence site is sharing its database without being part of the cluster.
journalentry
The journal service keeps the search index in synch across each Confluence node.

System information

These tables store data related to the status and configuration of the Confluence site.

TableDescription

confversion

Used by the upgrade system to determine what to expect from the database, so as to negotiate upgrades.
plugindataA record of the plugins that have been installed, and when.
data is a blob of the actual plugin JAR file. This is principally cluster-related.
diagnosticalerts
The diagnostics tool continuously checks for symptoms or behaviours that we know may contribute to problems in your site. Events are stored for a limited amount of time in this table.

Spaces

This table is related to the management of spaces.

TableDescription

spaces

Information about the spaces themselves: key, human-friendly name and numeric ID.

Appearance

The following table contains information about the look and feel of your Confluence site.

TableDescription

decorator

The custom display templates used to customize Velocity layouts.

Miscellaneous

This section includes other tables worth commenting on.

TableDescription

os_propertyentry

Arbitrary association of entities and properties.
bandanaA catch-all persistence layer. This table contains things like user settings and space- and global-level configuration data, and is used as storage by plugins such as the Dynamic Task List plugin. Essentially, for storing arbitrary data that doesn't fit anywhere else.
extrnlnksReferral links.
hibernate_unique_key

Used by the high/low ID generator – the subsystem which generates our primary keys.

If you interfere with this table, you may not be able to create objects in Confluence.

indexqueueentriesManages full-content indexing across the system. The table generally contains the last 12 hours (approximately) of updates, to allow re-syncing of cluster nodes after restarts.
keystoreUsed by the trusted apps framework to store the server's private key, and other servers' public keys.
linksTracks links within the server (that is, across and within spaces).
notificationsStores page- and space-level watches.
trackbacklinksTrackback links.
confancestorsUsed to speed up permissions checks, by allowing quick lookup of all a page's ancestors.
Last modified on Mar 7, 2019

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.