Jira Tables and Scopes

Scopes

Classic

Scope
manage:jira-configuration
read:jira-user
read:jira-work
write:jira-work

Granular

Scope
read:application-role:jira
read:attachment:jira
read:audit-log:jira
read:avatar:jira
read:field-configuration:jira
read:field.default-value:jira
read:field.option:jira
read:field:jira
read:group:jira
read:issue-details:jira
read:issue-meta:jira
read:issue-security-level:jira
read:issue-type-hierarchy:jira
read:issue-type:jira
read:issue.changelog:jira
read:issue.vote:jira
read:issue:jira
read:permission-scheme:jira
read:permission:jira
read:project-category:jira
read:project-role:jira
read:project-version:jira
read:project.component:jira
read:project.property:jira
read:project:jira
read:status:jira
read:user:jira
write:attachment:jira
write:comment.property:jira
write:comment:jira
write:issue:jira

Tables

JiraApplicationRole

This table stores information about application roles in Jira, including group details, user limits, and platform association.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
ID	integer	Unique identifier for the application role.
Key	string	The key of the application role.
Name	string	The display name of the application role.
NumberOfSeats	integer	The maximum count of users on your license.
Platform	bit	Indicates if the application role belongs to the Jira platform.
RemainingSeats	integer	The number of available seats remaining.
SelectedByDefault	bit	Indicates whether the application role is selected by default.
UserCount	integer	The number of users assigned to this application role.
UserCountDescription	string	A textual representation of the user count (e.g., "5 developers", "0 users").

Related Scopes

Classic	Granular
manage:jira-configuration	read:application-role:jira

JiraAuditAssociatedItems

This table stores information about items related to audit records in Jira. When changes happen in Jira, such as updates to user groups or permissions, Jira logs these changes in an audit record. This table keeps track of the specific items involved in those changes, including their names, types, and parent associations.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
ID	string	The unique identifier of the associated record.
Name	string	The name of the associated record.
ParentId	string	The ID of the associated parent record.
ParentName	string	The name of the associated parent record.
TypeName	string	The type of the associated record.

Related Scopes

Classic	Granular
manage:jira-configuration	read:audit-log:jira
	read:user:jira

JiraAuditChangedValues

This table stores a history of changes made to specific fields in Jira audit records. Each entry tracks what changed, including the old value, the new value, and the field name. It helps in reviewing and understanding modifications made within Jira, supporting compliance, troubleshooting, and audit reporting.

Name	Type	Description
AuditChangedValueID	integer	The unique identifier for the audit changed value record.
BatchDate	datetime	The date and time data was synced to our database.
ChangedFrom	string	The value of the field before the change, as recorded in the audit event.
ChangedTo	string	The value of the field after the change, as recorded in the audit event.
ConfigID	integer	The ID of the configuration within Compyl.
FieldName	string	The name of the field that was changed in the audit record.
JiraAuditConfigID	integer	The ID of the configuration within Compyl.
JiraAuditID	integer	The ID of the audit record that this changed value belongs to.

Related Scopes

Classic	Granular
manage:jira-configuration	read:audit-log:jira
	read:user:jira

JiraAuditObjectItems

The JiraAuditObjectItems table stores details about objects associated with audit records in Jira. These objects represent entities affected by an audit event, such as users, groups, or projects. The table links each object item to a specific audit record and provides relevant metadata, including its name, parent details, and type.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
ID	integer	A unique identifier for the Jira audit object item
JiraAuditConfigID	integer	The ID of the configuration within Compyl.
JiraAuditID	integer	A reference to the audit record this object belongs to.
Name	string	The name of the associated object.
ObjectItemID	string	The unique identifier of the associated object in Jira.
ParentId	string	The ID of the parent object, if applicable.
ParentName	string	The name of the parent object, if applicable.
TypeName	string	The type of object.

Related Scopes

Classic	Granular
manage:jira-configuration	read:audit-log:jira
	read:user:jira

JiraAudits

The JiraAudits table stores records of audit events from Jira. Each record captures information about an event, including who performed the action, when it occurred, what category it falls under, and details about the change. This data helps track user actions, system changes, and other critical events for auditing and compliance purposes.

Name	Type	Description
AuthorAccountId	string	The unique account ID of the user who performed the action.
AuthorKey	string	A legacy identifier for the user who performed the action.
BatchDate	datetime	The date and time data was synced to our database.
Category	string	The category of the audit event. Categories help classify different types of events.
ConfigID	integer	The ID of the configuration within Compyl.
Created	datetime	The date and time when the audit record was created.
Description	string	Additional details about the audit event, which may provide context for the change.
EventSource	string	The system or plugin that triggered the audit event.
ID	integer	A unique identifier for the audit record
RemoteAddress	string	The IP address or hostname of the machine from which the action was performed.
Summary	string	A brief description of the audit event, summarizing what happened.

JiraGroups

