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, jayachandr...@gmail.com < jayachandr...@gmail.com> wrote: > > > 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 > > >