Hugo,

It sounds like you have the luxury of getting to define your own database schema. In the small company that I work for, the database guy (yours truly) has to support integration of any other software we need that uses the DB so bitmasks are a fact of life.