The `group_member` table
This table holds info about group members.
Structure
| Field | Type | Attributes | Key | Null | Default | Extra | Comment |
|---|---|---|---|---|---|---|---|
| guid | INT | UNSIGNED | NO | ||||
| memberGuid | INT | UNSIGNED | PRI | NO | Unique | ||
| memberFlags | TINYINT | UNSIGNED | NO | 0 | |||
| [subgroup4 | TINYINT | UNSIGNED | NO | 0 | |||
| roles | TINYINT | UNSIGNED | NO | 0 |
Description of the fields
GUID of the group. See groups.guid.
GUID of the character member of the group. See characters.guid.
| Name | Value | Unique |
|---|---|---|
| MEMBER_FLAG_ASSISTANT | 0x01 | |
| MEMBER_FLAG_MAINTANK | 0x02 | (U) |
| MEMBER_FLAG_MAINASSIST | 0x04 | (U) |
(U) = Unique per group.
Ranging 0-7 (1-8 in client), representing the subgroups of a raid group. There can only be 5 membes in one subgroup per raid group.
| Value | Name | Comments |
|---|---|---|
| 0 | ROLE_NONE | |
| 1 | ROLE_LEADER | The character has signed to Random Dungeon Finder as experienced |
| 2 | ROLE_TANK | The character has signed to Random Dungeon Finder as tank |
| 4 | ROLE_HEALER | The character has signed to Random Dungeon Finder as healer |
| 8 | ROLE_DAMAGE | The character has signed to Random Dungeon Finder as dps |