Data share schema for Goals and Projects

Data shares aren’t available in the Atlassian Government environment.

Goal

The atlassian_home_goal table lists all your goals from the Goals app.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the goal was created.

SQL name	`created_at`
Data type	Datetime

Description

The description of the goal.

SQL name	`description`
Data type	String

Goal ID

The unique identifier of the goal.

SQL name	`goal_id`
Data type	String

Is archived

Indicates whether or not the goal is archived.

SQL name	`is_archived`
Data type	Boolean

Is private

Indicated whether or not the goal is private.

SQL name	`is_private`
Data type	Boolean

Key

The key of the goal.

SQL name	`key`
Data type	String
Example value	TITAN-123456

Name

The name of the goal.

SQL name	`name`
Data type	String

Owner ID

The unique identifier of the owner of the goal.

SQL name	`owner_id`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Parent goal ID

The unique identifier of the parent goal. If this column is not null, then the goal is a sub-goal.

SQL name	`parent_goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Phase

The current phase of the goal.

SQL name	`phase`
Data type	String
Example values	pending in_progress done paused cancelled

Started at

The date and time (UTC time zone) when the goal started.

SQL name	`started_at`
Data type	Datetime

Status

The current status of the goal.

SQL name	`status`
Data type	String
Example values	on_track off_track at_risk

Target date type

The type of target date for the goal.

SQL name	`target_date_type`
Data type	String
Example values	day month quarter

Targeted at

The target date of the goal.

SQL name	`targeted_at`
Data type	Datetime

Teams

The teams related to the goal.

SQL name	`teams`
Data type	String

Type ID

The unique identifier for the type of goal.

SQL name	`type_id`
Data type	String
Foreign key	Links to a record in the `goal_type` table.

Watchers

The people watching the goal.

SQL name	`watchers`
Data type	String
Foreign key	Links to records in the `account` table in the schema for organization data.

Goal comment

The atlassian_home_goal_comment table lists all the comments made to goals.

The table uses the following columns:

Body

The text of the comment.

SQL name	`body`
Data type	String

Comment ID

The unique identifier of the comment of the goal. Use this as the primary key for goal comment data.

SQL name	`goal_comment_id`
Data type	String

Created at

The date and time (UTC time zone) when the comment on the goal was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the comment on the goal.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal associated with the comment.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Updated at

The date and time (UTC time zone) when the comment was last updated.

SQL name	`goal_update_id`
Data type	Datetime

Goal custom field allowed value

The atlassian_home_custom_field_allowed_value table contains allowed values of custom fields for goals.

The table uses the following columns:

Allowed value ID

The unique identifier for the custom field saved value. Use this as the primary key for allowed values of custom fields.

SQL name	`allowed_value_id`
Data type	String

Created at

The date and time (UTC time zone) when the allowed value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the allowed value.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition associated with the allowed value.

SQL name	`custom_field_definition_id`
Data type	String
Foreign key	Links to a record in the `goal_custom_field_definition` table.

Sort order

Used to determine where in the list of allowed values this value should be placed.
An allowed value with a lower sortOrder will be earlier in the list.

SQL name	`sort_order`
Data type	Integer

Updated at

The date and time (UTC time zone) when the allowed value was last updated.

SQL name	`updated_at`
Data type	Datetime

Value

The value of the allowed option.

SQL name	`value`
Data type	String

Goal custom field definition

The atlassian_home_custom_field_definition table contains custom field definition data for goals.

The table uses the following columns:

Can set multiple values

Indicates whether or not the custom field can have multiple values set.

SQL name	`can_set_multiple_values`
Data type	Boolean

Created at

The date and time (UTC time zone) when the custom field was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the custom field.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition. Use this as the primary key for custom field definitions.

SQL name	`custom_field_definition_id`
Data type	String

Data type

The data type of the custom field definition.

SQL name	`data_type`
Data type	String

Deleted at

The date and time (UTC time zone) when the custom field was deleted.

SQL name	`deleted_at`
Data type	Datetime

Description

The description of the custom field definition.

SQL name	`description`
Data type	String

Has allowed values

Indicates whether or not the custom field has predefined allowed values. Only applies to custom fields that are either single-select or multi-select text.

SQL name	`has_allowed_values`
Data type	Boolean

Is enabled for goals

Indicates whether or not the goal type is enabled in Goals.

SQL name	`is_enabled_for_goals`
Data type	Boolean

Is enabled for projects

Indicates whether or not the goal type is enabled in Projects.

SQL name	`is_enabled_for_projects`
Data type	Boolean

Name

The name of the custom field definition.

SQL name	`name`
Data type	String

Token

The custom field’s randomly generated token.

SQL name	`token`
Data type	String

Updated at

The date and time (UTC time zone) when this custom field definition was last updated.

SQL name	`updated_at`
Data type	Datetime

Goal custom field saved value

The atlassian_home_custom_field_saved_value table contains saved value data of custom fields for goals.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the custom field saved value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the custom field.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition.

SQL name	`custom_field_definition_id`
Data type	String
Foreign key	Links to a record in the `goal_custom_field_definition` table.

Custom field saved value ID

The unique identifier of the custom field saved value. Use this as the primary key for saved values of custom fields.

SQL name	`custom_field_saved_value_id`
Data type	String

Goal ID

The unique identifier of the goal that the saved value is associated with.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Updated at

The date and time (UTC time zone) when the saved value of the custom field was last updated.

SQL name	`updated_at`
Data type	Datetime

Value

The value of the custom field.

SQL name	`value`
Data type	String

Goal metric

Metrics allow you to track and evaluate goal progress in a more structured and digestible format.

Created at

The date and time (UTC time zone) when the metric was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the metric.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Is archived

Indicates whether or not the metric is archived.

SQL name	`is_archived`
Data type	Boolean

Metric ID

The unique identifier of the metric.

SQL name	`metric_id`
Data type	String

Name

The name of the metric.

SQL name	`name`
Data type	String

Sub type

The custom sub type of the metric.

SQL name	`sub_type`
Data type	String

Type

The type of the metric.

SQL name	`type`
Data type	String

Updated at

The date and time (UTC time zone) when the metric was last updated.

SQL name	`updated_at`
Data type	Datetime

Goal metric saved value

The atlassian_home_goal_metric_saved_value table contains saved value data of goal metrics.

Created at

The date and time (UTC time zone) when the metric value was created.

SQL name	`created_at`
Data type	Datetime

Inserted at

The date and time (UTC time zone) when the value was inserted.

SQL name	`inserted at`
Data type	Datetime

Insertion context

The context in which this metric value was created.

SQL name	`insertion_context`
Data type	String

Metric ID

The unique identifier for the metric the value is associated with.

SQL name	`metric_id`
Data type	String

Metric saved value ID

The unique identifier for the saved value.

SQL name	`metric_saved_value_id`
Data type	String

Metric value

The value of the metric.

SQL name	`metric_value`
Data type	Number

Updated at

The date and time (UTC time zone) when the metric value was last updated.

SQL name	`updated_at`
Data type	Datetime

Goal metric target

The atlassian_home_goal_metric_target table contains target values for metrics.

Created at

The date and time (UTC time zone) when the metric value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the metric.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal that the saved value is associated with.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Metric ID

The unique identifier for the metric the value is associated with.

SQL name	`metric_id`
Data type	String

Metric target ID

The unique identifier for the target.

SQL name	`metric_target_id`
Data type	String

Snapshot value ID

The current value of the metric.

SQL name	`snapshot_value_id`
Data type	String

Start value

The starting value with which progress on this target is calculated. Progress will be calculated as a percentage of the difference between this value and the target value.

SQL name	`srart_value`
Data type	Number

Target value

The target value with which progress on this target is calculated. Progress will be calculated as a percentage of the difference between the start value and this value.

SQL name	`target_value`
Data type	Number

Updated at

The date and time (UTC time zone) when the metric value was last updated.

SQL name	`updated_at`
Data type	Datetime

Goal tag

The atlassian_home_goal_tag contains information about tags for goals.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the tag was created.

SQL name	`created_at`
Data type	Datetime

Description

The description of the goal tag.

SQL name	`description`
Data type	String

Name

The name of the goal tag.

SQL name	`name`
Data type	String

Owned by

The unique identifier of the person who owns the goal tag.

SQL name	`owned_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Tag ID

