On 2018/03/20 02:43:26, Paul Foxworthy <p...@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 <mallah.raj...@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, jayachandr...@gmail.com < > > jayachandr...@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: i...@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
