Table structure related to php background administrator permissions and php background administrator permissions

Table structure related to php background administrator permissions and php background administrator permissions

Admin administrator table

Id int (11) User id

Username varchar (128) User Name

Password varchar (128) Administrator password

Name varchar (50) Real Administrator name

Email varchar (128) Administrator email

Login_time int (11) Logon Time

Login_ip varchar (20) logon ip

Create_time int (11) Creation Time

Salt varchar (10) random encrypted string

Role_id int (11) role id

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

Update_time int (11) Update Time

Ip_access tinyint (4) allow Internet access (1. Not allowed 2. Allowed)

 

Role table

Id int (11) primary key id

Name varchar (50) role name

Sort int (11) sorting

Status tinyint (4) status (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) status (0: unauthorized 1: authorized)

 

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 (20) controller name

Action varchar (20) action name

Status tinyint (1) no show 0 not show 1 show default 1

Sort int (11) sorting field (99 by default)

 

Module background module grouping table

Id int (11) primary key id

Name varchar (50) Module name

Status tinyint (1) Whether to display (0 is not displayed, 1 is displayed, default is 1)

Sort int (11) sorting field (99 by default)

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.