linear_projects

Details about Linear projects

id Primary key: Unique identifier for the row
source_id Foreign key: Identifier of the project in Linear
archived_at date: Timestamp of when the project was archived
auto_archived_at date: The time at which the project was automatically archived by the auto pruning process
canceled_at date: Timestamp of when the project was canceled
completed_at date: Timestamp of when the project was completed
completed_issue_count_history array: Array of completed issues in the project after each week
completed_scope_history array: Array of completed estimation points after each week
description string: Description of the project
in_progress_scope_history array: Array of in progress estimation points after each week
issue_count_history array: Array of issues in the project after each week
name string: Name of the linear project
progress number: The overall progress of the project. This is the (completed estimate points + 0.25 * in progress estimate points) / total estimate points.
scope number: The overall scope (total estimate points) of the project
scope_history array: Array of estimation points after each week
start_date date: The estimated start date of the project.
started_at date: The time at which the project was moved into started state
state string: The type of the state
status string: The name of the state
target_date date: The estimated completion date of the project
accessible boolean: Boolean indicating if the project is accessible via API
created_at date: Timestamp of when the project was created in Linear
updated_at date: Timestamp of when the project was updated in Linear