BUILDDEPENDENCY

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

F

No

MASTERBUILDOID

NUMBER

F

Yes

CHILDBUILDOID

NUMBER

F

Yes

CHILDLEVELREQUESTOID

NUMBER

No

SEQUENCENUMBER

NUMBER

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: BUILDDEPENDENCY_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

MASTERBUILDOID

Identifier for the BUILD table.

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

See also: BUILDDEPENDENCY_FK_1.

Key NULL Column Type (Size)

F

No

MASTERBUILDOID

NUMBER

CHILDBUILDOID

Identifier for the BUILD table.

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

See also: BUILDDEPENDENCY_FK_2.

Key NULL Column Type (Size)

F

Yes

CHILDBUILDOID

NUMBER

CHILDLEVELREQUESTOID

Identifier for the LEVELREQUEST table.

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

See also: BUILDDEPENDENCY_FK_3.

Key NULL Column Type (Size)

F

Yes

CHILDLEVELREQUESTOID

NUMBER

SEQUENCENUMBER

Number indicating the position of the Build dependency within the sequence of Dependencies associated with the Build.

Key NULL Column Type (Size)

No

SEQUENCENUMBER

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

BUILDDEPENDENCY_PK

Yes

Yes

OID

BUILDDEPENDENCY_FK_1

No

No

MASTERBUILDOID

BUILD

BUILDDEPENDENCY_FK_2

No

No

CHILDBUILDOID

BUILD

BUILDDEPENDENCY_FK_3

No

No

CHILDLEVELREQUESTOID

LEVELREQUEST

Relationships

Referenced Tables

BUILD

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

Foreign Key Referenced Column(s)

BUILDDEPENDENCY_FK_1

OID

BUILDDEPENDENCY_FK_2

OID
LEVELREQUEST

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

Foreign Key Referenced Column(s)

BUILDDEPENDENCY_FK_3

OID

Referencing Tables

No referencing tables available.

Report Labels

BUILDDEPENDENCY_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

BUILDDEPENDENCY_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

BUILDDEPENDENCY_CHILDBUILDOID_LABEL

English:

OID

French:

OID

German:

OID

BUILDDEPENDENCY_CHILDLEVELREQUESTOID_LABEL

English:

OID

French:

OID

German:

OID

BUILDDEPENDENCY_MASTERBUILDOID_LABEL

English:

OID

French:

OID

German:

OID

BUILDDEPENDENCY_OID_LABEL

English:

OID

French:

OID

German:

OID

BUILDDEPENDENCY_SEQUENCENUMBER_LABEL

English:

Sequence Number

French:

Numéro de séquence

German:

Sequenznummer

BUILDDEPENDENCY_VERSION_LABEL

English:

Version

French:

Version

German:

Version