table design question

From: Staci Schipporeit <staci_at_datahost.com>
Date: 2000/04/14
Message-ID: <TnGJ4.414$Y14.10455_at_news.uswest.net>#1/1


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 Fri Apr 14 2000 - 00:00:00 CEST

Original text of this message