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 ?
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.
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:
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.
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) :
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 !
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 4/23/16, 2:37 AM|
|Seen: 688 times|
|Last updated: 7/2/16, 11:43 AM|