Footprints Data Model

Table
Table Name Item Useful Detail
Table Definition An entry from an agent or customer classifying the quality and usefulness of an knowledgebase item or other item.

Attribute
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