Footprints Data Model

Table
Table Name Item Field Journal
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
id The automatically generated primary key of the item_field_journal table. LONG Yes
Application User Id A Foreign Key to the Application User table. LONG No
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. INTEGER No
Item Field Definition Id A Foreign Key to the Definition table for an instance of type Definition. LONG Yes
Item Id A Foreign Key to the Item table. LONG Yes
String Value The value of a Item Field Journal, stored as a string. VARCHAR(255) No
Create Date The date that the Item Field Journal was created. DATE Yes