MySQL Design Question

MySQL Design Question

El Forum
Guest

12-18-2009, 04:25 PM

[eluser]insub2[/eluser]
[quote author="jedd" date="1261194487"]If I review Business J's branch located at Location #27 - and a year later Business J closes the office at Location #27 - what do you want to happen to that review?[/quote]

The location is marked closed and can no longer be review. Existing reviews are not effected.

The reviews get tallied for teh business as a hole unless the user drills down to just the locations (via a list presented on/accessible from the Business' page).

Messages In This Thread

MySQL Design Question - by El Forum - 12-18-2009, 04:43 AM

MySQL Design Question - by El Forum - 12-18-2009, 05:15 AM

MySQL Design Question - by El Forum - 12-18-2009, 09:28 AM

MySQL Design Question - by El Forum - 12-18-2009, 09:33 AM

MySQL Design Question - by El Forum - 12-18-2009, 10:02 AM

MySQL Design Question - by El Forum - 12-18-2009, 03:48 PM

MySQL Design Question - by El Forum - 12-18-2009, 04:25 PM

MySQL Design Question - by El Forum - 12-18-2009, 04:31 PM

MySQL Design Question - by El Forum - 12-18-2009, 04:35 PM

MySQL Design Question - by El Forum - 12-18-2009, 04:49 PM

MySQL Design Question - by El Forum - 12-18-2009, 05:05 PM

MySQL Design Question - by El Forum - 12-18-2009, 05:08 PM

MySQL Design Question - by El Forum - 12-18-2009, 05:12 PM

MySQL Design Question - by El Forum - 12-18-2009, 05:23 PM