Some basic functions and implementation methods of background article management

Background

Several words used in the database
The Channel channel is used for channel division level one channel
Class class is used to divide channel channels or level two channels, and so on, generally use channel to record large channels class records subordinate very more subordinate channel type type is used to describe the type of article, such as: recommend original and so on
Speical is especially used to illustrate articles that belong to a topic such as: A topic contains many articles

some common database partitions in the background management
First think about, on the Web page often see the article appears in the form of:
Show the title when the back appears [ recommended ] [boutique ] [ original ] , The text appears Red , Blue , and the font is thick and italic , and so on some conspicuous color, used to show the special place of the article.
And these are generally placed in the type table
The design is as follows:

Table Name: Type

ID type_name

1 recommended

2 Boutique

3 Original

4 Reprint

5 Announcements

6 download

7 Note

8 recommendations

9 Focus

10 Social

In the background page implementation picture is as follows: