Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    18

    customers, contacts & locations

    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
    Attached Thumbnails Attached Thumbnails customers.png  

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    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.

  3. #3
    Join Date
    Feb 2004
    Posts
    18
    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...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •