FILEREVISION

Table Description

Key NULL Column Type (Size)

P

No

OID

NUMBER

UF

No

FILEINFOOID

NUMBER

U

No

REVISION

VARCHAR2(255)

Yes

ARCHIVED

NUMBER(1)

Yes

ARCHIVEDDATETIME

DATE

No

VERSION

NUMBER

Column Descriptions

OID

Unique table identifier.

See also: FILEREVISION_PK.

Key NULL Column Type (Size)

P

No

OID

NUMBER

FILEINFOOID

Internal identifier of the object.

See also: FILEREVISION_U_1, FILEREVISION_FK_1.

Key NULL Column Type (Size)

UF

No

FILEINFOOID

NUMBER

REVISION

The file revision.

See also: FILEREVISION_U_1.

Key NULL Column Type (Size)

U

No

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

FILEREVISION_U_1

No

Yes

REVISIONFILEINFOOID

FILEREVISION_PK

Yes

Yes

OID

FILEREVISION_FK_1

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)

FILEREVISION_FK_1

OID

Referencing Tables

LEVELREQUEST_FILEREVISION

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

Foreign Key Referencing Column

LEVELREQUEST_FILEREVISION_FK_1

FILEREVISIONOID

Report Labels

FILEREVISION_ARCHIVED_LABEL

English:

Archived

French:

Archivé(e)

German:

Archiviert

FILEREVISION_ARCHIVEDDATETIME_LABEL

English:

Archive Date/Time

French:

Date/heure archivage

German:

Datum/Zeit Archivierung

FILEREVISION_FILEINFOOID_LABEL

English:

File Info OID

French:

OID Infos Fichier

German:

OID der Info über die Datei

FILEREVISION_OID_LABEL

English:

OID

French:

OID

German:

OID

FILEREVISION_REVISION_LABEL

English:

Revision

French:

Révision

German:

Revision

FILEREVISION_VERSION_LABEL

English:

Version

French:

Version

German:

Version