Products

Solutions

Resources

Partners

Community

About

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreData structure commentsData structure comments
Previous
 
Next
New Post
1/31/2006 7:15 PM
 

First, great job on the beta release of the store module.  The templating method should be used as a model for all other modules.

I have some concerns on the data object model that I think may limit the store in some future scenarios. 

In general, my main concern is the use of PortalID as a foriegn key on most of the tables.  This implies a portal can only have one store.  I can easily see use cases where someone might want multiple stores on the same portal.  I can also see use cases where someone would want to implement the same store (with same products) on multiple portals. 

"Store" is the business object.  Therefore, StoreID should be the primary/foreign key. 

You could still impose the 1 portal/1store concept if you want to by creating a 1-1 relation table of Portal<->Store.  However, by structuring the DB to reflect the real business objects, you at least open up the possibility for someone else to implement the store differently, ie. 1 store / many portals.  I personally have a use case where I need to implement the exact same store on about 60 different portals.  Yes, I know I could set up one portal to contain the store and direct everyone there, but there are business reasons the same storefront needs to be embedded in each of the various portals.  If the DB were structured properly, I could create an alternative admin module control that allowed the portal admin to connect to an existing Store or create a brand new Store.  Perhaps a web.config setting to turn this ability on/off per DNN installation.

1) Store_Address -- I assume this is meant to track customer addresses (bill to, ship to, etc).  Address is specific to User and there is already a UserID field. 

2) Store_Administration  -- PortalID should be StoreID

3) Store_Cart -- PortalID should be StoreID

4) Store_Categories - PortalID should be StoreID

5) Store_Order -- PortalID should be StoreID

6) Store_Products --PortalID should be StoreID

7) Store_Reviews -- PortalID should be StoreID

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsStoreStoreData structure commentsData structure comments


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out