That's incorrect, there is no foreign-key dependency between SecurityGroupPermission and SecurityPermission and this is done on purpose.
Here's an old discussion on the topic: http://ofbiz.135035.n4.nabble.com/security-permission-td154203.html#a154208 Regards Scott On 29 December 2015 at 05:06, Taher Alkhateeb <slidingfilame...@gmail.com> wrote: > Hi Pedro, > > I would assume the problem is in your migration process. Do you face the > same thing on a fresh new database? If no, then you need to check what went > wrong with your migration. > > Taher Alkhateeb > > On Mon, Dec 28, 2015 at 6:59 PM, Pedro Lopes <ge...@pedropalacios.net> > wrote: > > > Hello all, > > > > Taher, thank you very much for your reply. > > > > OK, is that relationship supposed to be on the database also? I migrated > to > > mysql and did not find it there. > > > > Thank you for your attention, > > > > Pedro > > > > On Mon, Dec 28, 2015 at 1:24 PM, Taher Alkhateeb < > > slidingfilame...@gmail.com > > > wrote: > > > > > Hi Pedro, > > > > > > The SecurityGroupPermission entity has a foreign key to both > > > SecurityPermission and SecurityGroup. You can check the entity > definition > > > in framework/security/entitydef/entitymodel.xml. This is because the > > > SecurityGroupPermissions is a relationship entity (many to many) > > > > > > Taher Alkhateeb > > > > > > On Mon, Dec 28, 2015 at 3:15 PM, Pedro Lopes <ge...@pedropalacios.net> > > > wrote: > > > > > > > Hello all, > > > > > > > > Data model question: There isn't a foreign key between the tables > > > > SECURITY_PERMISSION and SECURITY_GROUP_PERMISSION, is this table not > to > > > > relate the table SECURITY_PERMISSION with SECURITY_GROUP? > > > > > > > > Thank you all very much, > > > > > > > > Pedro > > > > > > > > > >