Placing Emails to Original Inbox Subfolders in PST

Post questions on how to interpret your Bullhorn SQL Server backup of your Database.

Moderators: StaffingSupport, s.emmons

Post Reply
vtpadmin
User
Posts: 2
Joined: Wed Jan 15, 2014 7:27 pm

Placing Emails to Original Inbox Subfolders in PST

Post by vtpadmin » Mon Jan 27, 2014 6:39 pm

We successfully created a pst file form the SQL database with the emails and attachments however we need to place the emails into the subfolders that were created by the users.

Could you please let me know the relationship between the users, emails, and the subfolders?

apsmith
Site Admin
Posts: 2051
Joined: Wed Dec 31, 1969 8:00 pm

Re: Placing Emails to Original Inbox Subfolders in PST

Post by apsmith » Tue Feb 25, 2014 10:39 am

Sorry for the delay in responding, there was an issue with the forum notifications.

The messageFolderID column in the BH_MessageRecipient table stores the information for the folder that the message resides in. In the BH_MessageFolder table, the userID column is the owner of the folder.

The BH_MessageRecipient table joins to the BH_usermessage folder in a many to 1 relationship on usermessageID.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Post Reply