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