The unique identifier of the tag. Use this as the primary key for goal tag data.

SQL name	`tag_id`
Data type	String

Updated at

The date and time (UTC time zone) when the tag was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the tag.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal tag mapping

The atlassian_home_goal_tag_mapping holds associations between goals and tags.

The table uses the following columns:

Goal ID

The unique identifier for the goal that the tag is associated with.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Goal workspace ID

A workspace identifier for the goal associated with the tag.

SQL name	`goal_workspace_id`
Data type	String

Relationship ID

Unique identifier for this mapping/relationship.

SQL name	`relationship_id`
Data type	String

Sequence number

Sequence number of the last update to the relationship.

SQL name	`sequence_number`
Data type	Number

Tag ID

The unique identifier of the goal tag.

SQL name	`tag_id`
Data type	String
Foreign key	Links to a record in the `goal_tag` table.

Updated at

The date and time (UTC time zone) when the relationship between the goal and the tag was last updated.

SQL name	`updated_at`
Data type	Datetime

Goal type

The atlassian_home_goal_type table lists all the goal types.

The table uses the following columns:

Is enabled

Indicates whether or not the goal type is enabled.

SQL name	`is_enabled`
Data type	Boolean

Name

The name of the goal type.

SQL name	`name`
Data type	String

Type ID

