Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
File Information Id |
The automatically generated primary key of the file_info table. |
LONG |
Yes |
File Information URI |
This will act as the string that points to the actual location of teh file. The program will use this rather than relationship information stored in the database to find the file. |
VARCHAR(900) |
No |
File Information Size |
The size of the file. |
LONG |
No |
Create Date |
The create date of the file in the repository. |
DATE |
No |
Expiration Date |
Expiry date |
DATE |
No |
Is File Deleted |
A boolean flag meant to indicate that the file has been deleted. This is used in a multi-phase deletion approach, where the deletion might not make it all the way through, and a cleanup process can recover where the deletion left off. |
BOOLEAN |
No |