database-design

What are proper table-naming conventions for many-to-many intersect tables?

I have a many to many relation for: Client and Broker tables (just an example). Obviously, each client can have multiple brokers and each broker can have multiple clients. What is considered the proper naming convention for the intersect table.... is it ClientBroker...?

Solution

  • I usually use the names of both of the joining tables.

    So, in your case, ClientBroker.