Database modeling users, roles and user_roles table

Hi, i have created three tables called users, roles and user_roles in my sqllite database with nodjes project. then i have added the reference in user_roles table selecting user_id and choosing type as reference then selected users table as from, same way i did for the role_id.

After all i saw below screenshot is that correct? that users table having many relation as show in screenshot. and my user_roles table disappeared. instead roles filed added in users table.

Community Page
Last updated: