Team Calendars Data Model in Confluence Data Center
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Summary
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.
When Team Calendars for Confluence 4.2 was released, the Team Calendars data was moved from BANDANA table into their own AO tables. The AO tables for Team Calendars will follow the syntax of AO_950DC3_TC_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 Team Calendars schema and a conceptual overview of the data model.
Solution
Database tables and references
Expand the link below to see a table of the foreign keys for each table.
Click here to show/hide the table...
Primary Key Table Name | Primary Key Column Name | Foreign Key Table Name | Foreign Key Column Name | Foreign Key Name |
|---|---|---|---|---|
AO_950DC3_TC_SUBCALS | ID | AO_950DC3_TC_SUBCALS | PARENT_ID | fk_ao_950dc3_tc_subcals_parent_id |
AO_950DC3_TC_SUBCALS | ID | AO_950DC3_TC_SUBCALS | SUBSCRIPTION_ID | fk_ao_950dc3_tc_subcals_subscription_id |
AO_950DC3_TC_SUBCALS_IN_SPACE | ID | AO_950DC3_TC_SUBCALS | SUB_CALENDAR_ID | fk_ao_950dc3_tc_subcals_in_space_sub_calendar_id |
AO_950DC3_TC_CUSTOM_EV_TYPES | BELONG_SUB_CALENDAR_ID | AO_950DC3_TC_SUBCALS | ID | fk_ao_950dc3_tc_custom_ev_types_belong_sub_calendar_id |
AO_950DC3_TC_DISABLE_EV_TYPES | SUB_CALENDAR_ID | AO_950DC3_TC_SUBCALS | ID | fk_ao_950dc3_tc_disable_ev_types_sub_calendar_id |
AO_950DC3_TC_JIRA_REMI_EVENTS | SUB_CALENDAR_ID | AO_950DC3_TC_SUBCALS | ID | fk_ao_950dc3_tc_jira_remi_events_sub_calendar_id |
AO_950DC3_TC_REMINDER_USERS | SUB_CALENDAR_ID | AO_950DC3_TC_SUBCALS | ID | fk_ao_950dc3_tc_reminder_users_sub_calendar_id |
Calendars
This section describes the tables involved in storing Calendars information, ownership, subscriptions, privileges, etc:
Table | Description |
|---|---|
| Records information of all the calendars created or subscribed by users. |
| Keeps the calendar details related to a specific space. |
| Properties related to subCalendar (like Jira calendar properties, source location of subCalendar, etc). |
| Information about the restricted users of calendars |
| Information about the restricted groups of calendars |
Events
This section describes the tables involved in storing Events related information:
Table | Description |
|---|---|
| Details of the events. |
| Information about exclusions of recurring events. |
| Tracking IDs of the invitees to events. |
| Information about custom event types. |
| Information about disabled event types. |
Jira Events information is not stored in Confluence database, as this information is kept in Jira system and retrieved via JQL.
Reminders
This section describes the tables involved in storing Reminders related information:
Table | Description |
|---|---|
| Reminder settings for the different event types. |
| Details of the Jira Reminder Events. |
| Details of the current user when setting the reminder of the event types. |
Was this helpful?