Contains information about projects.

Column

Data Type

Constraint

project_id

VARCHAR(40)

not null

(primary key)

Each project has a unique ID.

version

BIGINT

not null

The version of the project object.

acl

VARCHAR(2048)

null

The access control list for the project object.

display_name

WVARCHAR(255)

null

The name of the project object.

description

WVARCHAR(1024)

null

A description of the project object.

creator

VARCHAR(40)

null

The profile ID of the user which created the project.

workspace

VARCHAR(255)

not null

The name of the workspace where this project exists.

workflow_id

VARCHAR(40)

null

The ID of the workflow that this project is using.

checked_in

TINYINT

null

Indicates whether this project is checked in (1) or checked out (0).

editable

TINYINT

null

Indicates whether this project is editable or read only.

status

BIGINT

null

The status of the project. Can be one of Active, Completed, Suspended, Error

status_detail

WVARCHAR(255)

null

Details about the status of the project.

checkin_date

TIMESTAMP

null

The date the project was checked in.

creation_date

TIMESTAMP

null

The creation date of the project.

completion_date

TIMESTAMP

null

The completion date of the project.

 
loading table of contents...