jira_projects

Details of the your Jira projects.

id Primary key: Unique identifier for the row.
source_id Foreign key: Jira ID of the project.
connection_id Foreign key: ID of the Data Cloud connection importing the project.
project_type_key string: Jira indicator for the type of project.
name string: Name of the project.
private boolean: Boolean indicating whether or not the project is private.
deleted_at date: Date at which the project was deleted, if ever.
archived_at date: Date at which the project was archived, if ever.
total_issue_count number: Total count of the issues within the project.
key string: The key of the project.
last_issue_update_time date: Date/time of the last issue update in the project.
issue_types_synced_at date: Date/time when issue types were last synced.
issues_synced_at date: Date/time when issues were last synced.
issues_synced_to date: Date/time up to which issues have been synced.
api_accessible boolean: Whether the project is accessible via API.
allowlisted boolean: Whether the project is allowlisted for import.