asp.net public platform Development (i) database design

The development of micro-credit public platform, before the micro-letter to the official understanding of the general situation here: http://mp.weixin.qq.com/wiki/index.php; After looking at the heart of a few, began to design the database, as far as possible, did not take into account, and then Add.

1, the first is the user part, according to the micro-letter official interface with the actual application, the user part has 3 tables: User table, user Information table, User Group table, I designed the following:

2, after the user design is the article section, including: Article Classification table, article table, design as follows:

3, with the user-related table we can save users, with the article module table we can query the user input information to return (return text, graphics, pictures, music, video, voice, etc.), but in practice, we have the need to specify a specific keyword return specific content of the situation, Then you need specialized specific keyword modules, include: Keyword table, keyword returned content table, where the contents of the table looks like the table with the above overlap, but in fact, here is the specific keyword specified reply content, you can specify the return text, graphics or other multimedia information,  When the return of multimedia information in the content of the file address, the above article table is a Standard General content table, for users to query the majority of cases directly returned to the picture and text information, and text information click on the link is this article corresponding to the display address, the equivalent of a micro-site,  So the article and this keyword content table separate design more convenient management. The design is as follows: