Shulou(Shulou.com)06/03 Report--

The purpose of this article is to share with you the contents of the sample analysis of database design for asp.net 's development of Wechat public platform. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

1. The first part is the user part. According to the official interface of Wechat combined with practical application, the user part has three tables: user table, user profile table and user grouping table. The ones I designed are as follows:

2. After the user has designed it, there will be the article part, including: article classification table, article table, the design is as follows:

3. With the table related to the user, we can save the user, and with the table of the article module, we can query the article and return it according to the information entered by the user (return text, picture, picture, music, video, voice, etc.). But in practical application, we need to specify specific keywords to return specific content, so we need a special specific keyword module. Include: keyword table, content table returned by keywords. The content table here looks like it coincides with the above article table, but it is not. Here is the reply content specified by a specific keyword. You can specify to return text, picture and text, or other multimedia information. When the multimedia information is returned, the file address is stored in the content. The above article table is a standard general article content table. For users to query in most cases directly return the picture and text information, and the picture and text information click on the link is the corresponding display address of this article, which is equivalent to a micro-website, so it is more convenient to manage the article and the content table of this keyword separately. The design is as follows:

4. Message recording, recording the message sent by the user to facilitate subsequent processing, for example, according to the last event message sent by the user, and then sending the same keyword, return the content under the corresponding menu, instead of requiring users to send messages with corresponding menu options; customer service messages do personalized services according to the recorded information, and so on. Including: the message record table sent by the user, the message record table replied to the user, with these can completely restore the conversation with the user, here is the process of recording the communication with the user, and what kind of message needs to be returned by the message sent by the specific user, it is decided by the business in the project code. The design is as follows:

5. Custom menus. Create and manage custom menus in Wechat public platform. The design is as follows:

6, others, specifically designed according to the actual project done, such as user analysis, access statistics; user points; QR code correlation, etc., not designed here.

Some of the above designs are not designed to the database, such as the reply message type in the keyword module, the message type in the message record, and these fixed (determined by Tencent) a small amount of single-option data. We use other methods to implement (fixed static, configuration files, cache, etc.) in specific projects, without the need to design the database.

The complete design is as follows: (to facilitate screenshots, I dragged the tables of each module to cover them.)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.