asset_version
(primary key)

NUMERIC(19)

not null

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 asset was checked in.

file_asset_id
(primary key)

VARCHAR(40)

not null

The ID of the file asset.

type

NUMERIC(19)

not null

The asset type of the file asset.

acl

VARCHAR(2048)

null

The ACL (Access Control List) for the file.

filename

WVARCHAR(255)

not null

The name of the file asset.

last_modified

TIMESTAMP

null

The date and time the file asset was last modified.

size_bytes

NUMERIC(19)

null

The size of the asset, in bytes.

checksum

BIGINT

null

The 64-bit checksum value for the asset, calculated when the file asset is saved or imported.

parent_folder

VARCHAR(40)

null

The parent folder that contains the file asset.