No foreign keys pointing to standard tables?

Developing for Dolibarr
1

From the documentation (Language and development rules - Dolibarr ERP CRM Wiki): “Note: If you develop your own external module, it must have no foreign keys that point to Dolibarr standard tables. This will break standard dolibarr upgrades, repair, backup and restore tools and may also break standard features.”

I’m not sure I understand this- wouldn’t the inclusion of the fk_soc key mentioned above this text as an optional column for new tables break upgrades, repair, backup etc. if this were so? Or is the third party table not “standard”?

2

You can create a table with a colum fk_soc in your external module. But you must not add a sql foreign key constraint between your table and dolibarr core table.

3

Actually, I have somehow missed that, and for a customer, I have a module with constraints/foreign keys and I’ve done a Dolibarr upgrade for them without any issue (v13 to V14 and recently v14 to v16). Could this restriction be due to some legacy code that is not present now?