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