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 > > > > > >