List of Repository Activity Types found in the Bitbucket server database's STA_ACTIVITY table
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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