# groups [<-Back-to:Characters](database-characters.md) **The \`groups\` table** This table holds basic info about groups. **Structure**

Field	Type	Attributes	Key	Null	Default	Extra	Comment
guid	int(10)	unsigned	PRI	NO
leaderGuid	int(10)	unsigned		NO
lootMethod	tinyint(3)	unsigned		NO
looterGuid	int(10)	unsigned		NO
lootThreshold	tinyint(3)	unsigned		NO
icon1	int(10)	unsigned		NO
icon2	int(10)	unsigned		NO
icon3	int(10)	unsigned		NO
icon4	int(10)	unsigned		NO
icon5	int(10)	unsigned		NO
icon6	int(10)	unsigned		NO
icon7	int(10)	unsigned		NO
icon8	int(10)	unsigned		NO
groupType	tinyint(3)	unsigned		NO
difficulty	tinyint(3)	unsigned		NO	0
raiddifficulty	tinyint(3)	unsigned		NO	0

**Description of the fields** ### guid The ID of the group. This number is unique to each group and is the main method to identify a group. ### leaderGuid The GUID of the character. See characters.guid ### lootMethod

Value	Name	Comments
0	FREE_FOR_ALL
1	ROUND_ROBIN
2	MASTER_LOOT
3	GROUP_LOOT
4	NEED_BEFORE_GREED

### looterGuid Master looter's guid. See characters.guid If [lootMethod](#groups-lootMethod) is not 2, then it's group leader's guid. ### lootThreshold `field-no-description|5` ### icon1-8 `field-no-description|6` ### groupType

Value	Name	Comments
0	GROUPTYPE_NORMAL
1	GROUPTYPE_BG
2	GROUPTYPE_RAID
3	GROUPTYPE_BGRAID	GROUPTYPE_BG + GROUPTYPE_RAID, // mask
4	GROUPTYPE_UNK1
8	GROUPTYPE_LFG

### difficulty `field-no-description|8` ### raiddifficulty `field-no-description|9`