PHP Background Administrator permissions related table structure

Source: Internet
Author: User
Tags administrator password

Admin Administrator Table

ID Int (11) User ID

Username varchar (128) User name

Password varchar (128) Administrator password

Name varchar (50) Administrator real name

Email varchar (128) Admin mailbox

login_time Int (11) Login Time

LOGIN_IP varchar (20) Login IP

Create_time Int (11) Creation time

Salt varchar (10) randomly encrypted string

role_id Int (11) Role ID

Status tinyint (4) state (0, delete 1, disable 2, normal)

Update_time Int (11) Update time

Ip_access tinyint (4) Consent to extranet access (1, disagree 2, consent)

role Role Table

ID Int (11) primary key ID

Name varchar (50) Role names

sort int (11) Sorting

Status tinyint (4) state (0, delete 1, disable 2, normal )

Role_privilege Role Permissions

ID Int (11) primary key ID

role_id Int (11) Role ID

menu_id Int (11) menu ID

Status tinyint (1) state (0: unauthorized 1: Authorized)

Menu Menu Table

ID Int (11) Menu primary Key

Name varchar (50) Menu name

module_id Int (11) module ID

Modules varchar (20) module name (code-related)

Controller Archar () controller name

Action varchar Action name

Status tinyint (1) No show 0 not show 1 Show default 1

sort int (11) sorted field (default )

Module Background Module Grouping table

ID Int (11) primary key ID

Name varchar (50) module names

Status tinyint (1) is displayed ( 0 does not show 1 display default 1)

sort int (11) sorted field (default )


PHP Background Administrator permissions related table structure

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.