groups Table¶

Party and raid group headers (leader, loot rules, difficulty).

Schema Summary¶

Field	Type	Key	Null
`group_id`	int(11) unsigned	PRI	NO
`leader_guid`	int(11) unsigned	UNI	NO
`main_tank_guid`	int(11) unsigned		NO
`main_assistant_guid`	int(11) unsigned		NO
`loot_method`	tinyint(4) unsigned		NO
`loot_threshold`	tinyint(4) unsigned		NO
`looter_guid`	int(11) unsigned		NO
`icon1`	int(11) unsigned		NO
`icon2`	int(11) unsigned		NO
`icon3`	int(11) unsigned		NO
`icon4`	int(11) unsigned		NO
`icon5`	int(11) unsigned		NO
`icon6`	int(11) unsigned		NO
`icon7`	int(11) unsigned		NO
`icon8`	int(11) unsigned		NO
`is_raid`	tinyint(1) unsigned		NO

group_id - Primary Key. Group identifier (also referenced by group_member/group_instance).
leader_guid - Unique. Current leader.
main_tank_guid - Raid-assigned roles.
main_assistant_guid - Raid-assigned roles.
loot_method - 0 Free-for-all, 1 Round-robin, 2 Master loot, 3 Group loot, 4 Need-before-greed.
loot_threshold - Quality threshold for group loot rules (0 white … 4 epic).
looter_guid - Master looter character when applicable.
icon1 - Target icon assignments (skull/cross… → member guid).
icon2 - Target icon assignments (skull/cross… → member guid).
icon3 - Target icon assignments (skull/cross… → member guid).
icon4 - Target icon assignments (skull/cross… → member guid).
icon5 - Target icon assignments (skull/cross… → member guid).
icon6 - Target icon assignments (skull/cross… → member guid).
icon7 - Target icon assignments (skull/cross… → member guid).
icon8 - Target icon assignments (skull/cross… → member guid).
is_raid - 1 once converted to raid.