Footprints Data Model

Table
Name file_info
Comment
The URI in this table is a unique string identifier that points to the file
stored in the jackrabbit tables.

This table is intended to be stand alone, and the application code will use the
URI to actually do a lookup of the things that are attached to this file.

Column
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