I'm reposting this. I think it got lost in the shuffle. Any suggestions? -------------------------------- Scott Brady http://www.scottbrady.net/
---------- Original Message ---------------------------------- From: "Scott Brady" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Wed, 5 Feb 2003 18:55:18 -0700 >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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4