Subject Area : 048 - Item Field Journaling
Subject Area Name Definition
048 - Item Field Journaling Any field with journaling turned on will have a collection of historical values in this table, in addition to the current value in the dynamic Item.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
Physical Name Attribute/Column Name Definition Physical Data Type
pwd Password This space intentionally left blank. varchar(255)
user_name User Name The name of the Application User. nvarchar(4000)
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
email_addr Email Address An email address for the Application User. nvarchar(4000)
delete_date Delete Date The value of a Application User, stored as a date. datetime
item Item true true The Item is the abstract class for Issue, Configuration Item, Address Book entry, and other information items that are the main information entities in FootPrints. The Item structure and behavior is defined by its Definition. The Item is namespaced, identified by, and logically stored in the single parent container. It can be referenced in the same manner both inside and outside the container. The Item is the storage model and the implementation for the Item Definition. There are many important specializations of the Item class, and there even more Template definitions of Container/Item that provide an end-user application experience to the End-User. The Item implementation must implement flexible schema in an easy to manage, well engineered, and high performing way. The item can store user-defined and user-named fields defined in its definition. The Item could implement the nice-to-have features such as an inheritance model for Item subtypes, and have the ability to represent collections of subordinate items. The Item data can be imported, exported, or synchronized with external data sources. The Item data can be linked and synchronized with other items in the same Instance.
Physical Name Attribute/Column Name Definition Physical Data Type
item_key Item Key A search key for the Item, composed of letters and numbers. varchar(255)
item_id Item Id The automatically generated primary key of the item table. bigint
cntnr_id Container Id A Foreign Key to the Container table. bigint
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_defn Item Definition true true The definition of an Item, which includes the Item Name and localizations and the collection of Item Fields. It also includes customizations and localizations of string resources for Item Names, and Item Field names.
Physical Name Attribute/Column Name Definition Physical Data Type
item_table_name Item Table Name The name of the DBMS_Object_Name. It is a database object name, limited to 30 characters in length. varchar(30)
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_field Item Field true true A place related to a specific item that stores or displays data.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint
item_field_defn Item Field Definition true true Item Field Definition is an association between the Item Definition entity and the Field Definition entity. This association contains a distinct value for each of the intersection points between the two entities.
Physical Name Attribute/Column Name Definition Physical Data Type
item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_defn_id Item Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
field_defn_id Field Definition Id A Foreign Key to the Definition table. bigint
item_field_journal Item Field Journal false Holds a collection of field values for strings, each of which has create information for the current state of the field. Used when an Item has a multi-line edit field with the journaling feature turned on.
Physical Name Attribute/Column Name Definition Physical Data Type
id id The automatically generated primary key of the item_field_journal table. bigint
app_user_id Application User Id A Foreign Key to the Application User table. bigint
soft_delete_id Soft Delete Id A transaction id that is null for active data and filled in if the item_field_journal row is soft deleted. This allows unique indexes to be defined that include the soft delete id. int
string_val String Value The value of a Item Field Journal, stored as a string. varchar(255)
create_date Create Date The date that the Item Field Journal was created. datetime
item_field_defn_id Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. bigint
item_id Item Id A Foreign Key to the Item table. bigint
wksp_item Ticket Item true true A specialization of Item contained in a Workspace container. Workspace Items are tracked for resolution and closure, and have parties that are awaiting resolution and closure, and responsible parties that perform work against them.
Physical Name Attribute/Column Name Definition Physical Data Type
item_id Item Id A Foreign Key to the Item table. bigint