Subject Area : 240 - File Storage
Subject Area Name Definition
240 - File Storage Tables that describe attachments stored in the file system.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
defn Definition false A definition holds the structural and behavioral information needed for an application element that is configuarable by the system designer and/or the end user at definition time. Current Footrpints uses a combination of directories, files, tables, and programming code to represent this information. The new FootPrints will provide all of the same information within the definition. The definition can be persisted in a structure that is isolated at the Instance Level. The data for the definition will be stored as Configuration Settings associated with the Definition Version. See the database views v_defn_ver_active, v_cntnr_item_field.
Physical Name Attribute/Column Name Definition Physical Data Type
defn_id Definition Id The automatically generated primary key of the defn table. bigint
defn_name Definition Name The name of the Definition. nvarchar(4000)
dsble_date Disabled Date The date that this instance of Definition is logically deleted and disabled. datetime
defn_guid Definition GUID A Global Unique IDentifier search key for the Definition, composed of letters and numbers. It is computed by the client and typically used in unstructured data. varchar(50)
defn_type_name Definition Type Name The unique string identifier for an instance of Definition Type. This identifier must be kept in sync with programming code that uses an enumeration constant to identify particular values. A scan program is generally used to populate this table. varchar(255)
defn_subtype_id Definition Subtype Id A Foreign Key to the Definition Subtype table. int
tmpl_export_guid Template Export GUID The value of a Definition, stored as a string. VARCHAR(50)
file_info File Information false 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.
Physical Name Attribute/Column Name Definition Physical Data Type
file_info_id File Information Id The automatically generated primary key of the file_info table. bigint
file_info_uri 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. nvarchar(4000)
file_info_size File Information Size The size of the file. bigint
create_date Create Date The create date of the file in the repository. datetime
is_file_deleted 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. bit
expiration_date Expiration Date Expiry date datetime
item_attch Item Attachment false The link between a file stored in jackrabbit and a container item.
Physical Name Attribute/Column Name Definition Physical Data Type
item_attch_id Item Attachment Id The automatically generated primary key of the item_attch table. bigint
file_info_id File Information Id A Foreign Key to the File Information table. bigint
item_defn_id Item Definition Id A Foreign Key to the Definition table. bigint
item_id Item Id A Foreign Key to the Item Attachment table. bigint