Final question : I see almost equal number of attachments in the SQl table ( BH_UserWorkFile ) and folder UserWorkFiles which can be linked using the filenames and userworkfileID. But How will i find the link to attachments in UserAttachments folder and SQL server table ?

How are the files in UserAttachment folder linked to the SQL back up ?

Even in that case i will get the Sender and recipient but not the actual candidate for whom the resume belongs to. Its true if the candidate send it directly but what if there is a middle vendor in between ?

In other words if there is resume belong to John K called 10786.doc in UserAttachment folder how can i find john K's UserId from tables (BH_Usermessagefile, BH_messagercipient .....)