The unique identifier of the goal type. Use this as the primary key for goal type data.

SQL name	`type_id`
Data type	String

Goal update

The atlassian_home_goal_update table lists the updates made to each goal.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the goal update was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the goal update.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal ID

The unique identifier of the goal associated with the update.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `goal` table.

Goal update ID

The unique identifier of the goal update. Use this as the primary key for goal update data.

SQL name	`goal_update_id`
Data type	String

Is missed update

Indicates whether or not the update was missed.

SQL name	`is_missed_update`
Data type	Boolean

New phase

The goal’s phase after the update.

SQL name	`new_phase`
Data type	String
Example values	pending in_progress done paused cancelled

New score

The goal’s score after the update.

SQL name	`new_score`
Data type	Number

New status

The goal’s status after the update.

SQL name	`new_status`
Data type	String
Example values	on_track off_track at_risk

New target date at

The goal’s target date after the update.

SQL name	`new_target_date_at`
Data type	Datetime

New targeted confidence

The goal’s target date confidence after the update.

SQL name	`new_targeted_confidence`
Data type	Number

Old phase

The goal’s phase before the update.

SQL name	`old_phase`
Data type	String
Example values	pending in_progress done paused cancelled

Old score

The goal’s score before the update.

SQL name	`old_score`
Data type	Number

Old status

The goal’s status after the update.

SQL name	`old_status`
Data type	String
Example values	on_track off_track at_risk

Old target date type

The type of target date for the update.

SQL name	`old_target_date_type`
Data type	String
Example values	day month quarter

Old target date at

The goal’s target date before the update.

SQL name	`old_targeted_at`
Data type	Datetime

Old targeted confidence

The goal’s target date confidence before the update.

SQL name	`old_targeted_confidence`
Data type	Number

Summary*

The summary of the update.

SQL name	`summary`
Data type	String

Updated at

The date and time (UTC time zone) when the goal update was last updated.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last updated the goal update.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal update note

The atlassian_home_goal_update_note table lists the notes attached to goal updates.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the update note was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the update note.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Goal update ID

The unique identifier of the goal update that the note is associated with.

SQL name	`goal_update_id`
Data type	String
Foreign key	Links to a record in the `goal_update` table.

Is archived

Indicates whether or not the goal is archived.

SQL name	`is_archived`
Data type	Boolean

Summary

The summary of the update note.

SQL name	`summary`
Data type	String

Title

The name of the update note.

