There’s something I don’t understand.
I define 2 entities in Logical design (let’s say “users” and “forums”). I use “id” as primary key name for both users and forums.
Hence, I define a many-to-many relationship between users and forums.
When I convert to physical model, I obtain a join table “users_forums”.
The questions are:
How can I obtain “forums_users” instead? I’m using the resulting database with a framework who smartly use the convention “in join tables the two table names are sorted”
I obtain a table with 2 attributes called id, which will obviously break sql rules. Instead, I’d like to have a join tables with, let’s say, “id_user” and “id_forum” or “forum” and “user” or “forum_id” and “user_id” or whatever.
How can I?