OfBiz Data Model

[ganapathyraman]

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

Regards,
G.Raman
Senior Technical Director
Sword Global India Pvt Ltd.
5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
_____________________________________
m  [phone]
t    [phone]
e   [hidden email]
www.sword-group.com<http://www.sword-group.com/>


The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.

[rajsaini]

Hello G Raman,

You can run the "run-install" ant target and OFBiz will create schema
along with demo data.

Also, such questions should be asked in user mailing list as dev mailing
list is used for OFBiz development discussion.

Thanks,

Raj

On Wednesday 01 December 2010 03:18 PM, Ganapathyraman Venkatraman 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...
>
> Regards,
> G.Raman
> Senior Technical Director
> Sword Global India Pvt Ltd.
> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
> _____________________________________
> m  [phone]
> t    [phone]
> e   [hidden email]
> www.sword-group.com<http://www.sword-group.com/>
>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
>
>    

[James McGill-5]

On Wed, Dec 1, 2010 at 2:48 AM, Ganapathyraman Venkatraman
<[hidden email]> 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