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 |