Table with many boolean "status" fields
I have a table which represent an object that has multiple "status" (approved, expired, trending, real). All these status are independent, so i can't have like a single status field because queries can be made so you can ask:

    select * from Objects WHERE approved is true, trending is true, expired is false;

I'm not sure if there is anyway to normalize such table. Also, from what i understand, using indexes for those fields would be basically useless. Is that right for this case also?

Thanks!


Table with many boolean "status" fields
===

I have a table which represent an object that has multiple "status" (approved, expired, trending, real). All these status are independent, so i can't have like a single status field because queries can be made so you can ask:

    select * from Objects WHERE approved is true, trending is true, expired is false;

I'm not sure if there is anyway to normalize such table. Also, from what i understand, using indexes for those fields would be basically useless. Is that right for this case also?

Thanks!

