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 | Data type | Description |
|---|---|---|
| group_id | UNSIGNED INT | The user number of the group. |
| group_member | UNSIGNED INT | The user number of a member. |
PRIMARY KEY (group_id, group_member)
FOREIGN KEY group_id (group_id) references SYS.ISYSUSER (user_id)
FOREIGN KEY group_member (group_member) references SYS.ISYSUSER (user_id)