Gist Data Model
In the Gist Data Model, the server models gists associated with the authenticated account—including their files, comments, forks, and commits—as an easy-to-use SQL database. Live connectivity to these objects means that any changes to your GitHub account are immediately reflected in the server. Note that retrieving gists is not supported for Enterprise Managed Users.
Tables
The following Tables are shipped with the server:
| Name | Description |
| Comments | Lists comments on gists. |
| Files | Lists up to three hundred files for each gist at their most recent revisions, including up to one megabyte of content per file. |
| Gists | Lists gists at their most recent revisions. |
| Parents | Lists parent gist information for forked gists. |
| Starred | Lists starred gists for the authenticated user. |
Views
The following Views are shipped with the server:
| Name | Description |
| CommentEdits | Lists edit history for gist comments. |
| CommitFiles | Lists up to three hundred files for each gist at every revision, including up to one megabyte of content per file. |
| Commits | Lists the commit history of gists. |
| Forks | Lists gist forks. |
| Stargazers | Lists information about the users who have starred gists. |
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.
The following procedures are shipped with the server:
| Name | Description |
| DownloadFile | Download a file from a gist. |
| IsGistStarred | Checks if a gist is starred by the authenticated user. |