Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Item Useful Detail Id |
The automatically generated primary key of the item_useful_dtl table. |
LONG |
Yes |
Item Definition Id |
A Foreign Key to the Definition table. Identifies the Container and Item Type.
|
LONG |
Yes |
Item Id |
A Foreign Key to the generated Dyamic Item table key. Not database enforced. |
LONG |
Yes |
User Comment |
A free-form text comment describing the Item Useful Detail entry made by the application user. |
VARCHAR(255) |
No |
Application User Id |
A Foreign Key to the Application User table. |
LONG |
No |
Create Date |
The date that the Item Useful Detail was created. |
DATE |
Yes |
Useful Code |
Indicates the level of usefulness recorded by the user. A Foreign Key to the lookup table.
|
VARCHAR(2) |
No |