Footprints Data Model

Table
Table Name Item Useful Summary
Table Definition A standalone table holding a summary count of the usefulness of an Item, computed by summing the detail.

Attribute
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