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