# No mapping found for field 'customerAddress' trotz ForeignKey-Reparatur

**URL:** https://forum.shopware.com/t/no-mapping-found-for-field-customeraddress-trotz-foreignkey-reparatur/39489
**Category:** Administration
**Created:** [1. September 2016 um 11:29 UTC](https://forum.shopware.com/t/no-mapping-found-for-field-customeraddress-trotz-foreignkey-reparatur/39489 "2016-09-01T11:29:07Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![sigmastern](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@sigmastern](https://forum.shopware.com/u/sigmastern)
#### Post date: [21. September 2016 um 09:48 UTC](https://forum.shopware.com/t/no-mapping-found-for-field-customeraddress-trotz-foreignkey-reparatur/39489/4 "2016-09-21T09:48:09Z")

</div>

und Teil 2:

&nbsp;

– Constraints der Tabelle `s_order_attributes`  
ALTER TABLE `s_order_attributes`  
&nbsp; ADD CONSTRAINT `s_order_attributes_ibfk_1` FOREIGN KEY (`orderID`) REFERENCES `s_order` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_order_basket_attributes`  
ALTER TABLE `s_order_basket_attributes`  
&nbsp; ADD CONSTRAINT `s_order_basket_attributes_ibfk_2` FOREIGN KEY (`basketID`) REFERENCES `s_order_basket` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_order_billingaddress_attributes`  
ALTER TABLE `s_order_billingaddress_attributes`  
&nbsp; ADD CONSTRAINT `s_order_billingaddress_attributes_ibfk_2` FOREIGN KEY (`billingID`) REFERENCES `s_order_billingaddress` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_order_details_attributes`  
ALTER TABLE `s_order_details_attributes`  
&nbsp; ADD CONSTRAINT `s_order_details_attributes_ibfk_1` FOREIGN KEY (`detailID`) REFERENCES `s_order_details` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_order_documents_attributes`  
ALTER TABLE `s_order_documents_attributes`  
&nbsp; ADD CONSTRAINT `s_order_documents_attributes_ibfk_1` FOREIGN KEY (`documentID`) REFERENCES `s_order_documents` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_order_shippingaddress_attributes`  
ALTER TABLE `s_order_shippingaddress_attributes`  
&nbsp; ADD CONSTRAINT `s_order_shippingaddress_attributes_ibfk_1` FOREIGN KEY (`shippingID`) REFERENCES `s_order_shippingaddress` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_premium_dispatch_attributes`  
ALTER TABLE `s_premium_dispatch_attributes`  
&nbsp; ADD CONSTRAINT `s_premium_dispatch_attributes_ibfk_1` FOREIGN KEY (`dispatchID`) REFERENCES `s_premium_dispatch` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_product_streams_articles`  
ALTER TABLE `s_product_streams_articles`  
&nbsp; ADD CONSTRAINT `s_product_streams_articles_fk_article_id` FOREIGN KEY (`article_id`) REFERENCES `s_articles` (`id`) ON DELETE CASCADE,  
&nbsp; ADD CONSTRAINT `s_product_streams_articles_fk_stream_id` FOREIGN KEY (`stream_id`) REFERENCES `s_product_streams` (`id`) ON DELETE CASCADE;

– Constraints der Tabelle `s_product_streams_attributes`  
ALTER TABLE `s_product_streams_attributes`  
&nbsp; ADD CONSTRAINT `s_product_streams_attributes_ibfk_1` FOREIGN KEY (`streamID`) REFERENCES `s_product_streams` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_product_streams_selection`  
ALTER TABLE `s_product_streams_selection`  
&nbsp; ADD CONSTRAINT `s_product_streams_selection_fk_article_id` FOREIGN KEY (`article_id`) REFERENCES `s_articles` (`id`) ON DELETE CASCADE,  
&nbsp; ADD CONSTRAINT `s_product_streams_selection_fk_stream_id` FOREIGN KEY (`stream_id`) REFERENCES `s_product_streams` (`id`) ON DELETE CASCADE;

– Constraints der Tabelle `s_user_addresses`  
ALTER TABLE `s_user_addresses`  
&nbsp; ADD CONSTRAINT `s_user_addresses_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `s_core_countries` (`id`) ON UPDATE CASCADE,  
&nbsp; ADD CONSTRAINT `s_user_addresses_ibfk_2` FOREIGN KEY (`state_id`) REFERENCES `s_core_countries_states` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,  
&nbsp; ADD CONSTRAINT `s_user_addresses_ibfk_3` FOREIGN KEY (`user_id`) REFERENCES `s_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

– Constraints der Tabelle `s_user_addresses_attributes`  
ALTER TABLE `s_user_addresses_attributes`  
&nbsp; ADD CONSTRAINT `s_user_addresses_attributes_ibfk_1` FOREIGN KEY (`address_id`) REFERENCES `s_user_addresses` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_user_attributes`  
ALTER TABLE `s_user_attributes`  
&nbsp; ADD CONSTRAINT `s_user_attributes_ibfk_1` FOREIGN KEY (`userID`) REFERENCES `s_user` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_user_billingaddress_attributes`  
ALTER TABLE `s_user_billingaddress_attributes`  
&nbsp; ADD CONSTRAINT `s_user_billingaddress_attributes_ibfk_1` FOREIGN KEY (`billingID`) REFERENCES `s_user_billingaddress` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

– Constraints der Tabelle `s_user_shippingaddress_attributes`  
ALTER TABLE `s_user_shippingaddress_attributes`  
&nbsp; ADD CONSTRAINT `s_user_shippingaddress_attributes_ibfk_1` FOREIGN KEY (`shippingID`) REFERENCES `s_user_shippingaddress` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;  
&nbsp;

---

_[View the full topic](https://forum.shopware.com/t/no-mapping-found-for-field-customeraddress-trotz-foreignkey-reparatur/39489)._