Stores information about file assets.
Column | Data Type | Constraint | Description |
---|---|---|---|
| NUMERIC(19) | not null | 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 | 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. |