First, background permission design RBAC
RBAC: Role Base Access Control Role-based user access control, that is, permissions are assigned to roles and roles are assigned to users.
1.1 Design of role and Permission Table
If multiple roles are involved for one user, the following design is recommended.
In general, we use the following design for one user for one role:
1, create the role table
php artisan make:model Models/Role -m
2. Create a permission table
php artisan make:model Models/Node -m
Create an intermediate table for roles and permissions (without creating a model)
php artisan make:migration role_Node
There are three migration files and two models created.
4. Create another base model
php artisan make:model Models/Base
5. Modify the inheritance of node (permission) model and role model
Add user table fields
7. Role table fields
8, permission (node) table field
9. Middle table of roles and permissions (nodes)
10. Migrate files
php artisan migrate:refresh --seed
On the way to learning PHP, if you find this article helpful to you, then please pay attention to like comment 3 times, thank you, your must be another support of my blog.