List of Repository Activity Types found in the Bitbucket server database's STA_ACTIVITY table
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
The STA_ACTIVITY table in the Bitbucket server database has pull request activity recorded in the following format:
id | activity_type | created_timestamp | user_id |
|---|---|---|---|
1 | 6 | 2019-09-06 11:16:06 | 1 |
39 | 5 | 2019-09-06 11:22:16 | 1 |
76 | 1 | 2019-09-13 10:17:18 | 1 |
113 | 2 | 2019-09-13 10:18:05 | 1 |
150 | 6 | 2019-12-03 10:35:10 | 1 |
187 | 5 | 2019-12-16 09:38:26 | 1 |
188 | 6 | 2019-12-16 09:41:14 | 1 |
224 | 3 | 2019-12-17 08:59:55 | 1 |
Solution
The sta_activity table is updated on a variety of different repository activities. This is indicated by the activity_type column. These activity types range from 1-9 which are as follows:
Generic pull request activity (e.g. approving, unapproving)
Commenting on a pull request
Merging a pull request
Pushing new changes to a pull request
Commenting on a commit
Pushing to a repository
Updating pull request reviewers
Creating a repository
Updating a repository
Was this helpful?