Database Table For Online Shopping

Online Shopping System is more popular in these days.Each and every site is trying to earn more money by selling online products.Online shopping may be a small portion of your website in which you are trying to sell specific items or products.Here we are thinking about database tables for shopping system.

First think from daily life example. We go to shop and choose some products . We may provide our information.Shopkeeper tell us the cost of that product. We pay money and purchase that stuff or product.

So here are following different activity and entity may considered.

1. Buyer Information.
2. Product Information.
3. Selling Detail.  
4. Invoice table.  

These are Very basic tables for Online Shopping system. Additionally you can use a lot of tables like product category , sub-category of product etc.

Buyer table has buyer registration detail. Product table contains product cost and many more fields related to product. Selling detail table contain payment transaction-id,product-id,buyer-id ,quantity etc.

1. Buyer Information table contains a lot of data about user. But for simplicity we are considering basic fields for buyer table are as  id,name,mobile,email,address etc.

2. Product Table contains id,product_name,model_name and all product info data.


3. Selling detail  table used when buyer will checkout and will redirected to payment gateway website.

4. Last but not the least. Fourth table is invoice table which holds data about transaction of payment and date,time etc.