How to design tables correctly?

Question

Database design

Good evening!

Can you tell me how to design the base?

there is a table of users users - id, first_name, lsat_name
there is a table of shops shops - id, name, logo, slug

a store can have several employees - store admin, manager, kontenschik
and each store employee has their own roles for managing the store - admin, manager, content_manager
and each role has its own privileges

Answer 1

users
shops
roles
perms
user_shops (user_id shop_id) - manyToMany
user_roles (user_id role_id) - manyToMany
role_perms (role_id perm_id) - manyToMany