Proper Table naming convention for a many-to-many intersect table
I would prefer "Clients_Brokers" (pluralizing both names to indicate many-to-many).
I usually use the names of both of the joining tables.
So, in your case, ClientBroker.
I would prefer "Clients_Brokers" (pluralizing both names to indicate many-to-many).
I usually use the names of both of the joining tables.
So, in your case, ClientBroker.