Sorry for the cross-post (I posted this on evolt.org, but it seems that list has been down for a few hours):
I'm working on a conference registration site and one of the applications will allow sponsors to sign up (and pay) online. I'm trying to make the data as dynamic as possible, but am wondering what would be the best way to design the sponsorship_type tables. Here are the basic requirements: 1) Each type can have at most 5 sponsors 2) There are 7 types: Diamond: covers the entire week Platinum: each sponsor can choose a day's lunch to sponsor (M-Th) Gold: covers the entire week Silver: covers the entire week Partner: covers the entire week Cyber Cafe: covers a single day (Sun - Th), but each sponsor can buy multiple days A/V Services: covers a single day (M - Th), but each sponsor can buy multiple days I'm trying to figure out how to do the sponsorship_type table. If the Cyber Cafe one didn't have "Sunday" listed, then I could just have a "fullweek" flag. If not "fullweek" then each sponsor chooses a day. Or something like that. This will be on a SQL Server 2000 database. Any ideas? Thanks! ------------------------------------------- Scott Brady http://www.scottbrady.net ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
