BBBGit (Schema)
- Pablo Beltran
The app is a straightforward relational representation of the BigBrassBand REST API.
Therefore, the same BBB Git users' Jira permissions are applied to the corresponding SQL table.
Â
- 1 TABLES
- 1.1 REPOSITORIES
- 1.2 PROJECTREPOSITORIES
- 1.3 COMMITISSUES
- 1.4 ISSUECOMMITS
- 1.5 ISSUECOMMITFILES
- 1.6 ISSUEBRANCHES
- 1.7 ISSUETAGS
- 2 FUNCTIONS
- 2.1 COMMITLINK
TABLES
REPOSITORIES
All the registered repositories
REPOSITORIES | |||||
|---|---|---|---|---|---|
Name | REPOSITORYID | REPOSITORYNAME | ORIGIN | ROOT | MAINBRANCH |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR | VARCHAR |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | DISABLED | ENABLEFETCHES | SENDCOMMITEMAILS | MAXMINCOMMITSTOEMAIL | GLOBAL |
Type | BOOLEAN | BOOLEAN | BOOLEAN | INT | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | HOSTED | INITDATE | REVISIONINDEXING | REVSIONCACHESIZE | GITVIEWERENABLED |
Type | BOOLEAN | TIMESTAMP | BOOLEAN | INT | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | DISABLESSLVERIFICATION | SMARTCOMMITSENABLED | COMMITSVALIDATIONREQUIRED | TAGSFILTER | SHOWALLTACGS |
Type | BOOLEAN | BOOLEAN | BOOLEAN | VARCHAR | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | SUPPORTEXTERNALAPI | SOURCESDIFFVIEWENABLED | LIMITGITDATA | Â | Â |
Type | BOOLEAN | BOOLEAN | BOOLEAN | Â | Â |
Indexed | Â | Â | Â | Â | Â |
Â
PROJECTREPOSITORIES
Repositories mapped to a given project.
PROJECTREPOSITORIES | |||||
|---|---|---|---|---|---|
Name | PROJECTID | PROJECTKEY | PROJECTNAME | REPOSITORYID | REPOSITORYNAME |
Type | VARCHAR | VARCHAR | VARCHAR | BIGINT | VARCHAR |
Indexed | x | x | Â | Â | Â |
 |  | ||||
Name | ORIGIN | ROOT | MAINBRANCH | DISABLED | ENABLEFETCHES |
Type | VARCHAR | VARCHAR | VARCHAR | BOOLEAN | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | SENDCOMMITEMAILS | MAXMINCOMMITSTOEMAIL | GLOBAL | HOSTED | INITDATE |
Type | BOOLEAN | INT | BOOLEAN | BOOLEAN | TIMESTAMP |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | REVISIONINDEXING | REVSIONCACHESIZE | GITVIEWERENABLED | DISABLESSLVERIFICATION | SMARTCOMMITSENABLED |
Type | BOOLEAN | INT | BOOLEAN | BOOLEAN | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | COMMITSVALIDATIONREQUIRED | TAGSFILTER | SHOWALLTACGS | SUPPORTEXTERNALAPI | SOURCESDIFFVIEWENABLED |
Type | BOOLEAN | VARCHAR | BOOLEAN | BOOLEAN | BOOLEAN |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | LIMITGITDATA | Â | Â | Â | Â |
Type | BOOLEAN | Â | Â | Â | Â |
Indexed | Â | Â | Â | Â | Â |
Â
COMMITISSUES
Returns the list of issues associated with the commit from the specified repository.
COMMITISSUES | ||||
|---|---|---|---|---|
Name | REPOSITORYID | COMMITID | ISSUEID | ISSUEKEY |
Type | BIGINT | VARCHAR | BIGINT | VARCHAR |
Indexed | x | x | Â | Â |
Â
ISSUECOMMITS
Obtain commits associated with an issue
ISSUECOMMITS | ||||
|---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | COMMITID | AUTHOR |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR |
Indexed | x | x | Â | Â |
 |  | |||
Name | CREATED | MESSAGE | REPOSITORYID | REPOSITORYNAME |
Type | TIMESTAMP | VARCHAR | BIGINT | BOOLEAN |
Indexed | Â | Â | Â | Â |
Â
ISSUECOMMITFILES
Obtain commits associated with an issue and their committed file changes.
Â
ISSUECOMMITFILES | |||||
|---|---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | COMMITID | AUTHOR | CREATED |
Type | BIGINT | VARCHAR | VARCHAR | VARCHAR | TIMESTAMP |
Indexed | x | Â | Â | Â | Â |
 |  | ||||
Name | MESSAGE | REPOSITORYID | REPOSITORYNAME | PATH | LINESADDED |
Type | VARCHAR | BIGINT | VARCHAR | VARCHAR | INT |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | LINESMODIFIED | LINESDELETED | ACTION | Â | Â |
Type | INT | INT | CHAR | Â | Â |
Indexed | Â | Â | Â | Â | Â |
Â
ISSUEBRANCHES
List of branches associated with a Jira issue.
ISSUEBRANCHES | |||
|---|---|---|---|
Name | ISSUEID | ISSUEKEY | BRANCH |
Type | BIGINT | VARCHAR | VARCHAR |
Indexed | x | x | Â |
Â
ISSUETAGS
It retrieves TAGSPERREPOSITORY amount of the latest tags for the issue.Â
Tags are sorted in chronological order from newest to oldest.
ISSUETAGS | |||||
|---|---|---|---|---|---|
Name | ISSUEID | ISSUEKEY | NAME | CREATED | MESSAGE |
Type | BIGINT | VARCHAR | VARCHAR | TIMESTAMP | VARCHAR |
Indexed | x | x | Â | Â | Â |
 |  | ||||
Name | COMMITERNAME | COMMITEREMAIL | COMMITID | REPOSITORYID | REPOSITORYNAME |
Type | VARCHAR | VARCHAR | VARCHAR | BIGINT | VARCHAR |
Indexed | Â | Â | Â | Â | Â |
 |  | ||||
Name | ISTAGFEATUREENABLED | HASMORE | TAGSPERREPOSITORY | Â | Â |
Type | BOOLEAN | BOOLEAN | INT | Â | Â |
Indexed | Â | Â | x | Â | Â |
Â
FUNCTIONS
COMMITLINK
Â
BBBGIT.COMMITLINK(REPOSITORYID BIGINT, COMMITID VARCHAR, TARGET VARCHAR)A convenient way to build links to open Git commits on Jira.
Target is any valid value supported by the HTML anchor element: _blank, _top, _self, etc..
Â
Â