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. |
The type of the file (eg, file or directory). |
|
INTEGER |
4 |
Follow the hyperlink for details. |
FileName The name of the file. |
|
VARCHAR |
255 |
|
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 |
|
Copyright © 2014 CA.
All rights reserved.
|
|