I am researching Baan V, and I am very interested in the Baan V Database Structure, Can sb provide me the BaanERP Database Structure Diagram to represent the relationship between more than one thousand tables, I know they are so complicated, So if sb provide me a simply one is OK!
Thx in advance.
Jerry

Hi,
There is no direct/ ready made method to get the references across the tables.
The references on the tables are not maintained in the database, rather in the runtime data dictionary. I believe it's not possible to get the reference diagram from database as well.

One option available is Print where used tables. But this is a very tedious job.


regards
Sriks

Thank SriksAdi
Then I summarize them slowly.

Hi Jerry,

Feel free to share the fruits of your work with our community! It would make an interesting section in our Wiki :)

Not all relations are actually defined in the data dictionary. They are simply enforced by program scripts, function libraries etc. Have a look at the link between sales or service orders and delivery addresses and see if you can find any of the relations in the DD.

At least in BaanIV (I guess also in Baan V) there is a build in method to generate such a diagram:

Tools->Application Development->Domains and Tables -> Maintenance

Session: Maintain Idef1-X Diagram Data

Here you can specify for which tables you want a diagram and Baan will generate it. Usefull for a small number of tables. for a big one, you might need an industrial printer :-)

Enjoy

Markus

Dear Markus
Can you tell me the session id in BaanERP 5.0csp2, I did not found it
Jerry