This is straight up design question! Granted it could have been writing better, I didn't fully understand what he was asking at first. But Off Topic???
I was one of the close-voters so I'll just explain why that's so.
Basically, after reading the question for the first time, it sounded like 70% business question and 30% database design question. Now that is probably because the question was poorly worded and difficult to understand. Personally, I did not edit it because I wasn't sure what he was trying to ask. All I knew was that it sounded off-topic in it's current form.
Honestly, after your edit, it is much more clear what the OP is asking, and I have cast my reopen vote. Thanks for the clarification Morons!