B2C e-commerce System Conceptual Data Model Analysis and Design

B2C e-commerce System Conceptual Data Model Analysis and Design

 

 

If you want to reprint it, Please retain your copyright:
/*
* Description: B2C e-commerce System Conceptual Data Model Analysis Design
* Auther: chongchong2008-innocent blue
* MSN: chongchong2008@msn.com
* QQ: 154674958
* Blog: chongchong2008.cnblogs.com
* Dates: 2010-01-13
* Copyright: chongchong2008 Yichang Hubei China
*/

 

I probably browsed the shopping websites on the way down the internet, and experienced some "free" e-commerce systems (could it be possible to fall off the pie in the world, huh, huh). I learned some services, some of which are really good, various languages are implemented. I mean, it is quite good, but it is a bit dizzy for me. It may be different from my own usage philosophy. Just create one by yourself, isn't it fun? So I want to write an e-commerceProgramThoughts.

The following describes how to design this e-commerce program. After my understanding, B2C e-commerce data models are divided into the following parts:

 

I. Basic definition of a Data conceptual model, excluding the relationship between models

1. Member:
====================================
1.1 Basic Member Data
1.2 member role data
1.3 personalized Member Data
1.4 member grade data

 

2. Product section:
====================================
2.1 product type data model

2.2 product brand Data Model

2.3 Supplier Data Model

2.4 commodity classification data model

2.5 commodity Data Model

2.6 commodity tag Data Model

2.7 product attribute data model

2.8 commodity property value data model

2.9 item option Data Model

2.10 item option value data model

2.11 product parameter group data model

2.12 product parameter data model

2.13 product album Data Model

2.14 Product accessory Data Model

2.15 Product Data Models

2.16 product type data model

2.17 bundled Product Data Model

2.18 bundled item Data Model

2.19 commodity consulting Data Model

2.20 product consulting reply Data Model

2.21 product comment Data Model

2.22 product favorites

3. Promotion part:
====================================
3.1 sales promotion discount Data Model

3.2 discount region Data Model

4. Order part:
====================================
4.1 orders
4.2 order items
4.3 order options
4.4 order status
4.5 order gifts
4.6 Payment Method

5. Delivery part:
====================================
5.1 delivery method and cost

 

Through analysis, we decided to put forward several of the items separately:
1. The member system is proposed from the E-commerce system and accessed by the member management subsystem.
2. The e-commerce display and display template are also proposed and accessed using the CMS subsystem.
3. Put forward the product album and connect it with the album subsystem.
4. Put forward the comments and use the comments sub-system to access them. You can also do not mention it. Create one more table in the e-commerce sub-system to implement it and check your personal plans.
5. I also raised my comments and replies. I can use the message sub-system to access them. I can also create two more tables in the e-commerce sub-system to achieve this by looking at my personal plans.

I found that many B2C e-commerce systems I have experienced have put all templates in them. I think this part should be handed over to CMS.

 

 

 II. Complexity of E-commerce needs

1. Product extension attributes, options, and parameter complexity
The complexity of e-commerce systems lies in the extended attributes, options, and parameters that are unique to product types (pages can be called top-level categories, depending on how they are designed,
Take the clothing type as an example:

Attribute
======================================
Material: cotton, 40% cotton + 60% polyester
.
.
.

Option
======================================
Color: red, blue, etc.
Size: XL, L, etc.
.
.
.

The design of these attributes and the option data model is a headache. There are a variety of different solutions, and some can be associated like pure relational databases, in addition, serialized objects can also be used for storage. In addition, data tables can be designed by using multi-sink fields. As for efficiency, you have to make a choice on your own, depending on how you decide, but the finalized program should be written according to the data model.

 

2. complexity of discount promotion rules

2.1 promotion discount objects
This requires an understanding of the business. Simply put, there is only a discount on the order, not the discount and promotion of a single item. This makes it easier to calculate the total order price.
Of course, we have to make our own plans.

 

2.2 promotion discount rule Definition
 
2.2.1 The Order rules are as follows:

2.2.1.1 direct discount
That is to say, full 800, discount 30 (that is, from 800 minus 30)

2.2.1.2 full direct discount
That is to say, if the price is 1500, the discount is 9.5 (that is, the discount is 1500*(1-0.95 ))

2.2.1.3 offer discount at full capacity
That is to say, if it is over 5000 Yuan, you will be given a discount equivalent to RMB 500. The next time you shop, you can use it directly in RMB when you pay the order. Is it tempting.

2.2.1.4 complimentary items
That is to say, 2000 yuan is used to send a sports water bottle or a box of wonton cakes, so that customers can choose when placing their orders.

 

2.2.2 rules for a single item are as follows:
2.2.2.1 direct discount for full parts
That is to say, the unit price of the same item is 1500. If the customer buys 30 items at the same time, the discount is 9.5 (that is, the discount is 1500*(1-0.95 ).

Some rules are mutually exclusive, that is, they cannot be enabled at the same time. Please make a good plan.

In fact, the direct discount and direct discount in the order rules are the same, but only a vest is changed. If you can, you can remove the direct discount.
Well, merchants are just doing what they do, that is, they want you to pay more. The so-called "no-seller" is not "excellent.

 

Processing of three orders

There are a lot of additional fields in the order, because the product price and promotion activities change at any time, so you have to place the current price of the product when the customer places the order, the current promotion activities are recorded to calculate the commodity amount.

The order amount must be combined with your own promotion rules. Otherwise, it is easy to miscalculate the commodity amount.

 

Processing of order gifts.

 

Now, let's analyze what to use.Programming LanguageImplementation, everyone is interested in it. In the design of the data conceptual model .................
Please correct and learn from each other!