github_project_issue_status_changes
Records of the statuses a GitHub project's issues/cards have had.
-
id
Primary key - Unique identifier of the row
-
issue_project_id
Foreign key - ID of the github_issue_projects row (the issue's card on this project) the change belongs to
-
source_id
Foreign key - ID of the status change event in GitHub. Event node IDs are only unique within a GitHub instance, so uniqueness is enforced per issue_project_id
-
from_status_id
Foreign key - ID of the status the card moved from. Null when this is the first recorded status for the card.
-
to_status_id
Foreign key - ID of the status the card moved to
-
actor_id
Foreign key - ID of the user who made the change. Null when the change was made by an automation.
-
was_automated
boolean - Whether the status change was made by a GitHub Projects workflow automation
-
changed_at
date - Timestamp from GitHub of when the card moved into the status