Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Expand
titleWorkspace ID

The unique identifier of the asset and configuration management workspace.

SQL name

workspace_id

Data type

String

Foreign key

Links to a record in the workspace table in the schema for organization data.

(blue star) Sample asset_type_attribute_type_mapping table

maps object types to object type attributes. The table uses the following columns:

Expand
titleType attribute ID

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

SQL name

type_attribute_id

Data type

String

Foreign key

Links to a record in the asset_type_attribute_metadata table.

Expand
titleType ID

The unique identifier of the object type.

SQL name

type_id

Data type

String

Foreign key

Links to a record in the asset_type table.

Expand
titleWorkspace ID

The unique identifier of the asset and configuration management workspace.

SQL name

workspace_id

Data type

String

Foreign key

Links to a record in the workspace table in the schema for organization data.

(blue star) Sample asset_type_schema_mapping table

provides links between object types and the object schemas to which they belong. The table uses the following columns:

Expand
titleObject 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.

Expand
titleType ID

The unique identifier of the object type.

SQL name

type_id

Data type

String

Foreign key

Links to a record in the asset_type table.

Expand
titleWorkspace ID

The unique identifier of the asset and configuration management workspace.

SQL name

workspace_id

Data type

String

Foreign key

Links to a record in the workspace table in the schema for organization data.