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