On 2018/03/19 15:23:07, 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 > > > > > 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