After logging on to a user with different permissions, you can see the database table list of different menu designs.

After logon, users with different permissions can see different menus (two levels of menus ).

 

I. menu table

ID (Primary Key ),
Menu_name (menu name ),
Parent_menu_id (parent menu ID ),
Level (menu level: 0, level 1 menu, 1, level 2 menu ...... Can be infinitely)
Ii. Role role table
ID (Primary Key ),
Role_name (role name)
Iii. role_menu role Association menu table
ID (Primary Key ),
Role_id (role ID ),
Menu_id (menu ID)
Iv. User table
ID,
User_name
V. user_role User Role table
ID,
User_id (User ID ),
Role_id (role ID)