PHP Background Administrator permissions related table structure

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