Hi,

For my first attempt I just want to check if I have everything correct here.

A customer can have multiple addresses & contacts, & a contact can have multiple customers (not always though).

Is there is anything I have missed?

Thanks

All seems OK as far as I can tell (I presume the white half of the diamonds means "one" and the black half means "many"?)

I would question your table names though: I think customer_addresses should be just addresses, customer_has_customer_addresses should be customer_addresses (or perhaps customer_address_usages) and so on.

Thank you Tony,

Yes, white is one and black is many

I also need a set of tables for suppliers, thats why these are prefixed with customer. I get your point though and I will think throught my table naming "convention" to simplify it.


Ray...