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 © 2012 CA.
All rights reserved.
|
|