BH backup structure

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

Moderators: StaffingSupport, s.emmons

Post Reply
nickpopov
User
Posts: 1
Joined: Wed Oct 04, 2017 3:37 pm

BH backup structure

Post by nickpopov » Wed Oct 04, 2017 3:41 pm

Hello,
in which table I can find attachments (Files, Resumes and etc.) to the Candidates
and where I can find a Notes which connected to the Contacts and Companies and Candidates

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

Re: BH backup structure

Post by apsmith » Thu Oct 05, 2017 10:12 am

Person Files are in the BH_UserWork and BH_UserWorkFile (one row in each per file).
Files linked to emails would be in the BH_UserMessageFile Table.
Files linked to Client Corporations are in the BH_ClientCorporationFile Table.

Notes are stored in the BH_UserComment and BH_UserCommentEntity tables.
Andrew Smith
Director, Technical Operations
Developer Forum Admin

Post Reply