Access to add and change pages is restricted. See:

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.

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:


  1. 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 ?



  2. 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!

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

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

  4. 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. 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. +1 Sharan, it would be great to have the sources available for the project.

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

        1. 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. I have worked out the OmniGraffle files & updated it according to the latest trunk data model. I will soon upload the files here.

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