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

Asked by Fırat Kaya
(41 rep)
Nov 28, 2020, 10:14 AM
Last activity: Aug 3, 2025, 11:00 AM
Last activity: Aug 3, 2025, 11:00 AM