PROJECT

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

No

NAME

VARCHAR2(50)

No

DESCRIPTION

VARCHAR2(512)

Yes

VCRPROJECTNAME

VARCHAR2(50)

Yes

BUILDSCRIPT

VARCHAR2(255)

Yes

DEPLOYSCRIPT

VARCHAR2(255)

Yes

TESTSCRIPT

VARCHAR2(255)

No

BUILDTOOLTYPE

NUMBER

Yes

DEPLOYTOOLTYPE

NUMBER

Yes

TESTTOOLTYPE

NUMBER

Yes

VCROID

NUMBER

No

ISSUETRACKINGSYSTEMOID

NUMBER

No

LOCKED

NUMBER(1)

No

PROJECTTYPE

NUMBER

Yes

USERGROUPOID

NUMBER

Yes

ADMINGROUPOID

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: PROJECT_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

Name of the Project.

Key NULL Column Type (Size)

No

NAME

VARCHAR2(50)

DESCRIPTION

Description for the Project.

Key NULL Column Type (Size)

No

DESCRIPTION

VARCHAR2(512)

VCRPROJECTNAME

The VCR Project Name.

Key NULL Column Type (Size)

Yes

VCRPROJECTNAME

VARCHAR2(50)

BUILDSCRIPT

The Build Script used for the Project.

If the Build Script file is located in the root folder of the Project, it refers to a file name directly, e.g. build.xml

If the Build Script file is located in another folder belonging to the Project, it refers to the relative path to that folder, e.g. /dir1/build/build.xml.

If this field is left blank, all Build Environments in this Project must explicitly specify a Build Script.

Key NULL Column Type (Size)

Yes

BUILDSCRIPT

VARCHAR2(255)

DEPLOYSCRIPT

The Deploy Script used for the Project.

If the Deploy Script file is located in the root folder of the Project, it refers to filename directly, e.g. deploy.xml

If the Deploy Script file is located in another folder belonging to the Project, it refers to the relative path to that folder, e.g. /dir1/deploy/deploy.xml.

If this field is left blank, all Deploy Environments in this Project must explicitly specify a Deploy Script.

Key NULL Column Type (Size)

Yes

DEPLOYSCRIPT

VARCHAR2(255)

TESTSCRIPT

For future use.

Key NULL Column Type (Size)

Yes

TESTSCRIPT

VARCHAR2(255)

BUILDTOOLTYPE

The Build Tool Type used for the Project. Only Scripting Tools of the selected Build Tool Type may be linked to Build Environments that will be created in the Project.

Key NULL Column Type (Size)

No

BUILDTOOLTYPE

NUMBER
Value List

0 = ANT

2 = NANT

3 = MAVEN2

4 = Gradle

DEPLOYTOOLTYPE

The Deploy Tool Type used for the Project. Only Scripting Tools of the selected Deploy Tool Type may be linked to Deploy Environments that will be created in the Project.

Key NULL Column Type (Size)

Yes

DEPLOYTOOLTYPE

NUMBER
Value List

0 = ANT

2 = NANT

3 = MAVEN2

4 = Gradle

TESTTOOLTYPE

The Test Tool Type used for the Project.

Only Scripting Tools of the selected Test Tool Type may be linked to Test Environments that will be created in the Project.

Currently unused.

Key NULL Column Type (Size)

Yes

TESTTOOLTYPE

NUMBER

VCROID

OID identifying the Version Control Repository used by the Project. Refers to the primary key of the appropriate Version Control Repository table: CLEARCASEBASE, CONCURRENTVERSIONSSYSTEM, SUBVERSION or VISUALSOURCESAFE.

Key NULL Column Type (Size)

Yes

VCROID

NUMBER

ISSUETRACKINGSYSTEMOID

Identifier for the GENERICITS table.

For more information, refer to the description of the foreign key PROJECT_GENERICITS_FK.

Key NULL Column Type (Size)

No

ISSUETRACKINGSYSTEMOID

NUMBER

LOCKED

Indication whether or not the Project is locked:

Level Requests can not be created for a locked Project.

Key NULL Column Type (Size)

No

LOCKED

NUMBER(1)
Value List

0 = no

1 = yes

PROJECTTYPE

The project type.

Key NULL Column Type (Size)

No

PROJECTTYPE

NUMBER
Value List

0 = Release-based

1 = Package-based

USERGROUPOID

Identifier for the USERGROUP table.

For more information, refer to the description of the foreign key PROJECT_USERGROUP_FK.

Key NULL Column Type (Size)

Yes

USERGROUPOID

NUMBER

ADMINGROUPOID

Identifier for the USERGROUP table.

For more information, refer to the description of the foreign key PROJECT_USERGROUP_FKv1.

Key NULL Column Type (Size)

Yes

ADMINGROUPOID

NUMBER

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)
Value List

0 = no

1 = yes

ARCHIVEDDATETIME

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVEDDATETIME

DATE

VERSION

For internal use only.

Key NULL Column Type (Size)

No

VERSION

NUMBER

Indexes

Index Primary Unique Column(s) Source Table

PROJECT_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

LIFECYCLE

Refer to the chapter LIFECYCLE for a detailed description of the table.

Foreign Key Referencing Column

LIFECYCLE_FK_1

PROJECTOID
PROJECTSTREAM

Refer to the chapter PROJECTSTREAM for a detailed description of the table.

Foreign Key Referencing Column

PROJECTSTREAM_FK_2

PROJECTOID
SCMLEVEL

Refer to the chapter SCMLEVEL for a detailed description of the table.

Foreign Key Referencing Column

SCMLEVEL_FK_2

PROJECTOID

Report Labels

PROJECT_ADMINGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECT_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

PROJECT_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

PROJECT_BUILDSCRIPT_LABEL

English:

Build Script

French:

Script de construction

German:

Bereitstellungsskript

PROJECT_BUILDTOOLTYPE_LABEL

English:

Build Tool Type

French:

Type outil de construction

German:

Typ des Bereitstellungstool

PROJECT_DEPLOYSCRIPT_LABEL

English:

Deploy Script

French:

Script de déploiement

German:

Auslieferungsskript

PROJECT_DEPLOYTOOLTYPE_LABEL

English:

Deploy Tool Type

French:

Type outil de déploiement

German:

Typ des Auslieferungstool

PROJECT_DESCRIPTION_LABEL

English:

Description

French:

Description

German:

Beschreibung

PROJECT_ISSUETRACKINGSYSTEMOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECT_LOCKED_LABEL

English:

Locked

French:

Verrouillé

German:

Gesperrt

PROJECT_NAME_LABEL

English:

Name

French:

Nom

German:

Name

PROJECT_OID_LABEL

English:

OID

French:

OID

German:

OID

PROJECT_PROJECTTYPE_LABEL

English:

Project Type

French:

Type de Projet

German:

Projekttyp

PROJECT_TESTSCRIPT_LABEL

English:

Test Script

French:

Script de test

German:

Testskript

PROJECT_TESTTOOLTYPE_LABEL

English:

Test Tool Type

French:

Type outil de test

German:

Typ des Teststool

PROJECT_USERGROUPOID_LABEL

English:

OID

French:

OID

German:

OID

PROJECT_VCROID_LABEL

English:

OID

French:

OID

German:

OID

PROJECT_VCRPROJECTNAME_LABEL

English:

VCR Project Name

French:

Nom de Projet dans le RCV

German:

Projektname im VCR

PROJECT_VERSION_LABEL

English:

Version

French:

Version

German:

Version