Attribute Name |
Attribute Definition |
Logical Datatype |
Is Required |
Item Useful Summary Id |
The automatically generated primary key of the item_useful_sumry table. |
LONG |
Yes |
Item Definition Id |
A Foreign Key to the Definition table. Identifies the Container and Item Type.
|
LONG |
No |
Item Id |
A Foreign Key to the generated Dyamic Item table key. Not database enforced. |
LONG |
No |
Yes Count |
The summarized count of Yes responses, calculated from the detail table as stored here for convenience. |
INTEGER |
No |
No Count |
The summarized count of No responses, calculated from the detail table as stored here for convenience. Perl FP does not show this column, it could be used to calculate a usefullness percentage. |
INTEGER |
No |
Inaccurate Count |
The summarized count of Inaccurate responses, calculated from the detail table as stored here for convenience. Perl FP does not show this column, it could be used to search for inaccurate items. |
INTEGER |
No |