Hello I need designing addresses table. I designed it but I didn't like it very much.
- 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.