The JiraGroups table stores information about user groups in Atlassian Jira. A group in Jira is a collection of users that can be assigned permissions, roles, and access rights across different Jira projects and applications. This table helps manage and organize user access within Jira-integrated systems.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
GroupID	string	The unique identifier for the Jira group.
Name	string	The human-readable name of the Jira group

Related Scopes

Classic	Granular
read:jira-user	read:group:jira

JiraIssues

The JiraIssues table stores information about Jira issues retrieved from an external Atlassian Jira system. Each record represents a unique issue, capturing details such as the issue's type, status, summary, description, assigned user, priority, and links to related documents. This data helps in tracking, managing, and analyzing Jira issues within our system.

Name	Type	Description
AssigneeID	string	The unique identifier of the Jira user assigned to resolve the issue.
BatchDate	datetime	The date and time data was synced to our database.
BatchID	integer	The ID of the batch.
ConfigID	integer	The ID of the configuration within Compyl.
DateAdded	datetime	The date and time when the issue was first added to our database.
DateEdited	datetime	The last time the issue was modified in our system.
Description	string	A detailed description of the issue, providing additional context, steps to reproduce, or other relevant information.
DocumentLink	string	A URL to any related documents or attachments associated with the issue.
DueDate	datetime	The deadline for resolving the issue, if one is specified in Jira.
Hyperlink	string	A direct URL to the Jira issue, allowing users to quickly access the issue in Jira.
ID	integer	A unique identifier for the Jira issue.
IssueType	string	The type of Jira issue, such as "Bug," "Task," "Story," or "Epic." This helps classify the nature of the issue.

JiraIssueComments

The JiraIssueComments table stores comments associated with Jira issues.

Name	Type	Description
AuthorAccountID	string	The Atlassian account ID of the user who authored the comment.
AuthorAccountType	string	The account type of the comment author (for example, atlassian, app, or customer).
AuthorActive	bit	Indicates whether the comment author account is active.
AuthorDisplayName	string	The display name of the user who authored the comment.
AuthorEmailAddress	string	The email address of the comment author when privacy settings allow it to be returned.
AuthorSelf	string	The REST self URL for the comment author.
AuthorTimeZone	string	The time zone associated with the comment author.
BatchDate	datetime	The date and time data was synced to our database.
BodyContentSerialized	string	The serialized ADF content array for the comment body.
BodyType	string	The ADF document type for the comment body (typically doc).
BodyVersion	integer	The ADF document version for the comment body.
CommentID	string	The unique Jira comment ID. Part of the composite primary key with ConfigID.

Related Scopes

Classic	Granular
read:jira-work	read:field.default-value:jira
	read:field.option:jira
	read:field:jira
	read:group:jira
	read:issue-details:jira

JiraPermissions

The JiraPermissions table stores permission-related data retrieved from Atlassian's Jira API.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
Description	string	A textual description of the permission scheme.
ID	integer	Unique identifier for the permission entry.
Name	string	The name of the permission scheme, which must be unique within Jira.
Type	string	Specifies the type of permission holder

Related Scopes

Classic	Granular
read:jira-work	read:application-role:jira
	read:avatar:jira
	read:field:jira
	read:group:jira
	read:permission-scheme:jira
	read:permission:jira
	read:project-category:jira
	read:project-role:jira
	read:project:jira
	read:user:jira

JiraPermissionSchemes

This table stores information about Jira permission schemes, which define sets of permissions assigned to users, groups, and roles within Jira projects.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
ID	integer	The unique identifier for the Jira permission scheme
Name	string	The name of the permission scheme.
Type	string	The type of the permission scheme.

Related Scopes

Classic	Granular
read:jira-work	read:application-role:jira
	read:avatar:jira
	read:field:jira
	read:group:jira
	read:permission-scheme:jira
	read:permission:jira
	read:project-category:jira
	read:project-role:jira
	read:project:jira
	read:user:jira

JiraProjectRoles

This table stores information about different roles assigned within Jira projects. A project role defines a specific set of users and groups with designated permissions for a project.

Name	Type	Description
Admin	bit	Indicates whether this role is the admin role for the project.
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
Description	string	A brief explanation of what the role represents.
ID	integer	Unique identifier for the project role.
Name	string	The name of the project role.
ProjectID	string	The ID of the project this role is associated with.
RoleConfigurable	bit	Specifies whether the role is configurable for this project.

Related Scopes

Classic	Granular
manage:jira-configuration	read:avatar:jira
	read:group:jira
	read:project-category:jira
	read:project-role:jira
	read:project:jira
	read:user:jira

JiraProjects

Each project represents a collection of issues and configurations within Jira.

Name	Type	Description
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
IsPrivate	bit	Indicates whether the project is private (restricted to certain users).
Key	string	The short identifier used for the project in Jira
Name	string	The name of the project as displayed in Jira.
ProjectID	string	The unique identifier for the project in Jira.
ProjectLeadID	string	The unique identifier of the user who leads the project.

Related Scopes

