How to model multiple “uses” (e.g. weapon) for usable-inventory/object/items (e.g. katana) within a relational database If you wanted a lookup table in the DB for the traits (probably a good idea as you can then add them dynamically to any editor then) then it would just have something like this: id,bitmask,description. 1,1,"Holdable"; 2,2,"Weapon"; 3,4,"Breakable", etc. With regards to the fixed number, yes this is true. But if you use a 64bit int you should have plenty of scope.
meta user
network profile
