Achievement

Column

Field

Type

Notes

1

ID

Integer

Achievement ID

2

Faction

Integer

-1: both, 0: Horde or 1: Alliance

3 

Map

Integer

Only set if achievement is related to a zone, otherwise set to -1

4

Previous

Integer

If the Achievement belongs to a series, this is the ID of the previous one. 0 otherwise.

5-20

Name

String + Loc

21

?

Seems to be always 0xFF01FE

22-37

Description

String + Loc

If Description is empty, it's not an Achievement but part of the statistics tab

38

?

Seems to be always 16712190, in rare cases 16712188 (instances ?)

39

Category

Integer

Category ID

40

Points

Integer

0,5,10,15,20,25,30,50

41

OrderInGroup

Integer

Min. value: 1

42

Flags

Integer

0-768, if it's 256 only one person per Realm can reach that achievement and if it's 768 it's only reachable for one raid per realm. Perhaps a second category?

43

SpellIcon

Integer

An icon to display.

44-59

Reward

String+ Loc

47

Bonus

Additional reward text

60

?

Float number ?

61

Demands

Integer

Number of things you have to get/fulfill to get this Achievement. For example if you have to get 25 tabards, there is a 25. TrinityCore: "need this count of completed criterias (own or referenced achievement criterias)"

62

ReferencedAchievemnt

Integer

 TrinityCore: "referenced achievement (counting of all completed criterias)"

ID

Name

6

Level 10

7

Level 20

8

Level 30

9

Level 40

10

Level 50

11

Level 60

12

Level 70

13

Level 80

15

Plenty of Pets

16

Did Somebody Order a Knuckle Sandwich?

31

A Simple Re-Quest

32

2000 Quests Completed

33

Nothing Boring About Borean

34

I've Toured the Fjord

35

Might of Dragonblight

36

The Empire of Zul'Drak

37

Fo' Grizzle My Shizzle

38

The Summit of Storm Peaks

39

Into the Basin

40

Icecrown: The Final Goal

41

Loremaster of Northrend

42

Explore Eastern Kingdoms

43

Explore Kalimdor

44

Explore Outland

45

Explore Northrend

46

World Explorer

49

Alterac Valley victories

50

Eye of the Storm victories

51

Arathi Basin victories

52

Warsong Gulch battles

53

Alterac Valley battles

54

Eye of the Storm battles

55

Arathi Basin battles

56

Deaths in Warsong Gulch

57

Deaths in Alterac Valley

58

Deaths from Drek'Thar

59

Deaths in Arathi Basin

60

Total deaths

73

Disgracin' The Basin

94

Quests abandoned

95

Average quests completed per day

97

Daily quests completed

98

Quests completed

99

Ruins of Lordaeron matches

100

Ring of Trials victories

101

Ring of Trials matches

102

Ruins of Lordaeron victories

103

Circle of Blood matches

104

Circle of Blood victories

105

Warsong Gulch victories

107

Creatures killed

108

Critters killed

110

Lich King 5-player boss killed the most

112

Deaths from drowning

113

Deaths from fatigue

114

Deaths from falling

115

Deaths from fire and lava

116

Professional Journeyman

121

Journeyman Cook

122

Expert Cook

123

Artisan Cook

124

Master Cook

125

Grand Master Cook

126

Journeyman Fisherman

127

Expert Fisherman

128

Artisan Fisherman

129

Master Fisherman

130

Grand Master Fisherman

131

Journeyman in First Aid

132

Expert in First Aid

133

Artisan in First Aid

134

Master in First Aid

135

Grand Master in First Aid

137

Stocking Up

141

Ultimate Triage

144

The Lurker Above

150

The Fishing Diplomat

153

The Old Gnome and the Sea

154

Arathi Basin Victory

155

Arathi Basin Veteran

156

Territorial Dominance

157

To The Rescue

158

Me and the Cappin' Makin' it Happen

159

Let's Get This Done

161

Resilient Victory

162

We Had It All Along cough

165

Arathi Basin Perfection

166

Warsong Gulch Victory

167

Warsong Gulch Veteran

168

Warsong Gulch Perfection

178

Enchanting formulae learned

181

Items disenchanted

183

Materials produced from disenchanting

189

Largest heal cast

193

Largest hit dealt

197

Total damage done

198

Total healing done

199

Capture the Flag

200

Persistent Defender

201

Warsong Expedience

202

Quick Cap

203

Not In My House

204

Ironman