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 |