WPF Open Source Rights Management framework "Zhframework" Database structure design (1)

Objective

As a result of technology transformation, most of the work is mainly WPF, but it is difficult to find a satisfactory WPF Rights Management Framework on the web now, because WinForm was a set of rewritten permission frames.

so the database design this piece has a mature design, as for the WPF client this piece, technology selection is also basically determined: MVVM mode, Prism module, using the entity, the UI of the interface layer uses open source materialdesign components.

DB Design

According to the current design, the overall framework is: template Management, menu management, user Management, permissions classification, group and group users, group permissions, system logs, data dictionary. The following is the design structure of the entire powerdesign:

Note: Some of the encodings and attachments added below are the structures used for the extension. The core is made up of several modules described above

Permissions module

The menu function is subdivided into the permissions control of each function button, and all functions are defined in the Permission classification table. Finally, the user's permission is configured by the group method.

Log level

The Log field table defines the table that needs to be logged, broken down to the field-level log management, based on the log field configured by the database.

Dictionary Management

A dictionary table that controls all of the dictionary type data for easy centralized management

Encoding Rules

Generates a coded serial number for a specified rule for a different business.

WPF Open Source Rights Management framework "Zhframework" Database structure design (1)