Jigit - Data Stored

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

The Jigit documentation was improved and now lives here.

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. CODE `ADDED(1, "Added"), MODIFIED(2, "Modified"), RENAMED(3, "Renamed"), DELETED(4, "Deleted");`

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: 26 Nov 2020