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.

When adding multi reference table like user_roles, called just roles when you are adding it under the user, all keys are created by Wappler when you just appoint the linking table in the multi reference table properties. So no need to create any id or extra keys

1 Like

Lovely… so this is corrected by wappler automaticaly then?

Well because you added them manually they are added as extra now. So you might want to undo this change and create the rules multi reference again but then without the extra references.

1 Like

tutorial or docs exist for how to create multi reference?

2 Likes

Thanks brad :slight_smile:

1 Like