Spell.dbc/powerType

Version - 3.3.5a - powerType ()

  -2 = HP    
   0 = Mana
   1 = Rage
   2 = Focus
   3 = Energy
   4 = Pet Happiness
   5 = Runes  //Rune Types are as follows in additional Misc Column - 0 = Blood Rune, 1 = Unholy Rune, 2 = Frost Rune, and 3 = Death Rune.
   6 = Runic
   7 = Max Powers
 127 = All Powers

Notes - These are used in at the least Aura Effects number 30, 85, and 110. Visit the page for more information. Also, for clarification this is data for the MiscValue Column when applicable which is dependent on your core version.

Version - 5.4.8 - Powers ()

enum Powers : int8 POWER_HEALTH = -2,

   POWER_MANA                          = 0,
   POWER_RAGE                          = 1,
   POWER_FOCUS                         = 2,
   POWER_ENERGY                        = 3,
   POWER_LIGHT_FORCE                   = 4,
   POWER_RUNES                         = 5,  // Additional Misc Column - 0 = Blood Rune, 1 = Unholy Rune, 2 = Frost Rune, and 3 = Death Rune.
   POWER_RUNIC_POWER                   = 6,
   POWER_SOUL_SHARDS                   = 7,
   POWER_ECLIPSE                       = 8,
   POWER_HOLY_POWER                    = 9,
   POWER_ALTERNATE_POWER               = 10,  // Used in some quests and Boss/NPC encounters.
   POWER_DARK_FORCE                    = 11,
   POWER_CHI                           = 12,
   POWER_SHADOW_ORB                    = 13,
   POWER_BURNING_EMBERS                = 14,
   POWER_DEMONIC_FURY                  = 15,
   POWER_ARCANE_CHARGES                = 16,
   MAX_POWERS                          = 17,
   POWER_ALL                           = 127,
   POWER_HEALTH                        = -2

Version - 10.1.0+ (Master Branch 5/13/23) - Powers ()

enum Powers : int8

   POWER_HEALTH                        = -2, // TITLE Health
   POWER_MANA                          = 0,  // TITLE Mana
   POWER_RAGE                          = 1,  // TITLE Rage
   POWER_FOCUS                         = 2,  // TITLE Focus
   POWER_ENERGY                        = 3,  // TITLE Energy
   POWER_COMBO_POINTS                  = 4,  // TITLE Combo Points
   POWER_RUNES                         = 5,  // TITLE Runes - Rune Types are obsolete.
   POWER_RUNIC_POWER                   = 6,  // TITLE Runic Power
   POWER_SOUL_SHARDS                   = 7,  // TITLE Soul Shards
   POWER_LUNAR_POWER                   = 8,  // TITLE Lunar Power
   POWER_HOLY_POWER                    = 9,  // TITLE Holy Power
   POWER_ALTERNATE_POWER               = 10, // TITLE Alternate
   POWER_MAELSTROM                     = 11, // TITLE Maelstrom
   POWER_CHI                           = 12, // TITLE Chi
   POWER_INSANITY                      = 13, // TITLE Insanity
   POWER_BURNING_EMBERS                = 14, // TITLE Burning Embers (Obsolete)
   POWER_DEMONIC_FURY                  = 15, // TITLE Demonic Fury (Obsolete)
   POWER_ARCANE_CHARGES                = 16, // TITLE Arcane Charges
   POWER_FURY                          = 17, // TITLE Fury
   POWER_PAIN                          = 18, // TITLE Pain
   POWER_ESSENCE                       = 19, // TITLE Essence
   POWER_RUNE_BLOOD                    = 20, // TITLE Blood Runes
   POWER_RUNE_FROST                    = 21, // TITLE Frost Runes
   POWER_RUNE_UNHOLY                   = 22, // TITLE Unholy Runes
   POWER_ALTERNATE_QUEST               = 23, // TITLE Alternate (Quest)
   POWER_ALTERNATE_ENCOUNTER           = 24, // TITLE Alternate (Encounter)
   POWER_ALTERNATE_MOUNT               = 25, // TITLE Alternate (Mount)
   MAX_POWERS                          = 26, // SKIP
   POWER_ALL                           = 127 // SKIP

The above information is located in "..src\server\game\Miscellaneous\SharedDefines.h".
Additional relevant information can be located in the source file of "..src\server\game\Spell\SpellMgr.h + corresponding .cpp file"; among nearby others if available in your server setup.