Access to add and change pages is restricted. See: https://cwiki.apache.org/confluence/display/OFBIZ/Wiki+access

These diagrams were created from the OFBiz data model and seed data. The tools used include the eomodeld export functionality in the OFBiz WebTools webapp, and then the OmniGraffle application to create the diagrams based on those models.

The diagrams attached to this page are all PDF files. There is a table of contents page, and the diagram pages are split into 4 files. These documents are designed to be printed on 11x17" paper (basically two 8.5x11 pages put together).

Special thanks to Hotwax Media for contributing these excellent documents. They were produced by David E. Jones, Laurian Escalante and John Maw.

  File Modified
PDF File OFBizDatamodelBook_11x17_2of4_20081029.pdf Feb 09, 2010 by David E. Jones
PDF File OFBizDatamodelBook_11x17_4of4_20081029.pdf Feb 09, 2010 by David E. Jones
PDF File OFBizDatamodelBook_11x17_1of4_20081029.pdf Feb 09, 2010 by David E. Jones
PDF File OFBizDatamodelBook_11x17_3of4_20081029.pdf Feb 09, 2010 by David E. Jones
PDF File OFBizDatamodelBook_TOC_20081030.pdf Table of Contents Feb 09, 2010 by David E. Jones
PDF File OFBizDatamodelBook_TOC_20171001.pdf Oct 05, 2017 by Aditya Sharma
PDF File OFBizDatamodelBook_Combined_20171001.pdf Oct 05, 2017 by Aditya Sharma

The Big Book of Apache OFBiz Data Model Released in 2017

Key changes:

  • Colored content with titles according to the internal color pattern.
  • Added a separate page for integration specific entities.
  • Removed technical process diagrams, making it specific for entities.
  • Added 77 new entities.
  • Removed of 8 entities.
  • Added around 200+ new fields in entities (Though major portion includes the addition of description or attrDescription fields in *Attribute or *TypeAttr entities).
  • Removed 24 fields.


    Following are the original data model source files:
  • BigBook2017GraffleFiles.zip

17 Comments

  1. Jacques Le Roux

    This is really great, thanks David, Laurian and John, and HWM at large for this contribution!

    I tried to print them on A4 (21x29.7cm) on Windows XP with a HP-Deskjet 990cxi and did not get great results in spite on many tries/settings. I have also tried to use PFCreator to dispatch the pages and PDF Tiler to tiles them (which works great but only on the 1st page). Any ideas, recommendations ?

    Thanks

    Jacques

  2. aaron goens

    Hello Jacques,

    I had success printing on LTR in Acrobat by choosing

    • Page Scaling: Tile Large Pages
    • Tile Scale: 96%

    I also want to thank everyone involved for this!
    Aaron

    1. Jacques Le Roux

      Thanks Aaron, but I'm afraid it's OK with LTR but not A4

  3. Ron Wheeler

    These will be celebrating their 5th birthday next month.
    How accurate are they?
    Are the sources used to produce these available? 

  4. Jacques Le Roux

    Despite being 5 years old, I believe these graphs are still 95% right (grosso modo), there have not been that much changes in the data model since.

    About the sources, it's at HWM to answer...

  5. Sharan Foga

    I will email Mike Bates at Hotwax about the sources because it would be good to keep these up to date as 95% could become 90% or less over time

  6. Michael Brohl

    +1 Sharan, it would be great to have the sources available for the project.

    1. Sharan Foga

      I've just sent the mail to Mike so will let you know his response

      1. Jacques Le Roux

        Thanks to both of you (smile)

        1. Sharan Foga

          I've got a copy of the source files for this from Anil. It's a 27MB zip file. They are graffle files so not sure if everyone can read or edit them. Tried to load them but am getting 'bad gateway' errors. Will try again tomorrow to see if it's any better - otherwise may look at splitting them up or loading them elsewhere..

           

          1. Aditya Sharma

            I have worked out the OmniGraffle files & updated it according to the latest trunk data model. I will soon upload the files here.

            1. Michael Brohl

              Great, thank you, Aditya!

              1. Jacques Le Roux

                Ouah, indeed thanks Aditya!

            2. Swapnil Mane

              Nice, thanks Aditya!!

            3. Pranay Pandey

              Good one, thanks so much Aditya. I am sure community will find it very useful.

  7. Deepak Dixit

    Nice, Thanks Aditya 

  8. Chandan

    Great, Thanks Aditya!