Project Data Tables Database > td Schema : td.ASSET_RELATIONS Table |
The records in this table represent a uses->used-by relationship. The owner of the record uses the related object.
See AssetRelationFactory.AddItem in the Open Test Architecture API Reference.
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
ASR_ID | The record ID. | int | 4 | ||||
ASR_OWNER_ID | The record ID of the entity that owns this ASSET_RELATIONS record. | int | 4 | ||||
ASR_OWNER_TYPE | The name of the database table for the entity that owns the record. The possible values are the tables listed above in the table description. | varchar | 40 | ||||
ASR_RELATED_ID | The record ID of the used asset. | int | 4 | ||||
ASR_RELATED_TYPE | The name of the database table for the asset. The possible values are the tables listed above in the table description. | varchar | 40 | ||||
ASR_ORDER | A field for use by the testing tool integration. The field is intended to store the position of this asset in the list of the owner's assets. An integration implementation can use it for other purposes, as required. | int | 4 | ||||
ASR_CONDITION | Any string used as a download condition by the tool that uses the asset. If no condition is used, the value is NONE. If ASR_CONDITION is NONE, the ASSET_RELATIONS link is always used when the owner entity is downloaded. Otherwise, the link is only used if the condition is passed to ISupportAssetRelations.DownLoad. See ISupportAssetRelations.DownLoad in the Open Test Architecture API Reference. When the link is used, the related asset is actually downloaded if the conditions of the linked ASSET_REPOSITORY_ITEMS Table are met. For multiple conditions, create records with the same owner and related asset, but with different ASR_CONDITIONs. | varchar | 40 | ||||
ASR_VC_CHECKOUT_USER_NAME | The user who checked out the item under version control. If the item is not checked out, this field is blank. | varchar | 60 | ||||
ASR_DATA_MAPPING | An XML string that describes the mapping of the test parameters to the information in the data resource. For example: <MappingData><MappingElement> <ParameterName><![CDATA[P3&cd;></ParameterName> <MappedToName><![CDATA[Source&cd;></MappedToName> </MappingElement> <MappingElement> <ParameterName><![CDATA[P2&cd;></ParameterName> <MappedToName><![CDATA[Destination&cd;></MappedToName> </MappingElement> <MappingElement> <ParameterName><![CDATA[P1&cd;></ParameterName> <MappedToName><![CDATA[Level&cd;></MappedToName> </MappingElement> </MappingData> | varchar | 16 | ||||
ASR_THE_DATA | Y if this is a relation to a data resource that provides the parameter values to be used in a run. | varchar | 10 |
Index | Description | Primary | Unique |
---|---|---|---|
ASSET_RELATIONS_IDX1 | |||
ASSET_RELATIONS_IDX2 | |||
ASSET_RELATIONS_LWR_IDX4 | |||
ASSET_RELATIONS_LWR_UIX | |||
ASSET_RELATIONS_PK |