Footprints Data Model

Table
Name item_useful_dtl
Comment
An entry from an agent or customer classifying the quality and usefulness of an
knowledgebase item or other item.

Column
Name Datatype Comment Is PK Is FK
item_useful_dtl_id bigint The automatically generated primary key of the item_useful_dtl 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
app_user_id bigint A Foreign Key to the Application User table. No Yes
user_comment varchar(255) A free-form text comment describing the Item Useful Detail. No No
create_date datetime The date that the Item Useful Detail was created. No No
useful_cd varchar(2) The name of the Useful Code. No Yes