Overview

The Jira schema surfaces Jira Core, Jira Software, and Jira administration-related objects as SQL entities for both Jira Cloud and Jira Data Center instances.

• Entities which are available in both Jira Cloud and Jira Data Center instances are listed in the following sections: Tables, Views, and Stored Procedures.

  Even though the tables and views are available in both Jira Cloud and Jira Data Center instances, the set of columns exposed might differ depending on the platform. Refer to the Platform column to determine whether the column is available in your instance.

  • Platform=Common; column is available in both Jira Cloud and Jira Data Center instances.
  • Platform=Cloud; column is available only in Jira Cloud instances.
  • Platform=Server; column is available only in Jira Data Center instances.

• For entities which are available only in Jira Cloud instances, refer to Jira.