DB/ItemModifiedAppearance

≥ 

8.0.1.25902

struct ItemModifiedAppearanceRec {
  uint32_t ItemId;
  uint32_t Id;
  uint8_t AppearanceModID;
  uint16_t AppearanceId;
  uint8_t VariationIndex;
  uint8_t SourceType; // added in 21108, values 0...9
};

≥  (I discovered this in BfA, but it may apply to other versions)

If you open ItemModifiedAppearance.db2, you will find many negative values in the AppearanceID column. It is because the IDs in ItemAppearance.db2 are uint32_t, whereas here, as you can see, they are uint16_t (for whatever reason).

In order to link entries in the two tables, you can use https://cryptii.com/pipes/integer-converter : decode the original ID as a 32-bit integer, and encode it as a 16-bit signed integer.

Example:

- The actual ItemAppearanceID is 35976, but in ItemModifiedAppearance it becomes -29560.