The list of database tables for Git Integration for Jira app can be accessed at 
Jira Administration ➜ System ➜ (sidebar) Advanced ➜ Plugin Data Storage.
The database tables are described in the table below:
| DB Table | Description |
|---|---|
| AO_8BA09E_GITHUB_APPS | This table is a temporal place to persist all configurations specifically for integrations over GitHub App. Values are kept there until the integration is fully established. |
| AO_8BA09E_GIT_REPOSITORY | This table contains the main repository configuration and repository parameters visible to users. |
| AO_8BA09E_INTEGRATION_USER | This table contains information on external users, such as the Pull Request author. |
| AO_8BA09E_MERGE_REQ_COMMITS | This table contains information required to support the feature. For more information, see General Setting: Enable indexing pull/merge requests by commits. |
| AO_8BA09E_MERGE_REQUEST | This table contains information about external merger requests and pull requests from the connected git servers. |
| AO_8BA09E_MERGE_REQUEST_EVENT | This table persists additional information about Pull Requests like events on a timeline. E.g. someone has commented or reviewed a PR. |
| AO_8BA09E_OBJECT_REGISTRATION | This table contains information about object states for the Scripting feature. The objects are:
commits branches * merge/pull requests |
| AO_8BA09E_PROJECT_MAPPING | This table contains project permissions.
|
| AO_8BA09E_PROJECT_SETTINGS | This table contains projects selected for some general setting options.
|
| AO_8BA09E_REINDEX_LOCK | This table is used to lock a repository which is being currently processed by an indexer to avoid two or more indexers to process the repository simultaneously. |
| AO_8BA09E_REINDEX_QUEUE | This table stores the queued and processing/processed items. When an item is extracted from the queue, it is not removed, but marked as executed instead. |
| AO_8BA09E_REINDEX_QUEUE_LOG | This table contains records for status data from all nodes. This table is introduced to avoid concurrent changes from different nodes. Each node adds/modifies its own record. |
| AO_8BA09E_REPOSITORY_PARAMS | This table contains internal repository parameters/states. |
| AO_8BA09E_REPO_WATCHERS | This table contains repositories’ watchers. |
| AO_8BA09E_SCREGISTRATION | This table contains processed smart commits. |
| AO_8BA09E_SCREGISTRATION_ERROR | This table contains errors that appeared during smart commits processing. |
| AO_8BA09E_SSH_KEY_ENTRY | This table contains SHH keys used during connection to repositories. |
| AO_8BA09E_TAGS_TOPOLOGY | This table stores tags chains per connected repository. It is used for an internal optimization of a repository indexing. |
| AO_8BA09E_UNTRCKDCOMM_NOTF | This table is used to track sent notifications that have no issue key and untracked by indices. |
| AO_8BA09E_USERS_PATS | This table contains users’ personal access tokens. |
| AO_8BA09E_WEB_HOOK_ENTRY | This table contains a secret key of the reindex webhook. It contains only one record. |
The following pull request tables are deprecated:
| DB Table | Description |
|---|---|
| AO_8BA09E_PULL_REQUEST | We don’t use it anymore. But, Atlassian advised not to delete tables. |
| AO_8BA09E_PULL_REQUEST_V2 | This table contains pull requests. |
| AO_8BA09E_REVIEW_COMMENT | We don’t use it any more. But, Atlassian advised not to delete tables. |
| AO_8BA09E_REVIEW_COMMENT_V2 | This table contains comments to the pull requests. |
More related Administration articles
Upgrades and migrations within same servver
Recommended Jira memory settings
Plugin Data Storage (this page)
