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 |