Ugh, why is Minecraft so complicated under the hood?

I thought I had the indexing of items down, but apparently there are many more that aren't simply of a certain type. Not only weapons and armor can have enchantments of a certain level. Banners, fireworks and potions are even more complicated with a variable number of modifications on multiple levels. That's going to make it a whole lot more difficult to store in the database and find the price of items when a player tries to sell them. I'm not sure if it's even possible at all at this point... 🙁