Here is the description of the data stored by Jira GitLab and GitHub integration.

What data is stored?

The app only stores the data it needs to display on the Issue View tab which currently shows the commit details and light diff information. The Jigit App does not access the source code.

Table structures

Commit table

Column name

Column type

Description

commitSha1

String

The commit reference hash. Primary Key.

title

String

The title of the commit (usually the message).

author

String

The author of the commit in the Git system (GitHub/GitLab).

createdAt

Date

The date the commit was created.

repoGroup

String

The optional parent grouping of the commit (group/project).

repoName

String

The name of the repository the commit belongs to.

branch

String

The name of the branch the commit was made.

isFirstCommit

Boolean

Is this the first commit?

Issue commit table

Column name

Column type

Description

issueKey

String

The issue key. Primary Key.

commitSha1

String

The reference to the commit table.

Commit diff table

Column name

Column type

Description

commitSha1

String

The reference to the commit table. Primary Key.

oldPath

String

The old path to the file.

newPath

String

The new path to the file.

actionId

Integer

One of the following actions.

ADDED(1, "Added"),
MODIFIED(2, "Modified"),
RENAMED(3, "Renamed"),
DELETED(4, "Deleted");
CODE

Queue item table

This table is used by the indexer as a processing queue.

Column name

Column type

Description

commitSha1

String

The commit hash to process. Primary Key.

repoName

String

The name of the repository commit belongs to.

branch

String

The name of the branch commit belongs to.

Updated: