This is going to be a tough one...
I'm creating a shopping cart for Magic the Gathering cards. I need to be able to display and search the following info:
Card Name,Set,Color,Type,Rarity,Casting Cost,Power,Toughness,description,Artist,Converted Mana Cost,price.

Now, I can see that I would make the Manufacuture being the card set. I also imagine the either the color or the type (both??) are categories. However, Rarity, Casting cost... etc... How add fields for that?

I am comfortable in php and mysql, just trying to figure out the best way to handle this.

on the product page, it would show all these stats. On the search page, I could search for any Blue cards, that are Wizards with a Casting Cost of 1