Re: Logic question

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 43173
interpreted = N
texte = PatrickJ wrote: > We are hosting a film festival website. They would like to do online ticket > reservations (NOT sales). However, the spreadsheet they came up with > represents about just under 73 trillion fields. Here are the essentials: > Multiple tables should make this much easier:theatre.db theatre_key theatre_location theatre_capacity ...etc...movie.db movie_key movie_title movie_description ...etc...stars.db movie_key star_name also_in_movie_key ...etc...^^^ These three tables are for reference only (no updates). Add fields as needed.package.db package_key package_name package_seats ordered^^^ This table stores both the available packages as well as how many have been ordered of each package.schedule.db sched_key movie_key theatre_key time reserved open^^^ This table stores the entire schedule of showings, as well as how many seats have been reservered or are still open. At all times theatre_capacity == reserved + openfor a given showing in a given theatre.reservations.db SKU sched_key seats ...etc...The reservations.db contains the ordered tickets, one per movie/theatre/time combination. A given package determines how many tickets total the user gets, which in turn determines how many records in reservations.db have the same SKU (i.e. part of the same order).You can throw in some additional summary fields to the other tables if that makes your reporting easier.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Logic question (PatrickJ 2002)
  2. Re: Logic question (John Peacock 2002)
  3. Re: Logic question (ROBERT MCPEAK 2002)
  4. Logic question (PatrickJ 2002)
PatrickJ wrote: > We are hosting a film festival website. They would like to do online ticket > reservations (NOT sales). However, the spreadsheet they came up with > represents about just under 73 trillion fields. Here are the essentials: > Multiple tables should make this much easier:theatre.db theatre_key theatre_location theatre_capacity ...etc...movie.db movie_key movie_title movie_description ...etc...stars.db movie_key star_name also_in_movie_key ...etc...^^^ These three tables are for reference only (no updates). Add fields as needed.package.db package_key package_name package_seats ordered^^^ This table stores both the available packages as well as how many have been ordered of each package.schedule.db sched_key movie_key theatre_key time reserved open^^^ This table stores the entire schedule of showings, as well as how many seats have been reservered or are still open. At all times theatre_capacity == reserved + openfor a given showing in a given theatre.reservations.db SKU sched_key seats ...etc...The reservations.db contains the ordered tickets, one per movie/theatre/time combination. A given package determines how many tickets total the user gets, which in turn determines how many records in reservations.db have the same SKU (i.e. part of the same order).You can throw in some additional summary fields to the other tables if that makes your reporting easier.HTHJohn-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747 ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ John Peacock

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

setting taxable to true (1997) delete file (2000) WebDNA 5 & iTools 7 (2003) Nesting searches. (1998) Typhoon/Pro do SQL? (2001) Sense/Disallow HTML tags during $Append (1997) NT Manual (1997) Migrating to NT (1997) Re[3]: 2nd WebCatalog2 Feature Request (1996) Unique SKUs (2000) Search Engine questions ... (2002) Width & Height (1998) OT: Several requests (2003) THANKS (1997) emailer (1997) WebCatalog Mac 2.1b3 (1997) WebCat2 several catalogs? (1997) Loop into field (1998) Product Value Changes (2000) WebDNA 6 (2004)