One of the main goals with GameID is to use it as the index of a new table for games and to migrate the game-specific columns of the Item table to the new table. While doing that, I would also like to consider revising the categories we use for games. In particular, we have a bunch of usual equipment categories that each effectively combine two categories into one. It might be better to have just a single usual equipment category, then replace the usual equipment categories we have now with ones that describe only one feature of the game, such as having different board rules or a different winning condition. These would help us better categorize games played with different equipment, and when used in combination with the usual equipment category, we could still query the database for lists of usual equipment games in the same categories we can now.
One of the main goals with GameID is to use it as the index of a new table for games and to migrate the game-specific columns of the Item table to the new table. While doing that, I would also like to consider revising the categories we use for games. In particular, we have a bunch of usual equipment categories that each effectively combine two categories into one. It might be better to have just a single usual equipment category, then replace the usual equipment categories we have now with ones that describe only one feature of the game, such as having different board rules or a different winning condition. These would help us better categorize games played with different equipment, and when used in combination with the usual equipment category, we could still query the database for lists of usual equipment games in the same categories we can now.