Project Data Tables Database > td Schema : td.ASSET_REPOSITORY_ITEMS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
ARI_ID | The record ID. | int | 4 | ||||
ARI_PATH | The file path in the repository relative to the root folder of the entity that owns the asset. | varchar | 255 | ||||
ARI_OWNER_ID | The record ID of the entity that owns the asset. | int | 4 | ||||
ARI_OWNER_TYPE | The name of the database table for the entity that owns the asset. | varchar | 40 | ||||
ARI_SUPPORT_COPY_PASTE | If set to 1, the asset is copied when its owner is copied. | int | 4 | ||||
ARI_SUPPORT_VERSIONING | If set to 1, the asset is placed under version control. | int | 4 | ||||
ARI_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 | ||||
ARI_FILTER | A bitmap for use by the testing tool in calls to ISupportAssetRelations.DownLoad. The bitmap passed to Download is bit-wise ANDed with this bitmap. If the result of the AND is not zero, the item is downloaded with the owner if the conditions of ASSET_RELATIONS record that link it to the owner are met. The meaning of the bits in the mask is a function of the testing tool. If the field is NULL, the asset is always downloaded with the owner if the conditions of ASSET_RELATIONS record that link it to the owner are met. | int | 4 |
Index | Description | Primary | Unique |
---|---|---|---|
ASSET_REPOSITORY_ITEMS_IDX1 | |||
ASSET_REPOSITORY_ITEMS_IDX2 | |||
ASSET_REPOSITORY_ITEMS_IDX3 | |||
ASSET_REPOSITORY_ITEMS_IDX4 | |||
ASSET_REPOSITORY_ITEMS_LWR_UIX | |||
ASSET_REPOSITORY_ITEMS_PK |