adding one time options to items
Posted
by rap-uvic
on Stack Overflow
See other posts from Stack Overflow
or by rap-uvic
Published on 2010-04-29T15:55:52Z
Indexed on
2010/04/29
15:57 UTC
Read the original article
Hit count: 421
Hello,
I'm building an Event Registration site. For any given event, we'll have a handful of items to choose from. I have a table for these items. For each event we might have special options for users. For example, for one of the events new users get to buy an item which is not available to other users. This may not apply to all the events. For other events we might have some other restriction on items. I will obviously be checking this programmatically on application side. I would like to though, set up a column containing flag in the items table. But I don't find it feasible because this condition may only apply to one particular event. I don't want all the future items to have this column. What is a good approach to take in such a situation? Should I create a special "restrictions" table and just do a join? How would I handle this on the application side?
© Stack Overflow or respective owner