SCMPACKAGE_FILEINFO

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

UF

No

SCMPACKAGEOID

NUMBER

UF

No

FILEINFOOID

NUMBER

Yes

REVISION

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: SCMPACKAGE_FILEINFO_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

SCMPACKAGEOID

Internal identifier of the Package.

See also: SCMPACKAGE_FILEINFO_U_1, SCMPACKAGE_FILEINFO_FK_1.

Key NULL Column Type (Size)

UF

No

SCMPACKAGEOID

NUMBER

FILEINFOOID

Internal identifier of the FileInfo object.

See also: SCMPACKAGE_FILEINFO_U_1, SCMPACKAGE_FILEINFO_FK_2.

Key NULL Column Type (Size)

UF

No

FILEINFOOID

NUMBER

REVISION

VCR Revision (version) of the file that was added to the Package.

Key NULL Column Type (Size)

Yes

REVISION

VARCHAR2(255)

ARCHIVED

For internal use only.

Key NULL Column Type (Size)

Yes

ARCHIVED

NUMBER(1)

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

SCMPACKAGE_FILEINFO_U_1

No

Yes

SCMPACKAGEOIDFILEINFOOID

SCMPACKAGE_FILEINFO_PK

Yes

Yes

OID

SCMPACKAGE_FILEINFO_FK_1

No

No

SCMPACKAGEOID

SCMPACKAGE

SCMPACKAGE_FILEINFO_FK_2

No

No

FILEINFOOID

FILEINFO

Relationships

Referenced Tables

FILEINFO

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

Foreign Key Referenced Column(s)

SCMPACKAGE_FILEINFO_FK_2

OID
SCMPACKAGE

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

Foreign Key Referenced Column(s)

SCMPACKAGE_FILEINFO_FK_1

OID

Referencing Tables

No referencing tables available.

Report Labels

SCMPACKAGE_FILEINFO_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

SCMPACKAGE_FILEINFO_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

SCMPACKAGE_FILEINFO_FILEINFOOID_LABEL

English:

OID

French:

OID

German:

OID

SCMPACKAGE_FILEINFO_OID_LABEL

English:

OID

French:

OID

German:

OID

SCMPACKAGE_FILEINFO_REVISION_LABEL

English:

Revision

French:

Révision

German:

Revision

SCMPACKAGE_FILEINFO_SCMPACKAGEOID_LABEL

English:

OID

French:

OID

German:

OID

SCMPACKAGE_FILEINFO_VERSION_LABEL

English:

Version

French:

Version

German:

Version