Stores information about file folder items.
Column | Data Type | Constraint |
---|---|---|
| NUMERIC(19) | not null |
(primary key) | The 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 item was checked in. | ||
| VARCHAR(40) | not null |
(primary key) | The ID of the file folder. | |
| VARCHAR(2048) | null |
The ACL (Access Control List) for the file folder. | ||
| WVARCHAR(255) | not null |
The name of the file folder. | ||
| VARCHAR(40) | null |
The parent folder that contains this file folder. |