Re: table design question

        If you have different stores because you are running a service you should keep each store's data in a separate set of tables. Doing so will simplify report preparation and also allow you to assure that each store can only access it's own data.

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 4/14/00, 9:59:56 AM, "Staci Schipporeit" <staci_at_datahost.com> wrote regarding table design question:

> I'm using mysql and php to design a shopping cart.
 

> In looking at work that others have done I noticed that some have a
 base set
> of tables for products, orders, etc and duplicate the tables for each

store.

> The approach I would tend to take (having used other development
 tools)
> would be to attach a store id field to each table and keep all the
 data in
> for all the stores in the same tables.
 

> Can anyone comment on the benefits/drawback of each approach?
 

> Thank you-

> --
> Staci Schipporeit
> Datahost
> http://www.datahost.com
> (541) 746-6418
Received on Sat Apr 15 2000 - 00:00:00 CEST