Universal User Rights system design (Database design)

Do more than the MIS system, a long time ago this idea, want to put the MIS system user rights

Management and approval flow management stand-alone, separate components

Today, for the time being, look at the database table design of the Authority management system.

subsystem table, because I design here in order to be able to integrate all the internal system of the company, so built a subsystem this table, if a single project, this table can be removed.

Module table, each module in the system.

module function table, each function in the module (can have two functions, one is the access of the page, one is the button event on the page)

User table

Role table

User Group table

User Department Table

User Permissions table (you can also give permissions directly to users)

Role Permissions table (assigning permissions to roles)

User and group relationship tables (one user can belong to multiple groupings)

User and role Relationships table (one user can have multiple roles)

User grouping and role relationship tables (a group can have several roles)

Universal User Rights system design (Database design)