playerclass

The smallest table in the data corpus — 2 columns, 9 rows — and one of the most-referenced. Every table that needs to identify "this is for the Amazon" uses the 3-letter codes defined here, not the display names.

Locbones coverage

playerclass is not documented in locbones D2R Data Guide beyond a passing mention. The two columns (Player Class display name + Code 3-letter key) are unambiguous from the data.

The full mapping

The 9th row is a sentinel Expansion (with blank Code) that separates the 5 Classic-game classes from the 3 Expansion classes (Druid, Assassin, Warlock). It's marker data, not a real class — filter with WHERE "Code" != '' to exclude it.

Where the codes are used

• skills charclass — every class-specific skill carries one of these codes. charclass=sor means a Sorceress skill.
• itemtypes Class — class-restriction. itype=orb has Class=sor ⇒ orbs are Sorceress-only.
• itemtypes StaffMods — staffmod-bearing itypes. itype=knif has StaffMods=war ⇒ knives roll Warlock staffmods.
• magicprefix / magicsuffix class — class-specific affixes (e.g. the various class skiller suffixes).
• automagic class — class-specific auto-rolled mods.
• magicprefix / magicsuffix classspecific — flag column that flips on when the affix is class-locked; the class column carries which class.

Naming notes

• The codes are always lowercase. Cross-table references match exactly.
• The [Class]Only strings in charstats StrClassOnly (AmaOnly, SorOnly, …) are a separate string-key system used for tooltip rendering — they are not the same as these codes.
• The Warlock class (added in D2R) follows the same war 3-letter pattern as the original 7 classes.

Cross-references

• charstats — the same 9 classes by display name plus per-class baseline data (life/mana scaling, starting attributes, etc.).
• skills — charclass keys on this table's Code.
• itemtypes — Class and StaffMods columns key on this table's Code.