There is one row in the SYSGROUP system view for each member of each group. This view describes the many-to-many relationship between groups and members. A group may have many members, and a user may be a member of many groups. The underlying system table for this view is ISYSGROUP.
|Column name||Column type||Column constraint|
|group_id||UNSIGNED INT||NOT NULL|
|group_member||UNSIGNED INT||NOT NULL|
group_id The user number of the group.
group_member The user number of a member.
PRIMARY KEY (group_id, group_member)
FOREIGN KEY (group_id) references SYS.ISYSUSER (user_id)
FOREIGN KEY (group_member) references SYS.ISYSUSER (user_id)