You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by ja...@gmail.com,
ja...@gmail.com on 2018/03/19 14:53:49 UTC
Separation database for inventory module
Hi All,
In Ofbiz I want to create separate database for inventory module with dependency tables like InentoryItem & so on. I don't see any issue foreign key relations between dependency tables(like product, order related) but i see the view entities are using many places in application hence some of the inventory process may breaks.
Appreciate the response/solution for this. Thanks for advance.
Below are the tables list and view entity list.
Inventory Entities
---------------------------
InventoryItem
InventoryItemDetail
InventoryItemAttribute
InventoryItemStatus
InventoryItemTempRes
InventoryItemType
InventoryItemTypeAttr
InventoryItemVariance
InventoryTransfer
OldOrderItemInventoryRes
PhysicalInventory
InventoryItemLabel
InventoryItemLabelAppl
InventoryItemLabelType
OrderItemShipGrpInvRes
View Entity with depenndencies
--------------------------------
OrderHeaderItemAndInv(Not in use)
MemberEntity
-------------
OrderHeader
OrderItem
OrderItemShipGrpInvRes
OrderHeaderItemAndInvRoles(Not in use)
MemberEntity
-------------
OrderHeader
OrderItem
OrderRole
OrderItemShipGrpInvRes
OrderItemAndShipGrpInvResAndItem - Using to calculation time of inventory
MemberEntity
------------
OrderItem
OrderItemShipGrpInvRes
InventoryItem
OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
MemberEntity
------------
OrderItem
OrderItemShipGrpInvRes
InventoryItem
OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
MemberEntity
------------
InventoryItem
OrderItemShipGrpInvRes
ProductInventoryItem - Prouction usage
MemberEntity
------------
Product
InventoryItem
ProductInventoryItemAndItemIssuance
MemberEntity
------------
Product
InventoryItem
ItemIssuance
ItemIssuanceAndInventoryItem
MemberEntity
------------
ItemIssuance
InventoryItem
ItemIssuanceInventoryItemAndProduct
MemberEntity
------------
ItemIssuance
InventoryItem
Product
ProductInventoryItemAndItemIssuance
MemberEntity
------------
Product
InventoryItem
ItemIssuance
InventoryItemAndDetail
MemberEntity
------------
InventoryItem
InventoryItemDetail`
WorkEffortAndInventoryAssign
MemberEntity
------------
InventoryItem
WorkEffortInventoryAssign
WorkEffortAndInventoryProduced`
MemberEntity
------------
WorkEffortInventoryProduced
InventoryItem
Facility Related Entities
-------------------------
Facility
FacilityAttribute
FacilityContactMechPurpose
FacilityContent
FacilityGroup
FacilityGroupMember
FacilityGroupRole
FacilityGroupRollup
FacilityGroupType
FacilityLocation
FacilityLocationGeoPoint
FacilityParty
FacilityType
FacilityTypeAttr
ProdCatalogInvFacility
OldFacilityRole
ProductFacility
ProductFacilityLocation
ProductStoreFacility
View Entity depenndency
---------------------------
ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
MemberEntity
------------
OrderHeader
ProductStoreFacility
ProductStore
Facility
FacilityAndContactMech(Use in OrderView.groovy)
MemberEntity
------------
Facility
FacilityContactMech
ContactMech
FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy and EditFacilityLocation.ftl)
MemberEntity
------------
FacilityLocation
FacilityLocationGeoPoint
GeoPoint
ProductFacilityAndPostalAddress(Not in Use)
MemberEntity
------------
ProductFacility
FacilityContactMech
ContactMech
PostalAddress
Thanks & Regards
Jayachandra
Re: Separation database for inventory module
Posted by ja...@gmail.com,
ja...@gmail.com.
On 2018/03/20 02:43:26, Paul Foxworthy <pa...@cohsoft.com.au> wrote:
> Hi Jaya,
>
> As you've just shown, inventory data is interconnected with many other
> things. If you were to proceed with this, I doubt it could be contributed
> to the OFBiz project.
>
> If you want to integrate OFBiz with other data in other databases, have you
> considered database replication to synchronise OFBiz inventory data with an
> external database?
>
> If the problem is that inventory data could get very large and you want to
> manage separate storage for it, have you considered using a DBMS that
> provides partitioned tables?
>
> Cheers
>
> Paul Foxworthy
>
>
> On 20 March 2018 at 02:23, Rajesh Mallah <ma...@gmail.com> wrote:
>
> > Hello Jaya ,
> >
> > Could you consider hinting why you would want certain entities in a
> > separate database?
> > What are you trying to achieve?
> >
> > regds
> > mallah.
> >
> >
> > On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
> > jayachandra02@gmail.com> wrote:
> >
> > > Hi All,
> > >
> > > In Ofbiz I want to create separate database for inventory module with
> > > dependency tables like InentoryItem & so on. I don't see any issue
> > foreign
> > > key relations between dependency tables(like product, order related) but
> > i
> > > see the view entities are using many places in application hence some of
> > > the inventory process may breaks.
> > >
> > > Appreciate the response/solution for this. Thanks for advance.
> > >
> > > Below are the tables list and view entity list.
> > >
> > > Inventory Entities
> > > ---------------------------
> > >
> > > InventoryItem
> > > InventoryItemDetail
> > > InventoryItemAttribute
> > > InventoryItemStatus
> > > InventoryItemTempRes
> > > InventoryItemType
> > > InventoryItemTypeAttr
> > > InventoryItemVariance
> > > InventoryTransfer
> > > OldOrderItemInventoryRes
> > > PhysicalInventory
> > > InventoryItemLabel
> > > InventoryItemLabelAppl
> > > InventoryItemLabelType
> > > OrderItemShipGrpInvRes
> > >
> > >
> > > View Entity with depenndencies
> > > --------------------------------
> > >
> > > OrderHeaderItemAndInv(Not in use)
> > > MemberEntity
> > > -------------
> > > OrderHeader
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > OrderHeaderItemAndInvRoles(Not in use)
> > > MemberEntity
> > > -------------
> > > OrderHeader
> > > OrderItem
> > > OrderRole
> > > OrderItemShipGrpInvRes
> > >
> > > OrderItemAndShipGrpInvResAndItem - Using to calculation time of
> > inventory
> > > MemberEntity
> > > ------------
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > InventoryItem
> > >
> > > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > > MemberEntity
> > > ------------
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > InventoryItem
> > >
> > > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > OrderItemShipGrpInvRes
> > >
> > > ProductInventoryItem - Prouction usage
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > >
> > > ProductInventoryItemAndItemIssuance
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > > ItemIssuance
> > >
> > > ItemIssuanceAndInventoryItem
> > > MemberEntity
> > > ------------
> > > ItemIssuance
> > > InventoryItem
> > > ItemIssuanceInventoryItemAndProduct
> > > MemberEntity
> > > ------------
> > > ItemIssuance
> > > InventoryItem
> > > Product
> > >
> > > ProductInventoryItemAndItemIssuance
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > > ItemIssuance
> > >
> > > InventoryItemAndDetail
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > InventoryItemDetail`
> > >
> > > WorkEffortAndInventoryAssign
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > WorkEffortInventoryAssign
> > > WorkEffortAndInventoryProduced`
> > > MemberEntity
> > > ------------
> > > WorkEffortInventoryProduced
> > > InventoryItem
> > >
> > >
> > >
> > >
> > >
> > > Facility Related Entities
> > > -------------------------
> > >
> > > Facility
> > > FacilityAttribute
> > > FacilityContactMechPurpose
> > > FacilityContent
> > > FacilityGroup
> > > FacilityGroupMember
> > > FacilityGroupRole
> > > FacilityGroupRollup
> > > FacilityGroupType
> > > FacilityLocation
> > > FacilityLocationGeoPoint
> > > FacilityParty
> > > FacilityType
> > > FacilityTypeAttr
> > > ProdCatalogInvFacility
> > > OldFacilityRole
> > > ProductFacility
> > > ProductFacilityLocation
> > > ProductStoreFacility
> > >
> > >
> > > View Entity depenndency
> > > ---------------------------
> > >
> > > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > > MemberEntity
> > > ------------
> > > OrderHeader
> > > ProductStoreFacility
> > > ProductStore
> > > Facility
> > >
> > > FacilityAndContactMech(Use in OrderView.groovy)
> > > MemberEntity
> > > ------------
> > > Facility
> > > FacilityContactMech
> > > ContactMech
> > >
> > > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy
> > and
> > > EditFacilityLocation.ftl)
> > > MemberEntity
> > > ------------
> > > FacilityLocation
> > > FacilityLocationGeoPoint
> > > GeoPoint
> > > ProductFacilityAndPostalAddress(Not in Use)
> > > MemberEntity
> > > ------------
> > > ProductFacility
> > > FacilityContactMech
> > > ContactMech
> > > PostalAddress
> > >
> > > Thanks & Regards
> > > Jayachandra
> > >
> > >
> >
>
>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: info@coherentsoftware.com.au
> Hey paul,
This is not outside data into ofbiz. We want to manage inventory data as seperate database so that we can have differentiate databases for both transactional(order/product) and inventory process.
Which will help us improving performance in the ofbiz application. Earlier it worked for us with Communication tables which has no dependency for partition to different DB.
Thanks & Regards
Jaya
Re: Separation database for inventory module
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
Hi Jaya,
As you've just shown, inventory data is interconnected with many other
things. If you were to proceed with this, I doubt it could be contributed
to the OFBiz project.
If you want to integrate OFBiz with other data in other databases, have you
considered database replication to synchronise OFBiz inventory data with an
external database?
If the problem is that inventory data could get very large and you want to
manage separate storage for it, have you considered using a DBMS that
provides partitioned tables?
Cheers
Paul Foxworthy
On 20 March 2018 at 02:23, Rajesh Mallah <ma...@gmail.com> wrote:
> Hello Jaya ,
>
> Could you consider hinting why you would want certain entities in a
> separate database?
> What are you trying to achieve?
>
> regds
> mallah.
>
>
> On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
> jayachandra02@gmail.com> wrote:
>
> > Hi All,
> >
> > In Ofbiz I want to create separate database for inventory module with
> > dependency tables like InentoryItem & so on. I don't see any issue
> foreign
> > key relations between dependency tables(like product, order related) but
> i
> > see the view entities are using many places in application hence some of
> > the inventory process may breaks.
> >
> > Appreciate the response/solution for this. Thanks for advance.
> >
> > Below are the tables list and view entity list.
> >
> > Inventory Entities
> > ---------------------------
> >
> > InventoryItem
> > InventoryItemDetail
> > InventoryItemAttribute
> > InventoryItemStatus
> > InventoryItemTempRes
> > InventoryItemType
> > InventoryItemTypeAttr
> > InventoryItemVariance
> > InventoryTransfer
> > OldOrderItemInventoryRes
> > PhysicalInventory
> > InventoryItemLabel
> > InventoryItemLabelAppl
> > InventoryItemLabelType
> > OrderItemShipGrpInvRes
> >
> >
> > View Entity with depenndencies
> > --------------------------------
> >
> > OrderHeaderItemAndInv(Not in use)
> > MemberEntity
> > -------------
> > OrderHeader
> > OrderItem
> > OrderItemShipGrpInvRes
> > OrderHeaderItemAndInvRoles(Not in use)
> > MemberEntity
> > -------------
> > OrderHeader
> > OrderItem
> > OrderRole
> > OrderItemShipGrpInvRes
> >
> > OrderItemAndShipGrpInvResAndItem - Using to calculation time of
> inventory
> > MemberEntity
> > ------------
> > OrderItem
> > OrderItemShipGrpInvRes
> > InventoryItem
> >
> > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > MemberEntity
> > ------------
> > OrderItem
> > OrderItemShipGrpInvRes
> > InventoryItem
> >
> > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > MemberEntity
> > ------------
> > InventoryItem
> > OrderItemShipGrpInvRes
> >
> > ProductInventoryItem - Prouction usage
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> >
> > ProductInventoryItemAndItemIssuance
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> > ItemIssuance
> >
> > ItemIssuanceAndInventoryItem
> > MemberEntity
> > ------------
> > ItemIssuance
> > InventoryItem
> > ItemIssuanceInventoryItemAndProduct
> > MemberEntity
> > ------------
> > ItemIssuance
> > InventoryItem
> > Product
> >
> > ProductInventoryItemAndItemIssuance
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> > ItemIssuance
> >
> > InventoryItemAndDetail
> > MemberEntity
> > ------------
> > InventoryItem
> > InventoryItemDetail`
> >
> > WorkEffortAndInventoryAssign
> > MemberEntity
> > ------------
> > InventoryItem
> > WorkEffortInventoryAssign
> > WorkEffortAndInventoryProduced`
> > MemberEntity
> > ------------
> > WorkEffortInventoryProduced
> > InventoryItem
> >
> >
> >
> >
> >
> > Facility Related Entities
> > -------------------------
> >
> > Facility
> > FacilityAttribute
> > FacilityContactMechPurpose
> > FacilityContent
> > FacilityGroup
> > FacilityGroupMember
> > FacilityGroupRole
> > FacilityGroupRollup
> > FacilityGroupType
> > FacilityLocation
> > FacilityLocationGeoPoint
> > FacilityParty
> > FacilityType
> > FacilityTypeAttr
> > ProdCatalogInvFacility
> > OldFacilityRole
> > ProductFacility
> > ProductFacilityLocation
> > ProductStoreFacility
> >
> >
> > View Entity depenndency
> > ---------------------------
> >
> > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > MemberEntity
> > ------------
> > OrderHeader
> > ProductStoreFacility
> > ProductStore
> > Facility
> >
> > FacilityAndContactMech(Use in OrderView.groovy)
> > MemberEntity
> > ------------
> > Facility
> > FacilityContactMech
> > ContactMech
> >
> > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy
> and
> > EditFacilityLocation.ftl)
> > MemberEntity
> > ------------
> > FacilityLocation
> > FacilityLocationGeoPoint
> > GeoPoint
> > ProductFacilityAndPostalAddress(Not in Use)
> > MemberEntity
> > ------------
> > ProductFacility
> > FacilityContactMech
> > ContactMech
> > PostalAddress
> >
> > Thanks & Regards
> > Jayachandra
> >
> >
>
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: Separation database for inventory module
Posted by Rishi Solanki <ri...@gmail.com>.
Jaya,
How do you register the group under delegator?
If it is under same delegator then it shouldn't be problem ideally. And if
it is different then you should try to register all groups under the same
delegator then it should work.
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Mon, Mar 26, 2018 at 12:29 PM, jayachandra02@gmail.com <
jayachandra02@gmail.com> wrote:
>
>
> On 2018/03/26 05:00:58, Rishi Solanki <ri...@gmail.com> wrote:
> > Paul,
> >
> > Thank you for your reply and more insights. I was just trying to tell the
> > group OFBiz capabilities that how quickly entities can be separated among
> > databases if required (not to everyone but to those who are newer). And
> yes
> > in that case CRUD would be slower and only gains is in reads.
> >
> > If we talk about FKs, I did this in past and in case of mysql it maintain
> > the FKs the referential integrity among different db. I do agree with you
> > on the fact that, this is not good idea to have more database, instead
> > OFBiz supports many ways to retrieve the data way faster rather
> separating
> > the database.
> >
> > So rather that using the separate database, considering the flat
> > information storage would be better idea IMO for faster read.
> >
> > Best Regards,
> >
> >
> > Rishi Solanki
> > Sr Manager, Enterprise Software Development
> > HotWax Systems Pvt. Ltd.
> > Direct: +91-9893287847
> > http://www.hotwaxsystems.com
> > www.hotwax.co
> >
> > On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <pa...@cohsoft.com.au>
> wrote:
> >
> > > On 25 March 2018 at 01:58, Rishi Solanki <ri...@gmail.com>
> wrote:
> > >
> > >
> > > > Register new group in entityengine.xml with new name and data
> resource;
> > > >
> > > > <group-map group-name="your.group.name"
> > > > datasource-name="yourDataResourceName"/>
> > > >
> > > > Add new data resource entry in the entityengine.xml like we have
> many. In
> > > > your case entityengine will contains two entry as localmysql and
> > > > localmysql2 (or any name you prefer).
> > > > Now register all the entities with "your.group.name" in
> > > entity-group.xml.
> > > >
> > > > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > > > datasource-name="localderbytenant"/> and related entries for more
> > > details.
> > > >
> > >
> > > Thanks Rishi.
> > >
> > > If you do define a new group, does that mean:
> > >
> > > - any transaction that modifies entities in two different groups will
> be
> > > slower as the transaction must be a distributed transaction with
> two-phase
> > > commit? To put it another way, with good design decisions, entity
> groups
> > > may well give you faster reads, but writes very likely won't be?
> > > - Foreign key constraints and thus guaranteed referential integrity
> might
> > > not be possible between groups because not all DBMSes support FKs that
> > > refer to another database?
> > >
> > > Thanks
> > >
> > > Paul Foxworthy
> > >
> > > --
> > > Coherent Software Australia Pty Ltd
> > > PO Box 2773
> > > Cheltenham Vic 3192
> > > Australia
> > >
> > > Phone: +61 3 9585 6788
> > > Web: http://www.coherentsoftware.com.au/
> > > Email: info@coherentsoftware.com.au
> > >
> >
>
>
> Hi Rishi,
>
> Thanks for your reply on this.
>
> As i said different entity groups allow us to make different database
> with set of entities. And we have done successfully for communication event
> related tables.
>
> As you said about FKs thats absolutely right about referential integrity
> among different db in mysql.
>
> Coming to the CRUD operations with different groups : ofbiz will create DB
> datasource for each group and maintain the connection pool and perform the
> CRUD operations. While performing ofbiz delegator uses the group related
> datasource connection perform the actions and its depend on the DB how
> quickly respond.
>
> With CommunicationEvent related group in our case was performing good and
> not have the issue with writing how ever it's totally different process
> from order/product info.
>
> Now issue is when we want read data from view entity(tables are in
> differents groups(databases)) then ofbiz only uses primary db connection
> and throwing another table not available error.
>
>
> Like communication event to different for inventory we have so many
> dependent view entities in ofbiz.
>
> So looking for solution to maintain this facility data as separtion from
> the actual process.
>
>
> Thanks & Regards
> Jaya
>
>
>
>
>
Re: Separation database for inventory module
Posted by ja...@gmail.com,
ja...@gmail.com.
On 2018/03/26 05:00:58, Rishi Solanki <ri...@gmail.com> wrote:
> Paul,
>
> Thank you for your reply and more insights. I was just trying to tell the
> group OFBiz capabilities that how quickly entities can be separated among
> databases if required (not to everyone but to those who are newer). And yes
> in that case CRUD would be slower and only gains is in reads.
>
> If we talk about FKs, I did this in past and in case of mysql it maintain
> the FKs the referential integrity among different db. I do agree with you
> on the fact that, this is not good idea to have more database, instead
> OFBiz supports many ways to retrieve the data way faster rather separating
> the database.
>
> So rather that using the separate database, considering the flat
> information storage would be better idea IMO for faster read.
>
> Best Regards,
>
>
> Rishi Solanki
> Sr Manager, Enterprise Software Development
> HotWax Systems Pvt. Ltd.
> Direct: +91-9893287847
> http://www.hotwaxsystems.com
> www.hotwax.co
>
> On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <pa...@cohsoft.com.au> wrote:
>
> > On 25 March 2018 at 01:58, Rishi Solanki <ri...@gmail.com> wrote:
> >
> >
> > > Register new group in entityengine.xml with new name and data resource;
> > >
> > > <group-map group-name="your.group.name"
> > > datasource-name="yourDataResourceName"/>
> > >
> > > Add new data resource entry in the entityengine.xml like we have many. In
> > > your case entityengine will contains two entry as localmysql and
> > > localmysql2 (or any name you prefer).
> > > Now register all the entities with "your.group.name" in
> > entity-group.xml.
> > >
> > > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > > datasource-name="localderbytenant"/> and related entries for more
> > details.
> > >
> >
> > Thanks Rishi.
> >
> > If you do define a new group, does that mean:
> >
> > - any transaction that modifies entities in two different groups will be
> > slower as the transaction must be a distributed transaction with two-phase
> > commit? To put it another way, with good design decisions, entity groups
> > may well give you faster reads, but writes very likely won't be?
> > - Foreign key constraints and thus guaranteed referential integrity might
> > not be possible between groups because not all DBMSes support FKs that
> > refer to another database?
> >
> > Thanks
> >
> > Paul Foxworthy
> >
> > --
> > Coherent Software Australia Pty Ltd
> > PO Box 2773
> > Cheltenham Vic 3192
> > Australia
> >
> > Phone: +61 3 9585 6788
> > Web: http://www.coherentsoftware.com.au/
> > Email: info@coherentsoftware.com.au
> >
>
Hi Rishi,
Thanks for your reply on this.
As i said different entity groups allow us to make different database with set of entities. And we have done successfully for communication event related tables.
As you said about FKs thats absolutely right about referential integrity among different db in mysql.
Coming to the CRUD operations with different groups : ofbiz will create DB datasource for each group and maintain the connection pool and perform the CRUD operations. While performing ofbiz delegator uses the group related datasource connection perform the actions and its depend on the DB how quickly respond.
With CommunicationEvent related group in our case was performing good and not have the issue with writing how ever it's totally different process from order/product info.
Now issue is when we want read data from view entity(tables are in differents groups(databases)) then ofbiz only uses primary db connection and throwing another table not available error.
Like communication event to different for inventory we have so many dependent view entities in ofbiz.
So looking for solution to maintain this facility data as separtion from the actual process.
Thanks & Regards
Jaya
Re: Separation database for inventory module
Posted by Rishi Solanki <ri...@gmail.com>.
Paul,
Thank you for your reply and more insights. I was just trying to tell the
group OFBiz capabilities that how quickly entities can be separated among
databases if required (not to everyone but to those who are newer). And yes
in that case CRUD would be slower and only gains is in reads.
If we talk about FKs, I did this in past and in case of mysql it maintain
the FKs the referential integrity among different db. I do agree with you
on the fact that, this is not good idea to have more database, instead
OFBiz supports many ways to retrieve the data way faster rather separating
the database.
So rather that using the separate database, considering the flat
information storage would be better idea IMO for faster read.
Best Regards,
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Sun, Mar 25, 2018 at 7:12 AM, Paul Foxworthy <pa...@cohsoft.com.au> wrote:
> On 25 March 2018 at 01:58, Rishi Solanki <ri...@gmail.com> wrote:
>
>
> > Register new group in entityengine.xml with new name and data resource;
> >
> > <group-map group-name="your.group.name"
> > datasource-name="yourDataResourceName"/>
> >
> > Add new data resource entry in the entityengine.xml like we have many. In
> > your case entityengine will contains two entry as localmysql and
> > localmysql2 (or any name you prefer).
> > Now register all the entities with "your.group.name" in
> entity-group.xml.
> >
> > Refer <group-map group-name="org.apache.ofbiz.tenant"
> > datasource-name="localderbytenant"/> and related entries for more
> details.
> >
>
> Thanks Rishi.
>
> If you do define a new group, does that mean:
>
> - any transaction that modifies entities in two different groups will be
> slower as the transaction must be a distributed transaction with two-phase
> commit? To put it another way, with good design decisions, entity groups
> may well give you faster reads, but writes very likely won't be?
> - Foreign key constraints and thus guaranteed referential integrity might
> not be possible between groups because not all DBMSes support FKs that
> refer to another database?
>
> Thanks
>
> Paul Foxworthy
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: info@coherentsoftware.com.au
>
Re: Separation database for inventory module
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
On 25 March 2018 at 01:58, Rishi Solanki <ri...@gmail.com> wrote:
> Register new group in entityengine.xml with new name and data resource;
>
> <group-map group-name="your.group.name"
> datasource-name="yourDataResourceName"/>
>
> Add new data resource entry in the entityengine.xml like we have many. In
> your case entityengine will contains two entry as localmysql and
> localmysql2 (or any name you prefer).
> Now register all the entities with "your.group.name" in entity-group.xml.
>
> Refer <group-map group-name="org.apache.ofbiz.tenant"
> datasource-name="localderbytenant"/> and related entries for more details.
>
Thanks Rishi.
If you do define a new group, does that mean:
- any transaction that modifies entities in two different groups will be
slower as the transaction must be a distributed transaction with two-phase
commit? To put it another way, with good design decisions, entity groups
may well give you faster reads, but writes very likely won't be?
- Foreign key constraints and thus guaranteed referential integrity might
not be possible between groups because not all DBMSes support FKs that
refer to another database?
Thanks
Paul Foxworthy
--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia
Phone: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: Separation database for inventory module
Posted by Rishi Solanki <ri...@gmail.com>.
Hi Jayachandra,
Register new group in entityengine.xml with new name and data resource;
<group-map group-name="your.group.name"
datasource-name="yourDataResourceName"/>
Add new data resource entry in the entityengine.xml like we have many. In
your case entityengine will contains two entry as localmysql and
localmysql2 (or any name you prefer).
Now register all the entities with "your.group.name" in entity-group.xml.
Refer <group-map group-name="org.apache.ofbiz.tenant"
datasource-name="localderbytenant"/> and related entries for more details.
HTH!
Rishi Solanki
Sr Manager, Enterprise Software Development
HotWax Systems Pvt. Ltd.
Direct: +91-9893287847
http://www.hotwaxsystems.com
www.hotwax.co
On Tue, Mar 20, 2018 at 3:45 PM, Rajesh Mallah <ma...@gmail.com>
wrote:
> Hi Jaya ,
>
> thanks for sharing the interesting details . Pls allow some time for
> detailed reply
> which database do you use btw?
>
> regds
> Mallah.
>
> On Tue, Mar 20, 2018 at 2:40 PM, jayachandra02@gmail.com <
> jayachandra02@gmail.com> wrote:
>
> >
> >
> > On 2018/03/19 15:23:07, Rajesh Mallah <ma...@gmail.com> wrote:
> > > Hello Jaya ,
> > >
> > > Could you consider hinting why you would want certain entities in a
> > > separate database?
> > > What are you trying to achieve?
> > >
> > > regds
> > > mallah.
> > >
> > >
> > > On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
> > > jayachandra02@gmail.com> wrote:
> > >
> > > > Hi All,
> > > >
> > > > In Ofbiz I want to create separate database for inventory module
> with
> > > > dependency tables like InentoryItem & so on. I don't see any issue
> > foreign
> > > > key relations between dependency tables(like product, order related)
> > but i
> > > > see the view entities are using many places in application hence some
> > of
> > > > the inventory process may breaks.
> > > >
> > > > Appreciate the response/solution for this. Thanks for advance.
> > > >
> > > > Below are the tables list and view entity list.
> > > >
> > > > Inventory Entities
> > > > ---------------------------
> > > >
> > > > InventoryItem
> > > > InventoryItemDetail
> > > > InventoryItemAttribute
> > > > InventoryItemStatus
> > > > InventoryItemTempRes
> > > > InventoryItemType
> > > > InventoryItemTypeAttr
> > > > InventoryItemVariance
> > > > InventoryTransfer
> > > > OldOrderItemInventoryRes
> > > > PhysicalInventory
> > > > InventoryItemLabel
> > > > InventoryItemLabelAppl
> > > > InventoryItemLabelType
> > > > OrderItemShipGrpInvRes
> > > >
> > > >
> > > > View Entity with depenndencies
> > > > --------------------------------
> > > >
> > > > OrderHeaderItemAndInv(Not in use)
> > > > MemberEntity
> > > > -------------
> > > > OrderHeader
> > > > OrderItem
> > > > OrderItemShipGrpInvRes
> > > > OrderHeaderItemAndInvRoles(Not in use)
> > > > MemberEntity
> > > > -------------
> > > > OrderHeader
> > > > OrderItem
> > > > OrderRole
> > > > OrderItemShipGrpInvRes
> > > >
> > > > OrderItemAndShipGrpInvResAndItem - Using to calculation time of
> > inventory
> > > > MemberEntity
> > > > ------------
> > > > OrderItem
> > > > OrderItemShipGrpInvRes
> > > > InventoryItem
> > > >
> > > > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > > > MemberEntity
> > > > ------------
> > > > OrderItem
> > > > OrderItemShipGrpInvRes
> > > > InventoryItem
> > > >
> > > > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > > > MemberEntity
> > > > ------------
> > > > InventoryItem
> > > > OrderItemShipGrpInvRes
> > > >
> > > > ProductInventoryItem - Prouction usage
> > > > MemberEntity
> > > > ------------
> > > > Product
> > > > InventoryItem
> > > >
> > > > ProductInventoryItemAndItemIssuance
> > > > MemberEntity
> > > > ------------
> > > > Product
> > > > InventoryItem
> > > > ItemIssuance
> > > >
> > > > ItemIssuanceAndInventoryItem
> > > > MemberEntity
> > > > ------------
> > > > ItemIssuance
> > > > InventoryItem
> > > > ItemIssuanceInventoryItemAndProduct
> > > > MemberEntity
> > > > ------------
> > > > ItemIssuance
> > > > InventoryItem
> > > > Product
> > > >
> > > > ProductInventoryItemAndItemIssuance
> > > > MemberEntity
> > > > ------------
> > > > Product
> > > > InventoryItem
> > > > ItemIssuance
> > > >
> > > > InventoryItemAndDetail
> > > > MemberEntity
> > > > ------------
> > > > InventoryItem
> > > > InventoryItemDetail`
> > > >
> > > > WorkEffortAndInventoryAssign
> > > > MemberEntity
> > > > ------------
> > > > InventoryItem
> > > > WorkEffortInventoryAssign
> > > > WorkEffortAndInventoryProduced`
> > > > MemberEntity
> > > > ------------
> > > > WorkEffortInventoryProduced
> > > > InventoryItem
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Facility Related Entities
> > > > -------------------------
> > > >
> > > > Facility
> > > > FacilityAttribute
> > > > FacilityContactMechPurpose
> > > > FacilityContent
> > > > FacilityGroup
> > > > FacilityGroupMember
> > > > FacilityGroupRole
> > > > FacilityGroupRollup
> > > > FacilityGroupType
> > > > FacilityLocation
> > > > FacilityLocationGeoPoint
> > > > FacilityParty
> > > > FacilityType
> > > > FacilityTypeAttr
> > > > ProdCatalogInvFacility
> > > > OldFacilityRole
> > > > ProductFacility
> > > > ProductFacilityLocation
> > > > ProductStoreFacility
> > > >
> > > >
> > > > View Entity depenndency
> > > > ---------------------------
> > > >
> > > > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > > > MemberEntity
> > > > ------------
> > > > OrderHeader
> > > > ProductStoreFacility
> > > > ProductStore
> > > > Facility
> > > >
> > > > FacilityAndContactMech(Use in OrderView.groovy)
> > > > MemberEntity
> > > > ------------
> > > > Facility
> > > > FacilityContactMech
> > > > ContactMech
> > > >
> > > > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.
> groovy
> > and
> > > > EditFacilityLocation.ftl)
> > > > MemberEntity
> > > > ------------
> > > > FacilityLocation
> > > > FacilityLocationGeoPoint
> > > > GeoPoint
> > > > ProductFacilityAndPostalAddress(Not in Use)
> > > > MemberEntity
> > > > ------------
> > > > ProductFacility
> > > > FacilityContactMech
> > > > ContactMech
> > > > PostalAddress
> > > >
> > > > Thanks & Regards
> > > > Jayachandra
> > > >
> > > >
> > > Hi Rajesh,
> >
> > I am going to create facility for each supplier(In my case which is
> approx
> > 300) and each facility has all products info(In my case 7000 products)
> > which means i am going to nearly 21 lac records in the entities.
> >
> > So performing inventory CURD operation on inventory
> > tables(reserve/receive) is going to be high. And which may also cause the
> > actual performance issue with transactional data (order, product).
> >
> > To remove dependency with order/product info i am planning to do this.
> >
> > Thanks & Regards
> > Jaya
> >
> >
> >
>
Re: Separation database for inventory module
Posted by Rajesh Mallah <ma...@gmail.com>.
Hi Jaya ,
thanks for sharing the interesting details . Pls allow some time for
detailed reply
which database do you use btw?
regds
Mallah.
On Tue, Mar 20, 2018 at 2:40 PM, jayachandra02@gmail.com <
jayachandra02@gmail.com> wrote:
>
>
> On 2018/03/19 15:23:07, Rajesh Mallah <ma...@gmail.com> wrote:
> > Hello Jaya ,
> >
> > Could you consider hinting why you would want certain entities in a
> > separate database?
> > What are you trying to achieve?
> >
> > regds
> > mallah.
> >
> >
> > On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
> > jayachandra02@gmail.com> wrote:
> >
> > > Hi All,
> > >
> > > In Ofbiz I want to create separate database for inventory module with
> > > dependency tables like InentoryItem & so on. I don't see any issue
> foreign
> > > key relations between dependency tables(like product, order related)
> but i
> > > see the view entities are using many places in application hence some
> of
> > > the inventory process may breaks.
> > >
> > > Appreciate the response/solution for this. Thanks for advance.
> > >
> > > Below are the tables list and view entity list.
> > >
> > > Inventory Entities
> > > ---------------------------
> > >
> > > InventoryItem
> > > InventoryItemDetail
> > > InventoryItemAttribute
> > > InventoryItemStatus
> > > InventoryItemTempRes
> > > InventoryItemType
> > > InventoryItemTypeAttr
> > > InventoryItemVariance
> > > InventoryTransfer
> > > OldOrderItemInventoryRes
> > > PhysicalInventory
> > > InventoryItemLabel
> > > InventoryItemLabelAppl
> > > InventoryItemLabelType
> > > OrderItemShipGrpInvRes
> > >
> > >
> > > View Entity with depenndencies
> > > --------------------------------
> > >
> > > OrderHeaderItemAndInv(Not in use)
> > > MemberEntity
> > > -------------
> > > OrderHeader
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > OrderHeaderItemAndInvRoles(Not in use)
> > > MemberEntity
> > > -------------
> > > OrderHeader
> > > OrderItem
> > > OrderRole
> > > OrderItemShipGrpInvRes
> > >
> > > OrderItemAndShipGrpInvResAndItem - Using to calculation time of
> inventory
> > > MemberEntity
> > > ------------
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > InventoryItem
> > >
> > > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > > MemberEntity
> > > ------------
> > > OrderItem
> > > OrderItemShipGrpInvRes
> > > InventoryItem
> > >
> > > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > OrderItemShipGrpInvRes
> > >
> > > ProductInventoryItem - Prouction usage
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > >
> > > ProductInventoryItemAndItemIssuance
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > > ItemIssuance
> > >
> > > ItemIssuanceAndInventoryItem
> > > MemberEntity
> > > ------------
> > > ItemIssuance
> > > InventoryItem
> > > ItemIssuanceInventoryItemAndProduct
> > > MemberEntity
> > > ------------
> > > ItemIssuance
> > > InventoryItem
> > > Product
> > >
> > > ProductInventoryItemAndItemIssuance
> > > MemberEntity
> > > ------------
> > > Product
> > > InventoryItem
> > > ItemIssuance
> > >
> > > InventoryItemAndDetail
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > InventoryItemDetail`
> > >
> > > WorkEffortAndInventoryAssign
> > > MemberEntity
> > > ------------
> > > InventoryItem
> > > WorkEffortInventoryAssign
> > > WorkEffortAndInventoryProduced`
> > > MemberEntity
> > > ------------
> > > WorkEffortInventoryProduced
> > > InventoryItem
> > >
> > >
> > >
> > >
> > >
> > > Facility Related Entities
> > > -------------------------
> > >
> > > Facility
> > > FacilityAttribute
> > > FacilityContactMechPurpose
> > > FacilityContent
> > > FacilityGroup
> > > FacilityGroupMember
> > > FacilityGroupRole
> > > FacilityGroupRollup
> > > FacilityGroupType
> > > FacilityLocation
> > > FacilityLocationGeoPoint
> > > FacilityParty
> > > FacilityType
> > > FacilityTypeAttr
> > > ProdCatalogInvFacility
> > > OldFacilityRole
> > > ProductFacility
> > > ProductFacilityLocation
> > > ProductStoreFacility
> > >
> > >
> > > View Entity depenndency
> > > ---------------------------
> > >
> > > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > > MemberEntity
> > > ------------
> > > OrderHeader
> > > ProductStoreFacility
> > > ProductStore
> > > Facility
> > >
> > > FacilityAndContactMech(Use in OrderView.groovy)
> > > MemberEntity
> > > ------------
> > > Facility
> > > FacilityContactMech
> > > ContactMech
> > >
> > > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy
> and
> > > EditFacilityLocation.ftl)
> > > MemberEntity
> > > ------------
> > > FacilityLocation
> > > FacilityLocationGeoPoint
> > > GeoPoint
> > > ProductFacilityAndPostalAddress(Not in Use)
> > > MemberEntity
> > > ------------
> > > ProductFacility
> > > FacilityContactMech
> > > ContactMech
> > > PostalAddress
> > >
> > > Thanks & Regards
> > > Jayachandra
> > >
> > >
> > Hi Rajesh,
>
> I am going to create facility for each supplier(In my case which is approx
> 300) and each facility has all products info(In my case 7000 products)
> which means i am going to nearly 21 lac records in the entities.
>
> So performing inventory CURD operation on inventory
> tables(reserve/receive) is going to be high. And which may also cause the
> actual performance issue with transactional data (order, product).
>
> To remove dependency with order/product info i am planning to do this.
>
> Thanks & Regards
> Jaya
>
>
>
Re: Separation database for inventory module
Posted by ja...@gmail.com,
ja...@gmail.com.
On 2018/03/19 15:23:07, Rajesh Mallah <ma...@gmail.com> wrote:
> Hello Jaya ,
>
> Could you consider hinting why you would want certain entities in a
> separate database?
> What are you trying to achieve?
>
> regds
> mallah.
>
>
> On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
> jayachandra02@gmail.com> wrote:
>
> > Hi All,
> >
> > In Ofbiz I want to create separate database for inventory module with
> > dependency tables like InentoryItem & so on. I don't see any issue foreign
> > key relations between dependency tables(like product, order related) but i
> > see the view entities are using many places in application hence some of
> > the inventory process may breaks.
> >
> > Appreciate the response/solution for this. Thanks for advance.
> >
> > Below are the tables list and view entity list.
> >
> > Inventory Entities
> > ---------------------------
> >
> > InventoryItem
> > InventoryItemDetail
> > InventoryItemAttribute
> > InventoryItemStatus
> > InventoryItemTempRes
> > InventoryItemType
> > InventoryItemTypeAttr
> > InventoryItemVariance
> > InventoryTransfer
> > OldOrderItemInventoryRes
> > PhysicalInventory
> > InventoryItemLabel
> > InventoryItemLabelAppl
> > InventoryItemLabelType
> > OrderItemShipGrpInvRes
> >
> >
> > View Entity with depenndencies
> > --------------------------------
> >
> > OrderHeaderItemAndInv(Not in use)
> > MemberEntity
> > -------------
> > OrderHeader
> > OrderItem
> > OrderItemShipGrpInvRes
> > OrderHeaderItemAndInvRoles(Not in use)
> > MemberEntity
> > -------------
> > OrderHeader
> > OrderItem
> > OrderRole
> > OrderItemShipGrpInvRes
> >
> > OrderItemAndShipGrpInvResAndItem - Using to calculation time of inventory
> > MemberEntity
> > ------------
> > OrderItem
> > OrderItemShipGrpInvRes
> > InventoryItem
> >
> > OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> > MemberEntity
> > ------------
> > OrderItem
> > OrderItemShipGrpInvRes
> > InventoryItem
> >
> > OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> > MemberEntity
> > ------------
> > InventoryItem
> > OrderItemShipGrpInvRes
> >
> > ProductInventoryItem - Prouction usage
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> >
> > ProductInventoryItemAndItemIssuance
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> > ItemIssuance
> >
> > ItemIssuanceAndInventoryItem
> > MemberEntity
> > ------------
> > ItemIssuance
> > InventoryItem
> > ItemIssuanceInventoryItemAndProduct
> > MemberEntity
> > ------------
> > ItemIssuance
> > InventoryItem
> > Product
> >
> > ProductInventoryItemAndItemIssuance
> > MemberEntity
> > ------------
> > Product
> > InventoryItem
> > ItemIssuance
> >
> > InventoryItemAndDetail
> > MemberEntity
> > ------------
> > InventoryItem
> > InventoryItemDetail`
> >
> > WorkEffortAndInventoryAssign
> > MemberEntity
> > ------------
> > InventoryItem
> > WorkEffortInventoryAssign
> > WorkEffortAndInventoryProduced`
> > MemberEntity
> > ------------
> > WorkEffortInventoryProduced
> > InventoryItem
> >
> >
> >
> >
> >
> > Facility Related Entities
> > -------------------------
> >
> > Facility
> > FacilityAttribute
> > FacilityContactMechPurpose
> > FacilityContent
> > FacilityGroup
> > FacilityGroupMember
> > FacilityGroupRole
> > FacilityGroupRollup
> > FacilityGroupType
> > FacilityLocation
> > FacilityLocationGeoPoint
> > FacilityParty
> > FacilityType
> > FacilityTypeAttr
> > ProdCatalogInvFacility
> > OldFacilityRole
> > ProductFacility
> > ProductFacilityLocation
> > ProductStoreFacility
> >
> >
> > View Entity depenndency
> > ---------------------------
> >
> > ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> > MemberEntity
> > ------------
> > OrderHeader
> > ProductStoreFacility
> > ProductStore
> > Facility
> >
> > FacilityAndContactMech(Use in OrderView.groovy)
> > MemberEntity
> > ------------
> > Facility
> > FacilityContactMech
> > ContactMech
> >
> > FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy and
> > EditFacilityLocation.ftl)
> > MemberEntity
> > ------------
> > FacilityLocation
> > FacilityLocationGeoPoint
> > GeoPoint
> > ProductFacilityAndPostalAddress(Not in Use)
> > MemberEntity
> > ------------
> > ProductFacility
> > FacilityContactMech
> > ContactMech
> > PostalAddress
> >
> > Thanks & Regards
> > Jayachandra
> >
> >
> Hi Rajesh,
I am going to create facility for each supplier(In my case which is approx 300) and each facility has all products info(In my case 7000 products) which means i am going to nearly 21 lac records in the entities.
So performing inventory CURD operation on inventory tables(reserve/receive) is going to be high. And which may also cause the actual performance issue with transactional data (order, product).
To remove dependency with order/product info i am planning to do this.
Thanks & Regards
Jaya
Re: Separation database for inventory module
Posted by Rajesh Mallah <ma...@gmail.com>.
Hello Jaya ,
Could you consider hinting why you would want certain entities in a
separate database?
What are you trying to achieve?
regds
mallah.
On Mon, Mar 19, 2018 at 8:23 PM, jayachandra02@gmail.com <
jayachandra02@gmail.com> wrote:
> Hi All,
>
> In Ofbiz I want to create separate database for inventory module with
> dependency tables like InentoryItem & so on. I don't see any issue foreign
> key relations between dependency tables(like product, order related) but i
> see the view entities are using many places in application hence some of
> the inventory process may breaks.
>
> Appreciate the response/solution for this. Thanks for advance.
>
> Below are the tables list and view entity list.
>
> Inventory Entities
> ---------------------------
>
> InventoryItem
> InventoryItemDetail
> InventoryItemAttribute
> InventoryItemStatus
> InventoryItemTempRes
> InventoryItemType
> InventoryItemTypeAttr
> InventoryItemVariance
> InventoryTransfer
> OldOrderItemInventoryRes
> PhysicalInventory
> InventoryItemLabel
> InventoryItemLabelAppl
> InventoryItemLabelType
> OrderItemShipGrpInvRes
>
>
> View Entity with depenndencies
> --------------------------------
>
> OrderHeaderItemAndInv(Not in use)
> MemberEntity
> -------------
> OrderHeader
> OrderItem
> OrderItemShipGrpInvRes
> OrderHeaderItemAndInvRoles(Not in use)
> MemberEntity
> -------------
> OrderHeader
> OrderItem
> OrderRole
> OrderItemShipGrpInvRes
>
> OrderItemAndShipGrpInvResAndItem - Using to calculation time of inventory
> MemberEntity
> ------------
> OrderItem
> OrderItemShipGrpInvRes
> InventoryItem
>
> OrderItemAndShipGrpInvResAndItemSum - Packing time using in ofbiz
> MemberEntity
> ------------
> OrderItem
> OrderItemShipGrpInvRes
> InventoryItem
>
> OrderItemShipGrpInvResAndItem - Reserve time usage in ofbiz
> MemberEntity
> ------------
> InventoryItem
> OrderItemShipGrpInvRes
>
> ProductInventoryItem - Prouction usage
> MemberEntity
> ------------
> Product
> InventoryItem
>
> ProductInventoryItemAndItemIssuance
> MemberEntity
> ------------
> Product
> InventoryItem
> ItemIssuance
>
> ItemIssuanceAndInventoryItem
> MemberEntity
> ------------
> ItemIssuance
> InventoryItem
> ItemIssuanceInventoryItemAndProduct
> MemberEntity
> ------------
> ItemIssuance
> InventoryItem
> Product
>
> ProductInventoryItemAndItemIssuance
> MemberEntity
> ------------
> Product
> InventoryItem
> ItemIssuance
>
> InventoryItemAndDetail
> MemberEntity
> ------------
> InventoryItem
> InventoryItemDetail`
>
> WorkEffortAndInventoryAssign
> MemberEntity
> ------------
> InventoryItem
> WorkEffortInventoryAssign
> WorkEffortAndInventoryProduced`
> MemberEntity
> ------------
> WorkEffortInventoryProduced
> InventoryItem
>
>
>
>
>
> Facility Related Entities
> -------------------------
>
> Facility
> FacilityAttribute
> FacilityContactMechPurpose
> FacilityContent
> FacilityGroup
> FacilityGroupMember
> FacilityGroupRole
> FacilityGroupRollup
> FacilityGroupType
> FacilityLocation
> FacilityLocationGeoPoint
> FacilityParty
> FacilityType
> FacilityTypeAttr
> ProdCatalogInvFacility
> OldFacilityRole
> ProductFacility
> ProductFacilityLocation
> ProductStoreFacility
>
>
> View Entity depenndency
> ---------------------------
>
> ProductStoreFacilityByOrder(Use In ShipmentForms.xml)
> MemberEntity
> ------------
> OrderHeader
> ProductStoreFacility
> ProductStore
> Facility
>
> FacilityAndContactMech(Use in OrderView.groovy)
> MemberEntity
> ------------
> Facility
> FacilityContactMech
> ContactMech
>
> FacilityLocationAndGeoPoint(Use in FacilityLocationGeoLocation.groovy and
> EditFacilityLocation.ftl)
> MemberEntity
> ------------
> FacilityLocation
> FacilityLocationGeoPoint
> GeoPoint
> ProductFacilityAndPostalAddress(Not in Use)
> MemberEntity
> ------------
> ProductFacility
> FacilityContactMech
> ContactMech
> PostalAddress
>
> Thanks & Regards
> Jayachandra
>
>