Odoo Help


Oerp v6.0 Database E/R Diagram?

on 2/15/13, 11:50 PM 4,471 views

Hi I would like to know if someone have or if exist a tool to get OERP E/R for the database?

We could like to get this view now that we are staring this new system.

Any comments or info about will be appreciated.




| 5 6 9
Lisse, Netherlands
End-User. Installed 6.1.1 on a DS412+, DS211+ and DS113J Synology NAS. Reference installation on Ubuntu 12.04/Samsung Notebook. 12-03-2013 In production for Suppliers and Customers, adresbook. 7 small companies. Testing accounting, document management, import and export. Too much showstoppers I haven't fixed at this moment. 06-05-2013 little progress. Migration to v7 impossible because of missing Dutch localisation modules. What I see working is nice, so further testing and asking. Start testing products and warehouse. Happy with this forum and the community.
On 2/16/13, 4:44 AM

Because there is no answer given yet: You can use pgAdmin to explore an already working database. Maybe you can use this as a start. I have experience with this and it works fine, however it doesn't present you the diagrams. There seems to be also an opensource tool OOOR - Open Object On Rails with which you can produce OpenERP UML diagrams. I have read about it but I have no hands on experience with this OOOR. There is a blog about this: link text There are also Database Master, DBWrench, Rise, SQLPowerArchitect and Navicat. I have also no experience with these tools.

OOOR looks like a great idea, but; it seems to have gone inactive. After a few hours I gave up trying to get it running on a current version of Ubuntu.

Moore Works, Dale E. Moore
on 2/16/13, 9:56 AM
On 2/16/13, 2:11 PM

there are plenty of tools for doing the job, google for

PostgreSQL - general - Tool for data modeling and ER diagram

and you will see a very long list of database modeling tools

Hi Gustavo. I will test some of the tools for data modeling, I will try to have something this weekend, by next week I will return here with info, if some else would like to share info about will be appreciatd, thanks!!!

on 2/16/13, 2:45 PM
On 2/16/13, 1:46 PM
The main point for us, is that we  want to understand the relations, because we are  working in how we can import our current data, and I think this is necesary to know.

I ask this to all of u that have experience with this great software.

What tools do u recommend us to start learning how each table is connected, I think is important right?

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 2/15/13, 11:50 PM
Seen: 4471 times
Last updated: 3/16/15, 8:10 AM