Previous Topic: Wgn3UserPropertyValueNext Topic: FileType


WgnFile

This table is used to store details about the files within the CA DataMinder distributed file system.

Column

Primary Key

Datatype

Length

Notes

FileIDM

Part-key identifying a file entry within the CA DataMinder file system.

Yes

INTEGER

4

 

FileID

Part-key identifying a file entry within the CA DataMinder file system.

Yes

INTEGER

4

 

FileVersion

The version of the file within the file system.

Yes

INTEGER

4

The file system allows multiple concurrent versions of the same file.

FileType

The type of the file (eg, file or directory).

 

INTEGER

4

Follow the hyperlink for details.

FileName

The name of the file.

 

VARCHAR

255

 

FileClass

User defined class of the file, provided for file grouping.

 

INTEGER

4

Follow the hyperlink for details.

FileDescription

A use specified description of the file.

 

VARCHAR

255

 

FileAttributes

Attributes of the file.

 

VARCHAR

255

Currently undefined

CreateTimestamp

The time that the file was created.

 

TIMESTAMP

8

 

ModifyTimestamp

The time that the file was modified.

 

TIMESTAMP

8

 

OwnerType

Indicates whether the owner type of the file (eg, user or group).

 

INTEGER

4

 

OwnerIDM

OwnerType specific part-key identifying the file owner.

 

INTEGER

4

 

OwnerID

OwnerType specific part-key identifying the file owner.

 

INTEGER

4

 

ParentIDM

Part-key identifying the files parent.

 

INTEGER

4

Foreign key: WgnFile

ParentID

Part-key identifying the files parent.

 

INTEGER

4

Foreign key: WgnFile

ParentVersion

Part-key identifying the files parent.

 

INTEGER

4

Foreign key: WgnFile

DataIDM

Part-key identifying the BLOB containing the file content.

 

INTEGER

4

Directories have no associated BLOB

Foreign key: WgnBLOB

DataID

Part-key identifying the BLOB containing the file content.

 

INTEGER

4

Directories have no associated BLOB

Foreign key: WgnBLOB

VersionIDM

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionID

Used to detect and resolve replication update collisions.

 

INTEGER

4

 

VersionRanking

Used to detect and resolve replication update collisions.

 

INTEGER

4