Bitbucket Tables

The Bitbucket integration uses the following tables

Tables

BitbucketProjectPermissions

NameTypeDescription
ConfigIDintThe ID of the configuration within Compyl.
ProjectIDstringThe project's immutable id.
PermissionstringValid values: admin, create-repo, write, read, none
ProjectNamestringThe name of project.
BitbucketProjectModelConfigIDintThe ID of the Bitbucket Project Model configuration.
BitbucketProjectModelIDstringThe ID of the Bitbucket Project Model.
BatchDatedatetimeThe sync date.

BitbucketProjects

NameTypeDescription
ConfigIDintegerThe ID of the configuration within Compyl.
IDstringThe project's immutable id.
BatchDatedatetimeThe sync date.
CreatedOndatetimeThe datetime from when the project was created.
DescriptionstringA description of the project.
HasPubliclyVisibleReposbooleanIndicates whether the project contains publicly visible repositories. Note that private projects cannot contain public repositories
IsPrivatebooleanIndicates whether the project is publicly accessible, or whether it is private to the team and consequently only visible to team members. Note that private projects cannot contain public repositories.
KeystringThe project's key.
NamestringThe name of the project.
OwnerDisplayNamestringThe display name of the project's owner.
OwnerIDstringThe id of the project's owner.
OwnerTypestringThe type of the project's owenr.
OwnerUserNamestringThe user name of the owner of the project.
UpdatedOndatetimeThe datetime when the project was last updated.
WorkspaceIDstringThe id of the workspace that the project belongs to.

BitbucketRepositories

NameTypeDescription
ConfigIDintegerThe ID of the configuration within Compyl.
IDstringThe repository's immutable id. This can be used as a substitute for the slug segment in URLs. Doing this guarantees your URLs will survive renaming of the repository by its owner, or even transfer of the repository to a different user.
BatchDatedatetimeThe sync date.
BranchingModelbooleanThe branching model of the repository.
CreatedOndatetimeThe datetime from which the repository was created.
DefaultMergeStrategybooleanThe default merging strategy of the repository.
DescriptionstringA description of the repository.
ForkPolicystring

Controls the rules for forking this repository.

Valid values: allow_forks (unrestricted forking), no_public_forks (restrict forking to private forks - forks cannot be made public later), no_forks (deny all forking)

FullNamestringThe concatenation of the repository owner's username and the slugified name, e.g. "evzijst/interruptingcow". This is the same string used in Bitbucket URLs.
HasIssuesbooleanIndicates whether the repository has issues.
HasWikibooleanIndicates whether the repository has wiki.
LanguagestringThe language associated with the repository.
MainBranchTypestringThe type of the repository's main branch.
MainBranchnamestringThe name of the repository's main branch.
NamestringThe name of the repository.
OwnerDisplayNamestringThe display name of the repository's owner.
OwnerIDstringThe id of the repository's owner.
OwnerTypestringThe type of the repository's owner.
OwnerUserNamestringThe user name of the owner of the repository.
ProjectIDstringThe id of the project that the repository is associated with.
ProjectKeystringThe key of the project that the repository is associated with.
ProjectNamestringThe name of the project that the repository is associated with.
ProjectTypestringThe type of the project that the repository is associated with.
SCMstringThe source code management system.
SizeintegerThe size of the repository in bytes.
SlugstringThe shortened name for the repository.
TypestringThe type of the repository.
UpdatedOndatetimeThe datetime when the repository was last updated.
WebsitestringThe repository's website.
WorkspaceIDstringThe id of the workspace that the repository belongs to.

BitbucketRepositoryPermissions

NameTypeDescription
RepoIDstringThe repository's immutable id.
RepoNamestringThe name of the repository.
PermissionstringValid values: read, write, admin, none
ConfigIDintegerThe ID of the configuration within Compyl.
BatchDatedatetimeThe sync date.

BitbucketRepositoryPullRequests

NameTypeDescription
ConfigIDintegerThe ID of the configuration within Compyl.
IDintegerThe pull request's unique ID. Note that pull request IDs are only unique within their associated repository.
AuthorDisplayNamestringThe display name of the pull request's author.
AuthorIDstringThe account id of the pull request's author.
BatchDatedatetimeThe sync date.
ClosedByIDstringThe account id of the user who closed the pull request.
ClosedByUserDisplayNamestringThe display name of the user who closed the pull request.
CreatedOndatetimeThe datetime that the pull request was created.
DescriptionstringA description of the pull request.
DestinationRepositoryIDstringThe id of the destination repository of the pull request.
SourceRepositoryIDstringThe id of the source repository for the pull request.
Statestring

The pull request's current status.

Valid values: OPEN, MERGED, DECLINED, SUPERSEDED

TitlestringTitle of the pull request.
UpdatedOndatetimeThe datetime that the pull request was last updated on.

BitbucketUsers

NameTypeDescription
IDstringThe user's immutable id.
AccountIDstringThe user's account id.
DisplayNamestringThe display name of the user's account.
NickNamestringThe nickname for the user's account.
CreatedOndatetimeThe datetime from when the user account was created.
IsStaffbooleanIndicates whether the user account is staff or not.
AccountStatusstringThe status of the user account.
ConfigIDintegerThe ID of the configuration within Compyl.
BatchDatedatetimeThe sync date.

BitbucketWorkspacePermissions

NameTypeDescription
WorkspaceIDstringThe workspace's immutable id.
PermissionstringValid values: owner, collaborator, member
ConfigIDintegerThe ID of the configuration within Compyl.
BatchDatedatetimeThe sync date.
WorkspaceNamestringThe name of the workspace.

BitbucketWorkspaces

NameTypeDescription
ConfigIDintegerThe ID of the configuration within Compyl.
IDstringThe workspace's immutable id.
BatchDatedatetimeThe sync date.
CreatedOndatetimeThe datetime from when the workspace was created.
IsPrivatebooleanIndicates whether the workspace is publicly accessible, or whether it is private to the members and consequently only visible to members.
NamestringThe name of the workspace.
SlugstringThe short label that identifies this workspace.
TypestringThe entry's type.

Bridge Tables

BitbucketProjectPermissions_BitbucketUsers

NameTypeDescription
UserIDstringThe user's immutable id.
ProjectPermissionstringThe project-level permission.
ProjectIDstringThe project's immutable id.
ConfigIDintegerThe ID of the configuration within Compyl.

BitbucketRepositoryPermissions_BitbucketUsers

NameTypeDescription
UserIDstringThe user's immutable id.
RepoPermissionstringThe user's repository permission.
RepoIDstringThe repository's immutable id.
ConfigIDintegerThe ID of the configuration within Compyl.

BitbucketUsers_BitbucketWorkspacePermissions

NameTypeDescription
UserIDstringThe user's immutable id.
WorkspacePermissionstringThe user's workspace permission.
WorkspaceIDstringThe workspace's immutable id.
ConfigIDintegerThe ID of the configuration within Compyl.

BitbucketUsers_BitbucketWorkspaces

NameTypeDescription
WorkspaceIDstringThe workspace's immutable id.
PermissionstringValid values: owner, collaborator, member
ConfigIDintegerThe ID of the configuration within Compyl.
BatchDatedatetimeThe sync date.
WorkspaceNamestringThe name of the workspace.

Did this page help you?