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, [email protected] < [email protected]> 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 > >
