• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

BCM database scheme

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
#1
Hello together,

does anyone has got a database scheme/ diagramm with all relations, primary and foreign keys of the BCM Database?

would be very helpful for MS Access queries (just reading) on the db.

the most important for me is to see where the user defined fields are defined.

thx

Tobias
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
#3
would be nice if you could post it when back. maximum success on your business trip
 

tlassner

Senior Member
Outlook version
Outlook 2013 32 bit
Email Account
Exchange Server
#4
Hello again,

I generated the database scheme of the BCM database with schemaSpy.

Download, unzip and start index.html in /BCM_Prod:

https://www.dropbox.com/s/go9grlwz81k9ujy/BCM-dbScheme.zip

hint: If you want to access the "userfields" via MS Access you have to cast the binary field into another datatype, e.g. string:

query example:

SELECT CStr(dbo_ContactCatIMAPIView.UserField1) AS [title of user defined field as shown in query]

FROM dbo_ContactCatIMAPIView;
 

jumana

New Member
Outlook version
Outlook 2016 64 bit
Email Account
Exchange Server
#6
Here include about the databased informations.this details are very useful for me.it include more functions and informations are .included in this blog.i got a cl.ear information.thanku so much for including this blog.sugar sachets dubai
 

Similar threads