Footprints Data Model

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

Column
Name Datatype Comment Is PK Is FK
item_useful_sumry_id bigint The automatically generated primary key of the item_useful_sumry table. Yes No
item_defn_id bigint A Foreign Key to the Definition table. Identifies the Container and Item Type. No Yes
item_id bigint A Foreign Key to the generated Dyamic Item table key. Not database enforced. No Yes
yes_ct int The summarized count of Yes responses, calculated from the detail table as stored here for convenience. No No
inaccr_ct int 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. No No
no_ct int 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. No No