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

AO_950DC3_TC_SUBCALS

Records information of all the calendars created or subscribed by users.

AO_950DC3_TC_SUBCALS_IN_SPACE

Keeps the calendar details related to a specific space.

AO_950DC3_TC_SUBCALS_PROPS

Properties related to subCalendar (like Jira calendar properties, source location of subCalendar, etc).

AO_950DC3_TC_SUBCALS_PRIV_USR

Information about the restricted users of calendars

AO_950DC3_TC_SUBCALS_PRIV_GRP

Information about the restricted groups of calendars

Events

This section describes the tables involved in storing Events related information:

Table

Description

AO_950DC3_TC_EVENTS

Details of the events.

AO_950DC3_TC_EVENTS_EXCL

Information about exclusions of recurring events.

AO_950DC3_TC_EVENTS_INVITEES

Tracking IDs of the invitees to events.

AO_950DC3_TC_CUSTOM_EV_TYPES

Information about custom event types.

AO_950DC3_TC_DISABLE_EV_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

AO_950DC3_TC_REMINDER_SETTINGS

Reminder settings for the different event types.

AO_950DC3_TC_JIRA_REMI_EVENTS

Details of the Jira Reminder Events.

AO_950DC3_TC_REMINDER_USERS

Details of the current user when setting the reminder of the event types.

Updated on April 15, 2025

Still need help?

The Atlassian Community is here for you.