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 |