Questions for Confluence Data Model
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
This guide is for informational purposes and is not eligible for support as part of the Atlassian Support Offerings. If you have any questions about the information on this page, please reach out to our Atlassian Community for help.
Summary
Most of the information used by Questions for Confluence is stored in the out-of-the-box Confluence Data Model, mainly in the CONTENT and BODYCONTENT tables.
However, few AO tables are also created to store part of the information used by this plugin. The AO tables for Questions for Confluence will follow the syntax of AO_B1DBB9_TABLENAME as explained in Atlassian Developer > Table names
Check KB List of Confluence Server/Data Center Active Objects (AO) table names and vendors for full list of Plugins with the AO tables associated
This document provides a diagram of the Questions for Confluence schema and a conceptual overview of the data model.
Database tables and references
Expand the link below to see a table of the foreign keys for each table.
Confluence Tables
Question for Confluence holds additional details in the PLUGINKEY column of the CONTENT table, depending on the item being stored.
This section describes the different content involved and how to find the related information:
Table | Column CONTENTYPE | Column PLUGINKEY | Description |
|---|---|---|---|
CONTENT | CUSTOM | com.atlassian.confluence.plugins.confluence-questions:question | Keeps the question titles in the title column. The question description is stored in the BODYCONTENT table using the contentid column as reference |
com.atlassian.confluence.plugins.confluence-questions:question-draft | When a question is asked, a draft entry is created automatically. If the question is not asked, it will be empty. | ||
com.atlassian.confluence.plugins.confluence-questions:answers | Keeps a reference to the answer provided by one user. The answer itself is stored in the BODYCONTENT table using the contentid column as reference | ||
com.atlassian.confluence.plugins.confluence-questions:answers-draft | When a question is about to be answered, a draft entry is created automatically. If the answer is not saved, it will be empty. | ||
com.atlassian.confluence.plugins.confluence-questions:topic-metadata | List the topics created to categorize the questions. Additionally, they are also stored in the LABEL table. | ||
com.atlassian.confluence.plugins.confluence-questions:comment | Tracks the comments added to a question or an answer. |
AO Tables
This section describes the tables involved in storing Calendars information, ownership, subscriptions, privileges, etc:
Table | Description |
|---|---|
AO_B1DBB9_ACCEPTANCE | Identifies the accepted answers |
AO_B1DBB9_BOUNTY | This table is not in use anymore. In previous versions of Questions for Confluence, it was used to assign bounties to particular answers |
AO_B1DBB9_VOTE | Tracks the votes submitted for the users to each specific answer |