- The table comments that contains the approver comments during a campaign are inside of BusinessFlowComments table. This table have the column Comment ID.
- With # of column CommentID that is also present in the another table named as "BFTaskComments" it's possible see the in the colum BusinessFlowId #.
- BusinessFlowId is a number too and with this value doing a select in the table BusinessFlows it's possible to disocover what Universe, Owner, Name (of campaign) and other informations from that comment.
- One example:
if Commentid id #1 and BusinessFlowId is #27 you do a select in a third table named as "BusinessFlows" that will have the column "Universe", "Owner", "Name", etc... for that Comment.