asset_version
(primary key)

NUMERIC(19)

not null

The 1-based counter that specifies the version of the asset.

workspace_id

VARCHAR(40)

not null

The ID of the workspace where the asset version was initially created.

branch_id

VARCHAR(40)

not null

The ID for the branch containing the asset.

is_head

TINYINT

not null

Indicates whether the asset is the first asset (1) in the branch.

version_deleted

NUMERIC(1)

null

Indicates whether the asset version is a deleted version.

version_editable

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.

pred_version

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.

checkin_date

TIMESTAMP

null

The date the item was checked in.

folder_id
(primary key)

VARCHAR(40)

not null

The ID of the file folder.

acl

VARCHAR(2048)

null

The ACL (Access Control List) for the file folder.

folder_name

WVARCHAR(255)

not null

The name of the file folder.

parent_folder

VARCHAR(40)

null

The parent folder that contains this file folder.