Re: Question about data model

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,

Re: Question about data model

Ahh you're right I did not pay attention to one-nofk setup. I just looked at the relationship. Thanks Scott and sorry Pedro, but now you got the answer. Taher Alkhateeb On Wednesday, 30 December 2015, Scott Gray wrote: > That's incorrect, there is no foreign-key

Question about data model

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

Re: Question about data model

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

Re: Question about data model

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 wrote: > Hi

Re: Question about data model

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 wrote: > Hello all, >