Data share schema for Assets

Analytics is now Insights

All of the Analytics capabilities of the app remain unchanged. You can continue using your existing dashboards, charts, and smart links alongside the new Rovo-powered features. These features combine work and data context to provide reliable answers, create a shared understanding of data, and build dashboards that your team can depend on.

Read about this change

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

The diagram above shows key logical relationships between the tables in the schema for Assets. Columns in bold are the primary keys of the table that they’re in.

Tables for Assets data

Asset object

The asset_object table describes individual objects defined under the object types and object schemas.

The table uses the following columns:

Attributes

An array of the attributes and values of the object.

SQL name	`attributes`
Data type	String

Created at

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

SQL name	`created_at`
Data type	Datetime

Key

The key associated with the object.

SQL name	`key`
Data type	String

Label

The name of the object.

SQL name	`label`
Data type	String

Object ID

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

SQL name	`object_id`
Data type	String

Object reference

The identifier of the object type.

SQL name	`object_ref`
Data type	String

Object schema ID

The unique identifier of the object schema.

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

Type ID

The unique identifier of the object type that the object belongs to.

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

Updated at

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

SQL name	`updated_at`
Data type	Datetime

Asset object schema

The asset_object_schema table describes the names, descriptions, unique identifiers, and creation metadata for all object schemas defined within asset and configuration management.

The table uses the following columns:

Created at

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

SQL name	`created_at`
Data type	Datetime

Description

The description of the object schema.

SQL name	`description`
Data type	String

Display name

The display name of the object schema.

SQL name	`display_name`
Data type	String

Key

The key associated with the object schema.

SQL name	`key`
Data type	String

Name

The name of the object schema.

SQL name	`name`
Data type	String

Object schema ID

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

SQL name	`object_schema_id`
Data type	String

Object schema reference

The identifier of the object schema used at the instance level.

SQL name	`object_schema_ref`
Data type	String

Updated at

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

SQL name	`updated_at`
Data type	Datetime

Asset type

The asset_type table describes the names, descriptions, unique identifiers, and creation metadata for all object types defined within asset and configuration management.

The table uses the following columns:

Created at

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

SQL name	`created_at`
Data type	Datetime

Description

The description of the object type in the schema.

SQL name	`description`
Data type	String

Display name

The display name of the object type.

SQL name	`display_name`
Data type	String

Does pass attributes to child objects

Indicates whether the object type passes its attributes to child objects.

The value is true if does; otherwise, it is false.

SQL name	`does_pass_attributes_to_child_objects`
Data type	Boolean

Is abstract

Indicates whether the object is abstract or not.

The value is true if the object is abstract; otherwise, it is false.

SQL name	`is_abstract`
Data type	Boolean

Name

The name of the object type in the schema.

SQL name	`name`
Data type	String

Parent type ID

The unique identifier of the parent object type.

SQL name	`parent_type_id`
Data type	String
Foreign key	Links to another record in this table.

Schemas

An array with the unique identifiers of the object schema.

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

Type ID

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

SQL name	`type_id`
Data type	String

Type reference

The identifier of the object type.

SQL name	`type_ref`
Data type	String

Updated at

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

SQL name	`updated_at`
Data type	Datetime

Asset type attribute

The asset_type_attribute table provides the metadata for object attributes.

The table uses the following columns:

Asset types

An array that contains the unique identifier of the object type.

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

Created at

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

SQL name	`created_at`
Data type	Datetime

Description

The description of the attribute.

SQL name	`description`
Data type	String

Display name

The display name of the attribute.

SQL name	`display_name`
Data type	String

Name

The name of the attribute.

SQL name	`name`
Data type	String

Type

The type of the attribute.

SQL name	`type`
Data type	String

Type attribute ID

The unique identifier of the object attribute.

SQL name	`type_attribute_id`
Data type	String

Type attribute ref

Internal type attribute identifier used within the application database.

SQL name	`type_attribute_ref`
Data type	String

Updated at

The date and time (UTC timezone) the attribute type was last updated.

SQL name	`updated_at`
Data type	Datetime

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