Search code examples
openbravo

Openbravo 3 database diagram


I'm from Brazil, and after much research on Opensource ERP's, I chose the Openbravo 3.0 to use in my company.

As I will develop new modules for use in my company, I wonder if anyone has the relationship diagram of the tables in database openbravo3.

Thx!


Solution

  • the E/R diagram for the 3.0 release is not publicly available but the entity model it is on Openbravo's wiki: http://wiki.openbravo.com/wiki/ERP/3.0/Developers_Guide/Reference/Entity_Model

    You can also find the E/R diagram for the 2.3X releases: http://sourceforge.net/projects/openbravo/files/07-openbravo-other/other/ but it is quite old.

    I guess that with more than 200 tables on the database such a E/R document is a bit complex to maintain and not really useful because you can always obtain it (totally or partially) with any database tool like Toad or Aqua Studio. Such database tools have an option to export from the database (or a set of tables) the corresponding E/R diagram.

    From my experience, with the entity model link above and a tool to generate the necessaries E/R diagrams under-demand is more than enough to develop anything in Openbravo ERP.

    Anyway you can always ask in Openbravo's forums: http://forge.openbravo.com/projects/openbravoerp/forum/ maybe someone just created the whole E/R diagram for the 3.0 version and wants to share it.

    Regards,