Name |
Datatype |
Comment |
Is PK |
Is FK |
file_info_id |
bigint |
The automatically generated primary key of the file_info table. |
Yes |
No |
file_info_uri |
VARCHAR(900) |
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.
|
No |
No |
file_info_size |
bigint |
The size of the file. |
No |
No |
create_date |
datetime |
The create date of the file in the repository. |
No |
No |
expiration_date |
datetime |
Expiry date |
No |
No |
is_file_deleted |
bit |
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.
|
No |
No |