Subject Area : 240 - File Storage
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 240 - File Storage Tables that describe attachments stored in the file system. Details.. Details..
ER Diagram(s) of Subject Area "240 - File Storage"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "240 - File Storage"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 3
. 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. Details..
. 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.
Details..
. item_attch Item Attachment false The link between a file stored in jackrabbit and a container item. Details..
Attribute/Column(s) of Entity/Table "Definition"
# Physical Name Name Definition Physical Data Type
Total 7
. 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)
Attribute/Column(s) of Entity/Table "File Information"
# Physical Name Name Definition Physical Data Type
Total 6
. 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
Attribute/Column(s) of Entity/Table "Item Attachment"
# Physical Name Name Definition Physical Data Type
Total 4
. 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