Sample Header Ad - 728x90

How can I design address table?

0 votes
2 answers
4056 views
Hello I need designing addresses table. I designed it but I didn't like it very much. My needs: - I have customers and users (admins). I have addresses for customers and users. We need design in different tables like CustomerAddresses and UserAddresses. But we must be have Addresses table and connect with CustomerAddreses and UserAddresses. - I have different address types like individual, corporate address. This types just using in customer's addresses. - A customer can have more than one address. - A user can have more than one address. - Customers are not individual or corporate. Customer addresses are individual or corporate. My design: (but I think this design not good. I think this design breaking normalization rules.) CustomerAddresses is junction table in this design. And belongs to CustomerAddressTypes. We can create a new design or update my design. https://dbdiagram.io/d/5fc2218b3a78976d7b7dbaf6 enter image description here
Asked by Fırat Kaya (41 rep)
Nov 28, 2020, 10:14 AM
Last activity: Aug 3, 2025, 11:00 AM