Subcomponents app database schema

Owned by Vasyl Krokha
Last updated: Nov 09, 2022
1 min read

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.