Footprints Data Model

Table
Name item_field_journal
Comment 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. One table is used at the container level for performance.

Column
Name Datatype Comment Is PK Is FK
id bigint The automatically generated primary key of the item_field_journal table. Yes No
app_user_id bigint A Foreign Key to the Application User table. No Yes
soft_delete_id int 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. No No
item_field_defn_id bigint A Foreign Key to the Definition table. The field definition. No Yes
item_id bigint A Foreign Key to the Item table. No Yes
string_val varchar(255) The value of a Item Field Journal, stored as a string. No No
create_date datetime The date that the Item Field Journal was created. No No