How does jira collect activity history in sql?

[Dmitrii]

Due to the fact that there are no methods for getting the activity history in Jira data center, I need to collect it from the postgres tables. But I cannot understand how Jira collects it? What tables are used to store history?

[Ismael Jimoh]

Hi @Dmitrii 

I will recommend having a look at the Jira database Schema: https://developer.atlassian.com/server/jira/platform/database-schema/ provided by Atlassian as the activity might need multiple tables to make sense out of.

One table that sticks out from memory is the changeitems table.

[Ismael Jimoh]

See the accepted answer here as it seems you are trying to do something slightly similar: https://community.atlassian.com/t5/Jira-questions/How-can-I-map-changegroup-changeitem-and-jiraissue-tables/qaq-p/660959