Design and implementation of multi-user rights control for Web application system-Database Design "2"

To build a Web rights configuration system, you need the following five data tables: People table, grouping table, page table, table of contents, Operation permission table. The IDs used in each data table are the identity of the self-increment 1, and each data table is defined as follows:

1.1 Personnel table (Operatorinfo)

1.2 Grouping table (Operatorgroup)

1.3 Page Table (PageInfo)

1.4 Table of Contents (catalog)

1.5 Permissions table (rightlist)

1.6 Mapping relationships

User tables can be mapped to grouped tables by grouping numbers;

The page table can be mapped to the table of contents by catalog number;

The group number, the catalog number, and the page number map to the permission table to determine which pages a user can access. Where a user can belong to more than one grouping and has all the permissions that belong to the group.

Summary: This chapter mainly introduces the design of the data table, the next chapter mainly introduces the construction of the project and the basic operation of the package description of the class.

Design and implementation of multi-user rights control for Web application system-Database Design "2"