/
Subcomponents app database schema

Subcomponents app database schema

Subcomponents app store its feature data in the database. The table below describes which feature → table relations.

In case of migrating the database to another server, these tables should be part of the Jira database backup in order for the Subcomponents app to use the existing feature configurations.

Feature

Database table

Description

Feature

Database table

Description

Subcomponents

  • AO_E8E966_HIERARCHY_ITEM

  • AO_E8E966_FOLDER

References to components/folders by ID and folder details

Component versions

  • AO_E8E966_COMPONENTVERSION

References to components and versions by ID

Packages

  • AO_E8E966_PACKAGE

  • AO_E8E966_PROP_ITEM

Package details and references to packages and versions by ID

Component/version properties

  • AO_E8E966_PROP_SCHEMA

  • AO_E8E966_PROP_ITEM

  • AO_E8E966_PROP_SCHEMA_PROJ

  • AO_E8E966_PROP_VALUE

Property schema details, schema association with project and property values

It is possible to check which projects use a particular feature using the PROJECT_ID field in corresponding feature tables.

 

Related content

Subcomponents for Jira Data Center
Subcomponents for Jira Data Center
More like this
Database: gadget usage Server/Data Center
Database: gadget usage Server/Data Center
Read with this
Subcomponents
More like this
Subcomponents for Jira Cloud old
Subcomponents for Jira Cloud old
More like this
Server to Cloud migration
Server to Cloud migration
More like this