Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: table design question

Re: table design question

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: 2000/04/15
Message-ID: <20000415.6333200@noname.nodomain.nowhere>#1/1

        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 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US