Data Model
The CData Cmdlets PowerShell Module for Jira models the Jira API as an easy-to-use SQL database. This allows connectivity to Jira Cloud accounts or Jira Server instances. There are three parts to the data model: tables, views, and stored procedures.
Tables
The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your Jira account.
Common tables include:
| Table | Description |
| Issues | Provides full access to Jira issues. Supports creation, updates, deletions, and queries for issue records across all projects. |
| Projects | Provides access to all Jira projects. Supports querying, creating, updating, and deleting project records. |
| IssueTypes | Queries the available Issue Types in Jira, such as Task, Bug, Epic, and so on. |
| Users | Provides access to Jira users. Supports querying user details including account ID, email, and group memberships. |
| Comments | Manages comments added to issues. Supports creating, reading, updating, and deleting issue comments. |
| Attachments | Provides access to issue attachments in Jira. Supports querying, inserting, and deleting file attachments associated with issues. |
| Worklogs | Provides full access to Jira worklogs. Supports creating, updating, deleting, and querying logged work hours on issues. |
| Boards | Enables management of agile boards in Jira. Supports creation, querying, modification, and deletion of boards. |
| Sprints | Manages Jira sprints. Supports creating, modifying, deleting, and querying sprint data from agile boards. |
| Epics | Lists all epics across Jira projects, including epic names, summaries, and keys. |
| ProjectsIssueTypes | Displays issue types configured for each project, including standard and custom issue types. |
| Statuses | Lists all available issue statuses in Jira, including custom and default statuses used in workflows. |
| Workflows | Manages the available workflows in Jira, which define the sequence of statuses and transitions for issues. |
| WorkflowSchemes | Handles the configuration of workflow schemes that assign workflows to issue types across projects. |
| IssueChangelogs | Provides a detailed history of changes made to issues, including field changes, timestamps, and authors. |
| IssueLinks | Displays relationships between issues, such as 'blocks', 'duplicates', or 'relates to'. |
| IssueFixVersions | Returns the list of versions in which specific issues are expected to be resolved. |
| IssueComponents | Lists components assigned to issues, which typically represent parts or modules of a project. |
| CustomFieldContext | Returns a list of contexts for a custom field in Jira. |
| Fields | Retrieves metadata about all fields available in Jira, including both system-defined and custom fields. |
API limitations and requirements are documented in each table.
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard create, read, update, delete (CRUD) operations, including managing issues, attachments, and OAuth tokens.