Description of the Process of permissions and roles of an organizational unit

Table Name	Description	Remarks
Com_org	Organization group, each new branch will insert a corresponding data to this table
Com_group	Organization group. A corresponding data entry is inserted into the table for each department or position created. The ID starting with G is a group, P is a position, and O is a department.
Com_group_user	This table stores the group to which the personnel belongs.	The ID corresponding to com_org and com_group is saved.
Sys_workflow	Name of the process for saving the table
Sys_wf_template	This table stores templates for the corresponding process.	The ID of sys_workflow is saved.
Sys_wft_node	Procedure Name and description	The ID of sys_wf_template is saved.
Sys_wf_instance	Process Operation Details column current_node_no identifies the process in the step	The ID of sys_wf_template is saved.
Com_role	Role table
Com_role_group	This table is saved when you configure a department or group to a role.	Save the corresponding ID and group ID of the com_role role table.
Com_role_user	This table is saved when someone is configured to a role.	Save the corresponding ID and personnel ID of the com_role role table.
Com_action	Permission operation table
Com_module	Module table
Com_cfg	Record that a role has certain operation Permissions	The corresponding ID of the com_role role table and the corresponding ID of com_action are saved.

Com_org: Organization table. You can use this table to query the branches of a department or group.

Com_role: Role table (which is used by the categort field to generate applications for five types of role process calls)

Com_role_user: Role personnel table

Com_role_group: Role group table

Com_dept: Department (organization) Table

Com_pos: Position table

Com_group: group table (groups, positions, and departments all have records in this table and the ID is g, P, or O headers)

Com_group_user: group user table (group ID, user ID) Contact Group and user table

Sys_work_flow: Process Table

Sys_wf_template: Process Template table

Sys_wf _ instance: Process instance table (Role of the read_user and write_user fields)

Sys_wft_node: Control List data table

Com_action: Permission table

Com_module: module table

Com_cfg: associated operation, role, document data flag, and flag1

Organizational Structure:Com_dept,Com_pos,Com_groupOrg_id correspondsCom_orgThe org_id of a group, department, and position.Com_group_userThe group_id and user_id correspondCom_groupGroup_id andCom_userUser_id in. The corresponding relationship can be used to determine the branch, group, department, and position of a person.

Process:Sys_wf_templateW_id In the tableSys_workflowW_id;Sys_wft_nodeT_id In the tableSys_wf_templateT_id,Sys_wf_instanceT_id In the tableSys_wf_templateT_id. The corresponding relationship can be used to determine the steps of a template in a process and the steps of the template (determined by the current_node_no field ).

Role:Com_role_groupThe role_id and group_id correspondCom_roleRole_id andCom_groupGroup_id in to obtain the groups, departments, and positions of a role;Com_role_userThe role_id and user_id correspondCom_roleRole_id andCom_userUser_id in, you can get a specific person under a role;Com_cfgThe role_id and action_id In the table correspondCom_roleRole_id andCom_actionThe action_id in to obtain the actions under which roles, and then obtain the specific operation permissions of specific personnel.