Confluence Data Model
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.xmlfiles which you will find in the main Confluence JAR file (<CONFLUENCE-INSTALLATION>\confluence\WEB-INF\lib\confluence-5.1.1.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
Detailed diagrams
The following SVG images (Scalable Vector Graphics) include all the tables in the Confluence database. Click the links below to open the images in your browser, or download the SVG files for later use. You can use the browser's zoom (Ctrl++ or Cmd++) to see more detail in the diagrams:
- ConfluenceTables-KeysOnly.svg – Shows all tables, with primary keys only for each table.
- ConfluenceTables-AllColumns.svg – Shows all tables, and all columns for each table.
Overview diagram
This image shows the core tables. Note that the image is very large. You may need to download it (right-click on the image) and view it in an image viewer. Alternatively, use the SVG images linked in the previous section.
Database tables and references
Expand the link below to see a table of the primary and foreign keys for each table.
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.
| Table | Description |
|---|---|
cwd_user | Information for each user in Confluence. |
cwd_group | The groups to which users can belong. |
cwd_membership | Mapping the membership of users to groups. |
| The user directories in your Confluence site. Examples of directories are the Confluence internal directory, or an LDAP directory. |
cwd_application | The 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.
| Table | Description |
|---|---|
attachmentdata | The binary data for attached files. This table is only used when Confluence is configured to store attachments in the database. Otherwise, attachments are stored in the local file system. |
| Metadata for the files attached to Confluence pages. |
bodycontent | The content of Confluence pages. No version information or other metadata is stored here. That is all in the content table. |
content | A persistence table for the ContentEntityObject class of objects. The subclass is indicated by the contenttype column. |
content_label | Arbitrary text labels for content. |
label | The other half of the content_label system. |
| Content-level permissions objects. |
content_perm_set | A one-to-many mapping for content items and their permissions, with added metadata. |
pagetemplates | The back end of the templates feature. |
likes | The pages and other content liked by a particular user. |
follow_connections | A mapping of users who are following other users. |
Clustering
The following table contains information about clustered Confluence sites.
| Table | Description |
|---|---|
| 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. |
System information
These tables store data related to the status and configuration of the Confluence site.
| Table | Description |
|---|---|
| Used by the upgrade system to determine what to expect from the database, so as to negotiate upgrades. |
plugindata | A 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. |
Spaces
This table is related to the management of spaces.
| Table | Description |
|---|---|
| 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.
| Table | Description |
|---|---|
| The custom display templates used to customise Velocity layouts. |
Miscellaneous
This section includes other tables worth commenting on.
| Table | Description |
|---|---|
| Arbitrary association of entities and properties. |
bandana | A 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. |
extrnlnks | Referral 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. |
indexqueueentries | Manages 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. |
keystore | Used by the trusted apps framework to store the server's private key, and other servers' public keys. |
links | Tracks links within the server (that is, across and within spaces). |
notifications | Stores page- and space-level watches. |
trackbacklinks | Trackback links. |
confancestors | Used to speed up permissions checks, by allowing quick lookup of all a page's ancestors. |