how to manage products with different flags?

[PHPycho]

How do you handle product with different flags like featured, new, christmas special, valentine special..?

do you use fields in the same product table (sayroducts)
or different table
But How?

[LifeinAsia]

I use both. If it's something I planned for from the beginning (like featured), I'll have a field in the main table. If it's something I decided to add later (like Christmas Specials), and the main table is pretty big, I'll probably make a separate table.

[Demaestro]

If there will only be 1 flag active at anytime then I would have flag details stored in a seperate table and then store the flag_id in a column on the main table.

Products:
prod_id, prod_name, flag_id

Flags:
flag_id, flag_name, flag_desc