SQL name	`title`
Data type	String

Update note ID

The unique identifier of the update note. Use this as the primary key for update note data.

SQL name	`goal_update_note_id`
Data type	String

Tables for relationships across apps

These tables help to connect data from this schema to data from other app schemas in the Atlassian Data Lake. You can query these tables if at least one of the apps is included in the Data Lake connection. However, if both apps aren’t included, the relevant tables won’t have data.

Goal Jira work item mapping

The atlassian_home_goal_jira_issue_mapping table holds associations between goals from the Goals app and Jira work items.

The table uses the following columns:

Goal ID

The unique identifier of a goal.

SQL name	`goal_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Goals.

Goal workspace ID

An Atlassian identifier that maps to the Goals instance that the goal belongs to.

SQL name	`goal_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Relationship ID

Unique identifier for this mapping/relationship.

SQL name	`relationship_id`
Data type	String

Updated at

The date and time (UTC time zone) when the association between the goal and the Jira work item was last updated.

SQL name	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of a work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Project

The atlassian_home_project table holds the latest information about Atlassian projects. Read more about Projects.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the project was created.

SQL name	`created_at`
Data type	Datetime

Goals

The goals to which this project contributes.

SQL name	`goals`
Data type	String

Is archived

Indicates whether or not the project is archived.

SQL name	`is_archived`
Data type	Boolean

Is private

Whether the project is private.

SQL name	`is_private`
Data type	Boolean

Key

The key of the project.

SQL name	`key`
Data type	String
Example value	GLOBE-1234

Members

The people who are contributors to the project.

SQL name	`members`
Data type	String
Foreign key	Links to records in the `account` table in the schema for organization data.

Name

The name of the project.

SQL name	`name`
Data type	String

Owner ID

The unique identifier of the owner of the project.

SQL name	`owner_id`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Phase

The state of the project.

SQL name	`phase`
Data type	String
Example values	pending in progress paused done

Project ID

The unique identifier of the project. Use this as the primary key for project data.

SQL name	`project_id`
Data type	String

Started at

The date and time (UTC time zone) when the project started.

SQL name	`started_at`
Data type	Datetime

Status

The status of the project.

SQL name	`status`
Data type	String
Example values	On track At risk Off track

Target date type

The confidence of the target date.

SQL name	`target_date_type`
Data type	String
Example values	day month quarter

Targeted at

The date and time (UTC time zone) of the project’s target date.

SQL name	`targeted_at`
Data type	Datetime

The measurement

Describes how the success of the project will be measured. It corresponds to the “What will success look like?” field in the “About” tab of the project.

SQL name	`the_measurement`
Data type	String

The what

Describes what’s being done in the project. It corresponds to the “What are we doing” field in the “About” tab of the project.

SQL name	`the_what`
Data type	String

The why

Describes why the project exists. It corresponds to the “Why are we doing it?” field in the “About” tab of the project.

SQL name	`the_why`
Data type	String

Watchers

The people watching the project.

SQL name	`watchers`
Data type	String
Foreign key	Links to records in the `account` table in the schema for organization data.

Project custom field definition

The atlassian_home_project_custom_field_definition table contains custom field definition data for projects.

The table uses the following columns:

Can set multiple values

Indicates whether or not the custom field can have multiple values set.

SQL name	`can_set_multiple_values`
Data type	Boolean

Created at

The date and time (UTC time zone) when the custom field was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the custom field.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition. Use this as the primary key for custom field definitions.

SQL name	`custom_field_definition_id`
Data type	String

Data type

The data type of the custom field definition.

SQL name	`data_type`
Data type	String

Deleted at

The date and time (UTC time zone) when the custom field was deleted.

SQL name	`deleted_at`
Data type	Datetime

Description

The description of the custom field definition.

SQL name	`description`
Data type	String

Has allowed values

Indicates whether or not the custom field has predefined allowed values. Only applies to custom fields that are either single-select or multi-select text.

SQL name	`has_allowed_values`
Data type	Boolean

Is enabled for goals

Indicates whether or not the goal type is enabled in Goals.

