table design question

From: Staci Schipporeit <>
Date: 2000/04/14
Message-ID: <TnGJ4.414$>#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
(541) 746-6418
Received on Fri Apr 14 2000 - 00:00:00 CEST

Original text of this message