Stores information about file assets.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | not null |
(primary key) | 1-based counter that specifies the version of the asset | |
| VARCHAR(40) | not null |
The ID of the workspace where the asset version was initially created. | ||
| VARCHAR(40) | not null |
The ID for the branch containing the asset | ||
| TINYINT | not null |
Indicates whether the asset is the first asset (1) in the branch. | ||
| NUMERIC(1) | null |
Indicates whether the asset version is a deleted version. | ||
| NUMERIC(1) | null |
Indicates whether the asset version is an editable version. That is, the version is a working version in a workspace, where modifications to it can be made. | ||
| NUMERIC(19) | null |
The asset version upon which this version was based. For example, if you create version 2 by checking out version 1, version 2’s predecessor version is version 1. | ||
| TIMESTAMP | null |
The date the asset was checked in. | ||
| VARCHAR(40) | not null |
(primary key) | The ID of the file asset. | |
| NUMERIC(19) | not null |
The asset type of the file asset. | ||
| VARCHAR(2048) | null |
The ACL (Access Control List) for the file. | ||
| WVARCHAR(255) | not null |
The name of the file asset. | ||
| TIMESTAMP | null |
The date and time the file asset was last modified. | ||
| NUMERIC(19) | null |
The size of the asset, in bytes. | ||
| BIGINT | null |
The 64-bit checksum value for the asset, calculated when the file asset is saved or imported. | ||
| VARCHAR(40) | null |
The parent folder that contains the file asset. |