SQL name	`is_enabled_for_goals`
Data type	Boolean

Is enabled for projects

Indicates whether or not the goal type is enabled in Projects.

SQL name	`is_enabled_for_projects`
Data type	Boolean

Name

The name of the custom field definition.

SQL name	`name`
Data type	String

Token

The custom field’s randomly generated token.

SQL name	`token`
Data type	String

Updated at

The date and time (UTC time zone) when this custom field definition was last updated.

SQL name	`updated_at`
Data type	Datetime

Project custom field saved value

The atlassian_home_project_custom_field_saved_value table contains saved value data of custom fields for projects.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the custom field saved value was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the custom field.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Custom field definition ID

The unique identifier of the custom field definition.

SQL name	`custom_field_definition_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project_custom_field_definition` table.

Custom field save value ID

The unique identifier of the custom field saved value. Use this as the primary key for saved values of custom fields.

SQL name	`custom_field_saved_value_id`
Data type	String

Project ID

The unique identifier of the project that the saved value is associated with.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table.

Sort order

Used to determine where in the list of allowed values this value should be placed.
An allowed value with a lower sortOrder will be earlier in the list.

SQL name	`sort_order`
Data type	Integer

Updated at

The date and time (UTC time zone) when the saved value of the custom field was last updated.

SQL name	`updated_at`
Data type	Datetime

Value

The value of the custom field.

SQL name	`value`
Data type	String

Project milestone

The atlassian_home_project_milestone table contains the latest information on the specific milestones of an Atlassian project.

The table uses the following columns:

Completed at

The date and time (UTC time zone) when the milestone was completed.

SQL name	`completed_at`
Data type	Datetime

Completed in project update ID

The unique identifier of the project update in which the milestone was completed.

SQL name	`completed_in_project_update_id`
Data type	String
Foreign key	Links to a record in the `project_update` table.

Created at

The date and time (UTC time zone) when the milestone was created.

SQL name	`created_at`
Data type	Datetime

Milestone ID

The unique identifier of the milestone. Use this as the primary key for project milestone data.

SQL name	`milestone_id`
Data type	String

Project ID

The unique identifier of the project associated with the milestone.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table.

Status

The status of the milestone.

SQL name	`status`
Data type	String
Example values	not_started in_progress completed

Target date type

The confidence of the target date of the milestone.

SQL name	`target_date_type`
Data type	String
Example values	day month quarter

Targeted at

The date and time (UTC time zone) that the milestone is targeted to be completed.

SQL name	`targeted_at`
Data type	Datetime

Title

The title of the milestone.

SQL name	`title`
Data type	String

Updated at

The date and time (UTC time zone) when the milestone was last updated.

SQL name	`updated_at`
Data type	Datetime

Project tag

The atlassian_home_project_tagtable contains information about tags for projects.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the tag was created.

SQL name	`created_at`
Data type	Datetime

Description

The description of the project tag.

SQL name	`description`
Data type	String

Name

The name of the project tag.

SQL name	`name`
Data type	String

Owned by

The unique identifier of the person who owns the project tag.

SQL name	`owned_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Tag ID

The unique identifier of the project tag. Use this as the primary key for project tag data.

SQL name	`tag_id`
Data type	String

Updated at

The date and time (UTC time zone) when this tag was last updated

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who updated the tag.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Project tag mapping

The atlassian_home_project_tag_mapping holds associations between projects and tags.

The table uses the following columns:

Project ID

The unique identifier for the project that the tag is associated with.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project`table.

Project workspace ID

A workspace identifier for the project associated with the tag.

SQL name	`project_workspace_id`
Data type	String

Relationship ID

Unique identifier for this mapping/relationship.

SQL name	`relationship_id`
Data type	String

Sequence number

Sequence number of the last update to the relationship.

SQL name	`sequence_number`
Data type	Number

Tag ID

The unique identifier of the project tag.

SQL name	`tag_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project_tag` table.

Updated at

The date and time (UTC time zone) when the relationship between the project and tag was last updated.

SQL name	`updated_at`
Data type	Datetime

