Project Data Model
In the Project Data Model schema, the add-in models each project associated with the authenticated account as a schema. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the add-in.
Note: The add-in does not read from classic projects; they have been deprecated in the GitHub API.
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 GitHub account.
The following tables and views are shipped with the add-in:
| Table | Description |
| CustomView | Displays project items labeled 'bug,' sorted by label name in ascending order, to facilitate issue tracking. |
| ItemAssignees | Tracks users assigned to project items, offering a detailed view of task ownership and accountability. |
| ItemLabels | Stores labels applied to project items, enabling better categorization and filtering of tasks. |
| ItemLinkedPullRequests | Connects pull requests to specific project items, creating traceability between project tasks and related code changes. |
| ItemReviewers | Maintains a list of reviewers assigned to specific project items, ensuring tracking of review responsibilities. |
| Items | Contains all details related to project items, including metadata and any associated fields. |
| ItemsView | Offers a complete and unfiltered view of all project items, facilitating comprehensive project analysis. |
| StatusUpdates | Logs status changes for project items, helping teams track progress and communicate updates effectively. |
Stored Procedures
Stored Procedures are actions that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, including getting the currently authenticated user or retrieving and refreshing OAuth access tokens.