mysql - In Thinkphp's RBAC authentication, why does the 'user-role' table need an independent table? ?-PHP Tutorial-php.cn

Home

Backend Development

PHP Tutorial

mysql - In Thinkphp's RBAC authentication, why does the 'user-role' table need an independent table? ?

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Aug 18, 2016 am 09:15 AM

mysqlphpthinkphpPermissionsPermission control

You can refer to the five tables here: http://www.lyblog.net/detail/...

Actually there is a table:
mysql - In Thinkphp's RBAC authentication, why does the 'user-role' table need an independent table? ?

There is a one-to-one correspondence between users and roles. Why not just add a role field to the user table instead of creating another table?
What are the benefits of doing this?

Supplement:
Some people say that users and roles have a one-to-many relationship. I want to know why it is necessary to set it to one-to-many?
Isn’t it easier to handle a one-to-one relationship?

Reply content:

You can refer to the five tables here: http://www.lyblog.net/detail/...

Actually there is a table:
mysql - In Thinkphp's RBAC authentication, why does the 'user-role' table need an independent table? ?

There is a one-to-one correspondence between users and roles. Why not just add a role field to the user table instead of creating another table?
What are the benefits of doing this?

Supplement:
Some people say that users and roles have a one-to-many relationship. I want to know why it is necessary to set it to one-to-many?
Isn’t it easier to handle a one-to-one relationship?

My understanding is that a user can have multiple roles

It’s like this:

A person can have multiple roles
A role can also be used by multiple people
Many-to-many relationships generally require an intermediate table to be mapped.

Unless you are using a non-relational database like redis

Not one-to-many, but many-to-many.

Maybe your project doesn’t need it, but as a framework, you need to consider broader needs. From this perspective, a many-to-many table can be used as a one-to-one table, because many-to-many includes one-to-one, but one-to-one A one-to-one design will inevitably fail to meet the many-to-many needs. So there's going to be a separate relationship table here, got it?

A user has multiple roles.

In fact, it is possible not to create a separate table.

Decoupling, single responsibility model

The relationship of ManytoMany requires an intermediate table!

In order to meet the many-to-many needs
My understanding may not be accurate: For example, there are several roles a, b, and c. According to your understanding, users 1, 2, and 3 can correspond to a, b, and c respectively. The character is okay. If another user 4 comes, the role he needs happens to have the permissions of roles a and b, so user 4 directly belongs to roles a and b. There is no need to create a new role d to meet the needs of user 4

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

PHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

How to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles