asset_version
(primary key)

NUMERIC(19)

not null

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

branch_id

VARCHAR(40)

not null

The ID for the branch where the asset exists.

is_head

TINYINT

not null

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

version_deleted

NUMERIC(1)

null

Indicates this version of the asset is deleted (1) from the branch.

version_editable

NUMERIC(1)

null

Indicates whether this version of the asset is editable (1) or read-only (0).

pred_version

NUMERIC(19)

null

The ID for the previous version of the asset.

checkin_date

TIMESTAMP

null

The date when the item was checked in and this version was created.

process_data_id
(primary key)

VARCHAR(40)

not null

The unique ID for the process data item.

type

NUMERIC(19)

not null

The item descriptor associated with the process data item.