Group member tc2

Back to characters database list of tables.

The `group_member` table

This table holds info about group members.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned		NO
memberGuid	int(10)	unsigned	PRI	NO		Unique
memberFlags	tinyint(3)	unsigned		NO	0
subgroup	tinyint(3)	unsigned		NO	0
roles	tinyint(3)	unsigned		NO	0

Description of the fields

guid

GUID of the group. See groups.guid.

memberGuid

GUID of the character member of the group. See characters.guid.

memberFlags

   MEMBER_FLAG_ASSISTANT   = 0x01,
   MEMBER_FLAG_MAINTANK    = 0x02, (U)
   MEMBER_FLAG_MAINASSIST  = 0x04, (U)

(U) = Unique per group.

subgroup

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.

roles

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