FILEINFO

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

U

No

NAME

VARCHAR2(255)

U

No

PATH

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: FILEINFO_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

NAME

The name of the file referenced by this FILEINFO.

See also: FILEINFO_U_1.

Key NULL Column Type (Size)

U

No

NAME

VARCHAR2(255)

PATH

The path of the file referenced by this FILEINFO.

See also: FILEINFO_U_1.

Key NULL Column Type (Size)

U

No

PATH

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

FILEINFO_U_1

No

Yes

NAMEPATH

FILEINFO_PK

Yes

Yes

OID

Relationships

Referenced Tables

No referenced tables available.

Referencing Tables

FILEREVISION

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

Foreign Key Referencing Column

FILEREVISION_FK_1

FILEINFOOID
SCMPACKAGE_FILEINFO

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

Foreign Key Referencing Column

SCMPACKAGE_FILEINFO_FK_2

FILEINFOOID

Report Labels

FILEINFO_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

FILEINFO_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

FILEINFO_NAME_LABEL

English:

Name

French:

Nom

German:

Name

FILEINFO_OID_LABEL

English:

OID

French:

OID

German:

OID

FILEINFO_PATH_LABEL

English:

Path

French:

Chemin

German:

Pfad

FILEINFO_VERSION_LABEL

English:

Version

French:

Version

German:

Version