Přejít na obsah
You need to be registered to interact with the community.
All Posts Lidé Odznaky
Štítky (View all)
odoo accounting v14 pos v15
O tomto fóru
This question has been flagged
5 Odpovědi
7920 Zobrazení
Avatar
Lince

Hello,

Is it possible to get the physical data model (PDM) of the database (the database design, a schema), to see the relationships, connections of each table quickly ?

Where can I find it in Odoo9 ?

Thank you.


Avatar
Zrušit
Avatar
Ray Carnes
Nejlepší odpověď

Have you seen https://apps.openerp.com/apps/modules/9.0/erd_maker/

The schema of every Odoo database is unique, because of the ability to install different modules (or not) and to create models from the User Interface.

I have not seen any good options for an ENTIRE database schema tool.

Avatar
Zrušit
Lince
Autor

Thank you Ray for your help, I'll try it ! It's seem to be what I want.

Avatar
john5000
Nejlepší odpověď

One other option. I used SchemaSpy to generate the full physical data model and the result was very useful. Gives html diagrams with link between tables, etc.  See: http://schemaspy.sourceforge.net/

To use it you need:

  • schemaSpy.jar

  • java

  • graphviz.msi  (to install dot.exe). Had to add graphviz to the path so dot.exe could be found by schemaspy.

  • jdbc driver for postgres. 

Avatar
Zrušit
Avatar
Krupesh Laiya
Nejlepší odpověď

you can print model overview from the setting menu in v9 you have to active the developer mode.

and please refer my screencast: http://goo.gl/QRtGWi

Avatar
Zrušit
Avatar
Lince
Autor Nejlepší odpověď

Thank you Krupesh Laiya, your help is usefull.

But I need in fact the design with all the relationships like this (an example of PDM) :

http://epf.eclipse.org/wikis/openupsp/openup_basic/guidances/guidelines/data_modeling,_ienXEEyAEdu-df7p0PuRvQ.html

Does someone know how to do it ?
In the database there are more than 300 tables (in our case with odoo9), and it's not easy to find each relationships and to understand the database created !

Avatar
Zrušit