Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2013
    Posts
    2

    Unanswered: tables for E-commerce website

    we are doing the project of type E-Commerce. i need some clarity of db tables.
    how many tables and what are they...

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    how many tables and what are they...
    how many... well as many as your business requirements, and your analysis of those needs
    as to what they are, see above

    as a minimum you are going to need a table for products, and after that who knows.

    do you need / want to store customer details, then you'll need a table for that
    do you need / want to store customer orders, then you'll need a table for that
    do you need to differentiate your products into types, sub types and so on,, then you'll need a table for that
    do you need / want to be able to make suggestions of products which may match based on the customers previous purchase and or search history, then you'll need tables for that
    do you need / want your customers to be able to search your products by categories, types and so on, then you'll need table(s) for that
    ..and so on.

    E-Commerce is a generic term, what is suitable for a large multinational will probably not be suitable for a one man band

    so you need to investigate what you mean by E-Commerce, find out what faciltiies you need to offer and support and develop your design from there. you may find some sample schema by using google
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Mar 2013
    Posts
    2
    thanks for ur reply... its good..

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •