BCM database scheme

[tlassner]

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

 

[Diane Poremsky]

I looked in the DB a year or so ago and pulled out some of the information but don't have it with me (I'm traveling on business).

 

[tlassner]

would be nice if you could post it when back. maximum success on your business trip

 

[tlassner]

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;

 

[tlassner]

new Folder to download the scheme:

Dropbox - BCM

 

[jumana]

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