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.