Ratnesh/Chandan, I would suggest to consider "one-nofk" relationship in such cases, because in this way we could maintain the relationship and also use the existing model as is. This is only suggestion, as I'm not very sure and it is applicable case to case. Others from community may help on this point.
In either case to maintain the relationship my preference would be adding OrderEntry website record. +1 for adding website entity record. Rishi Solanki Sr Manager, Enterprise Software Development HotWax Systems Pvt. Ltd. Direct: +91-9893287847 http://www.hotwaxsystems.com www.hotwax.co On Sat, Aug 26, 2017 at 6:27 PM, Chandan Khandelwal < chandan.khandel...@hotwaxsystems.com> wrote: > Hi Ratnesh, > > I have found missing FK constraint in multiple entity definitions > (e.g. shoppingListId in OrderItem etc). So I think we need to verify and > improve this throughout the application. > > -- > Thanks & Regards, > Chandan Khandelwal > HotWax Systems > Direct: +91-9893481076 > http://www.hotwaxsystems.com/ > > On Sat, Aug 26, 2017 at 1:08 PM, Ratnesh Upadhyay < > upadhyay.ratn...@gmail.com> wrote: > > > Thanks everyone for your inputs. > > Here is the jira ticket : https://issues.apache.org/ > jira/browse/OFBIZ-9647 > > > > Regards, > > Ratnesh Upadhyay > > HotWax System | www.hotwaxsystems.com > > > > On Sat, Aug 26, 2017 at 11:54 AM, Arun Patidar < > > arun.pati...@hotwaxsystems.com> wrote: > > > > > Nice catch Ratnesh, we can take this as an improvement. > > > > > > > > > > > > -- > > > Thanks & Regards > > > --- > > > Arun Patidar > > > Manager, Enterprise Software Development > > > > > > > > > HotWax Systems Pvt Ltd.www.hotwaxsystems.com > > > > > > > > > On Thu, Aug 24, 2017 at 7:50 PM, Ratnesh Upadhyay < > > > upadhyay.ratn...@gmail.com> wrote: > > > > > > > Hello Devs, > > > > > > > > I just walked though from OrderHeader entity and noticed that we have > > > > webSiteId field there but we don't have any FK constraint for it from > > > > OrderHeader.webSiteId to WebSite.webSiteId. I was expecting that it > > must > > > be > > > > there. > > > > > > > > So just curious to know why it was not there, was it intentional? > > Please > > > > let me know if anyone have any information on it else I would > provide a > > > > patch to get it fixed. > > > > > > > > Thanks!! > > > > > > > > Regards, > > > > Ratnesh Upadhyay > > > > HotWax Systems | www.hotwaxsystems.com > > > > > > > > > >