Project update

The atlassian_home_project_update table contains information about updates to Atlassian projects.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the updated was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the update.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Is missed update

Indicates whether or not the update was missed.

SQL name	`is_missed_update`
Data type	Boolean

New phase

The state of the project after the update.

SQL name	`new_phase`
Data type	String
Example values	pending in progress paused

New status

The status of the project after the update.

SQL name	`new_status`
Data type	String
Example values	off-track on-track completed

New target date type

The type of target date for the update.

SQL name	`new_target_date_type`
Data type	String
Example values	day month quarter

New targeted at

The date and time (UTC time zone) of the target date of the project after the update.

SQL name	`new_targeted_at`
Data type	Datetime

New targeted confidence

The confidence of the target date after the update.

SQL name	`new_targeted_confidence`
Data type	Number

Old phase

The state of the project before the update.

SQL name	`old_phase`
Data type	String
Example values	pending in progress paused

Old status

The status of the project before the update.

SQL name	`old_status`
Data type	String
Example values	off-track on-track completed

Old target date type

The type of target date for the update.

SQL name	`old_target_date_type`
Data type	String
Example values	day month quarter

Old targeted at

The date and time (UTC time zone) of the target date of the project before the update.

SQL name	`old_targeted_at`
Data type	Datetime

Old targeted confidence

The confidence of the target date before the update.

SQL name	`old_targeted_confidence`
Data type	String

Project ID

The unique identifier of the project associated with the update.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table.

Project update ID

The unique identifier of the project update. Use this as the primary key for project update data.

SQL name	`project_update_id`
Data type	String

Summary

The summary of the update.

SQL name	`summary`
Data type	String

Updated at

The date and time (UTC time zone) when the update was last edited.

SQL name	`updated_at`
Data type	Datetime

Updated by

The unique identifier of the person who last edited the update.

SQL name	`updated_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Project update note

The atlassian_home_project_update_note table contains information about notes attached to project updates.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the note was created.

SQL name	`created_at`
Data type	Datetime

Created by

The unique identifier of the person who created the note.

SQL name	`created_by`
Data type	String
Foreign key	Links to a record in the `account` table in the schema for organization data.

Is archived

Indicates whether or not the project associated with the update note is archived.

SQL name	`is_archived`
Data type	Boolean

Project update ID

The unique identifier of the project update associated with the note.

SQL name	`project_update_id`
Data type	String
Foreign key	Links to a record in the `project_update` table.

Summary

The text of the update note.

SQL name	`summary`
Data type	String

Title*

The name of the update note.

SQL name	`title`
Data type	String

Update note ID

The unique identifier of the update note. Use this as the primary key for update note data.

SQL name	`project_update_note_id`
Data type	String

Tables for relationships across apps

Atlassian project Jira work item mapping

The atlassian_home_project_jira_issue_mapping table holds associations between Atlassian projects and Jira work items.

The table uses the following columns:

Jira workspace ID

An Atlassian identifier that maps to the Jira instance that the work item belongs to.

SQL name	`jira_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Project ID

The unique identifier of an Atlassian project.

SQL name	`project_id`
Data type	String
Foreign key	Links to a record in the `atlassian_project` table in the schema for Atlassian Projects.

Project workspace ID

An Atlassian identifier that maps to the Atlassian Projects instance that the project belongs to.

SQL name	`project_workspace_id`
Data type	String
Foreign key	Links to a record in the `workspace` table in the schema for organization data.

Relationship ID

Unique identifier for this mapping/relationship.

SQL name	`relationship_id`
Data type	String

Updated at

The date and time (UTC time zone) when the association between the Atlassian project and the Jira work item was last updated.

SQL name	`updated_at`
Data type	Datetime

Work item ID

The unique identifier of a work item.

SQL name	`issue_id`
Data type	String
Foreign key	Links to a record in the `jira_issue` table in the schema for Jira family of products.

Was this helpful?

It wasn't accurateIt wasn't clearIt wasn't relevant

Still need help?

The Atlassian Community is here for you.

Ask the Community