Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email

Magento Forum

Entity tables and foreign key constraints
Jr. Member
Total Posts:  19
Joined:  2008-06-24


What would the possible ramifications be of dropping the foreign key constraints FK_CUSTOMER_ADDRESS_CUSTOMER_ID and FK_CUSTOMER_{standard types}_ENTITY so that another table can be used as the entity table for customers? I’m working on a joomla integration, and I’ve got magento authenticating against the joomla users table (following the basic outline given in Guide to Programming with Magento) along with saving the basic magento customer information (firstname/lastname, shipping and billing address). However, I had to drop the foreign key constraints given above to achieve this, particularly FK_CUSTOMER_ADDRESS_CUSTOMER_ID.

I’m really just starting to learn about magento, and I’m curious if this is a recommended path for integration with other systems? It would be nice to not have to import user credentials into magento and creat accounts which had to be kept in sync, etc. And it seems that the EAV database model allows for that possibility. However, I don’t know if it’s wise.


Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top