Classic	Granular
read:jira-work	read:application-role:jira
	read:avatar:jira
	read:group:jira
	read:issue-type-hierarchy:jira
	read:issue-type:jira
	read:project-category:jira
	read:project-version:jira
	read:project.component:jira
	read:project.property:jira
	read:project:jira
	read:user:jira

JiraUsers

This table helps track user details, such as their name, email, account type, and activity status, as well as their associated permissions, project roles, and groups.

Name	Type	Description
AccountID	string	The unique identifier for a Jira user across all Atlassian products.
AccountType	string	Specifies the type of user account.
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
DisplayName	string	The display name of the user.
EmailAddress	string	The email address of the user.
IsActive	bit	Indicates whether the user is currently active in Jira.
Name	string	The name of the user.

Related Scopes

Classic	Granular
read:jira-user	read:application-role:jira
	read:avatar:jira
	read:group:jira
	read:user:jira

Bridge Tables

JiraApplicationRoles_JiraGroups

Bridge table for application roles ands groups.

Name	Type	Description
JiraApplicationRoleConfigID	integer	The ID of the configuration within Compyl.
JiraApplicationRoleID	integer	The ID of the application role.
JiraGroupConfigID	integer	The ID of the configuration within Compyl.
JiraGroupID	string	The ID of the group.

JiraAssociatedItems_JiraAudits

Bridge table for associated items and jira audits.

Name	Type	Description
JiraAssociatedItemConfigID	integer	The ID of the configuration within Compyl.
JiraAssociatedItemID	string	The ID of the associated item.
JiraAuditConfigID	integer	The ID of the configuration within Compyl.
JiraAuditID	integer	The ID of the jira audit.

JiraGroups_JiraPermissions

Bridge table for groups and permissions.

Name	Type	Description
JiraGroupConfigID	integer	The ID of the configuration within Compyl.
JiraGroupID	string	The ID of the group.
JiraPermissionConfigID	integer	The ID of the configuration within Compyl.
JiraPermissionID	integer	The ID of the permission.

JJiraGroups_JiraProjectRoles

Bridge table for groups and project roles.

Name	Type	Description
JiraGroupConfigID	integer	The ID of the configuration within Compyl.
JiraGroupID	string	The ID of the group.
JiraProjectRoleConfigID	integer	The ID of the configuration within Compyl.
JiraProjectRoleID	integer	The ID of the project role.

JiraGroups_JiraUsers

Bridge table for groups and users.

Name	Type	Description
AccountID	string	The ID of the the account.
BatchDate	datetime	The date and time data was synced to our database.
ConfigID	integer	The ID of the configuration within Compyl.
GroupID	string	The ID of the group.

JiraPermissions_JiraProjectRoles

Bridge table for permissions and project roles.

Name	Type	Description
JiraPermissionConfigID	integer	The ID of the configuration within Compyl.
JiraPermissionID	integer	The ID of the Permission.
JiraProjectRoleConfigID	integer	The ID of the configuration within Compyl.
JiraProjectRoleID	integer	The ID of the project role.

JiraPermissions_JiraUsers

Bridge table for permission and users.

Name	Type	Description
JiraAccountID	string	The ID of the Account.
JiraPermissionConfigID	integer	The ID of the configuration within Compyl.
JiraPermissionID	integer	The ID of the Permission.
JiraUserConfigID	integer	The ID of the configuration within Compyl.

JiraPermissionSchemes_JiraPermissions

Bridge table for Permission Schemes and Permissions.

Name	Type	Description
JiraPermissionConfigID	integer	The ID of the configuration within Compyl.
JiraPermissionID	integer	The ID of the Permission.
JiraPermissionSchemeConfigID	integer	The ID of the configuration within Compyl.
JiraPermissionSchemeID	integer	The ID of the Permission Scheme.

JiraProjectRoles_JiraUsers

Bridge table for Project Roles and Users.

Name	Type	Description
JiraProjectRoleConfigID	integer	The ID of the configuration within Compyl.
JiraProjectRoleID	integer	The ID of the Project Role.
JiraUserAccountID	string	The ID of the User Account.
JiraUserConfigID	integer	The ID of the configuration within Compyl.

Scopes

Classic

Granular

Tables

JiraApplicationRole

Related Scopes

JiraAuditAssociatedItems

Related Scopes

JiraAuditChangedValues

Related Scopes

JiraAuditObjectItems

Related Scopes

JiraAudits

JiraGroups

Related Scopes

JiraIssues

JiraIssueComments

Related Scopes

JiraPermissions

Related Scopes

JiraPermissionSchemes

Related Scopes

JiraProjectRoles

Related Scopes

JiraProjects

Related Scopes

JiraUsers

Related Scopes

Bridge Tables

JiraApplicationRoles_JiraGroups

JiraAssociatedItems_JiraAudits

JiraGroups_JiraPermissions

JJiraGroups_JiraProjectRoles

JiraGroups_JiraUsers

JiraPermissions_JiraProjectRoles

JiraPermissions_JiraUsers

JiraPermissionSchemes_JiraPermissions

JiraProjectRoles_JiraUsers

Learn more...