github_issues

Details about GitHub issues.

id

Primary key
Unique identifier of the row

source_id

Foreign key
ID of the issue in GitHub

source_url

string
URL of the issue in GitHub

repository_id

Foreign key
ID of the repository to which the issue belongs

state

string
State of the issue (e.g., open, closed)

title

string
Title of the issue

body

string
Description of the issue as raw Markdown. Only populated when the github_issue_descriptions conditional schema is applied.

number

number
Number of the issue within the repository

creator_id

Foreign key
ID of the user who created the issue

parent_node_id

Foreign key
Node ID of the parent issue, if this issue is a GitHub sub-issue. The parent may not be synced yet.

node_id

Foreign key
Node ID of the issue in GitHub.

milestone_id

Foreign key
ID of the milestone the issue is assigned to, if any

github_instance_id

Foreign key
GitHub instance (github.com or a specific GHES install) this issue's node_id was minted by

type

string
Type of the issue

cycle_time

number
Cycle time for the issue in days

closed_at

date
Date when the issue was closed

created_at

date
Date when the issue was created

started_at

date
Date when work on the issue started

updated_at

date
Date when the issue was last updated

deleted_at

date
Date when the issue was deleted