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