On Wed, Dec 1, 2010 at 2:48 AM, Ganapathyraman Venkatraman <[email protected]> wrote: > Hi, > > Appreciate if someone can guide me to get access to the schema dump of OfBiz > database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
It's fairly large, on the order of 800 tables and many relational constraints. If you want an E-R diagram, the best approach may be to install OFBiz and then use an E-R tool to extract the schema as deployed. There are View entities defined in OFBiz that are very important but will not be represented from your schema perspective. I believe the Entity Reference tool and Artifact Info in the Webtools application are far more useful than a schema dump. When working with OFBiz we tend to rely directly on the entitymodel.xml definitions directly. We aren't doing the kind of Object-Relational mapping that is found in other frameworks; we are dealing directly in terms of an entity model. This is one of the main things that sets OFBiz apart from other frameworks. We simply don't think in terms of "data binding" to a relational schema, we use a relational schema *directly* without the object layer. The object binding is done through a loosely coupled Map abstraction, which gives us enormous flexibility while doing away with the heavy emphasis on type safety and strict coupling that we'd have in an ORM. -- James McGill Phoenix AZ
