Naming convention for sql join table to keep the name short

Question

I have two tables:

provider_contact
provider_contact_role

Now i need a join table for those and what's coming to my mind first is:

Option 1: provider_contact_provider_contact_role but this is too long.

Option 2: provider_contact_role which ideally describes the purpose of the table, but that is exactly the same as second table's name :)

What is your suggestion ?

As I mentioned option 2 is the exact same name as the 2nd table :) So I can't use that name — Suren Aznauryan, Jun 13 '18 at 13:24
@SurenAznauryan Do you have only "provider_contact_role" table for roles or there are another Role tables? if it is the only one then I would recommend to rename it to "role" and then join name for two tables is clear. — Mara, Jun 15 '18 at 11:26

score 0 · Answer 1 · edited Jun 20 '20 at 09:12

0

You can always introduce an X to show that it's a JOIN table?

provider_contact_X_role

providercontactXrole

contactXrole

provider_X_role

edited Jun 20 '20 at 09:12

Community

answered Jun 13 '18 at 14:07

Nick B

1 Answers1