Answer the question
In order to leave comments, you need to log in
How to organize a database with three tables and many-to-many relationships?
Base for discord bot. Discord has servers (table guild), users (user), user roles on the server (role).
A server can have many users and roles. A user can be a member of many servers and have many roles. I can't think of a base plan. So far I've settled on two options.
The first one seems simpler:
The second one seems more logical:
What would be more correct?
Answer the question
In order to leave comments, you need to log in
Сервер: код, название, настройки
Роль: код, название
Настройки роли: код, код названия, код сервера, настройки
Пользователь: код, имя
Настройки пользователя: код пользователя, код настройки роли
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question