phome_ecms_news_doc
Field name | Type | Explanation | Additional instructions |
id | int(11) | Information ID | |
##classid | smallint(6)Column ID | ||
int(11) | Number of clicks | ||
char (20) | Storage date directory|||
char(160) Keyword | ##keyid | ||
Related link information ID collection | Multiple information IDs are separated by half-width commas ","userid | ||
Publisher User ID | ##username | ||
Publisher Username | ##ztid | ||
Multiple topic IDs are separated by "|", for example: |1|5| | checked | tinyint(1) | |
1 means reviewed, 0 means not reviewed | ##istop | tinyint(1) | |
truetime | int(10) | True release time | unix timestamp |
ismember | tinyint(1) | Whether a member publishes | 0 means backend release, 1 means frontend member Release |
dokey | tinyint(1) | Whether to replace the content keyword | 0 is no Replace, 1 is to replace |
userfen | smallint(6) | Deduction points | |
isgood | tinyint(1) | Whether it is recommended | 1 is recommended, 0 is Not recommended |
titlefont | char(20) | title with color and bold | format : "#ff0000,b|i|s|" |
titleurl | char(200) | External link address | |
##filename | char(60)Information file name | Without extension | |
groupid | smallint(6)View member group ID | ||
newstempid | smallint(6)Content Template ID | 0 Content template selected for use column | |
plnum | int(11)Number of comments | ||
firsttitle | tinyint(1)Whether headline | 1 is the headline, 0 is normal information | |
isqf | tinyint(1)Whether to issue information | 1 is Issuance information, 0 is non-issuance information | |
int(11) | Number of downloads | ||
char(200) | Title field | ||
newstime | int(10) | Publishing time field | unix timestamp |
titlepic | char(200) | Title picture field | |
closepl | tinyint(1) | Whether to close the comment | 1 means to close the comment, 0 means not to close the comment |
havehtml | tinyint(1) | Whether HTML tags have been generated | 1 means generated, 0 Not generated |
lastdotime | int(10) | Information modification time | unix timestamp |
haveaddfen | tinyint(1) | Have you ever given a point mark? | After submitting an article, you will receive points. Marks that are no longer given away |
infopfen | int(11) | Total number of ratings | |
infopfennum | int(11) | Total number of ratings | |
votenum | int(11) | Information vote total | |
stb | char(4) | Storage sub-table name | |
copyids | char(255) | ID record of synchronously copied information | |
ttid | smallint(6) | Title Category ID | |
infotags | char(160) | TAGS | |
ispic | tinyint(1) | Whether the title picture is | 1 is the title picture information, 0 is the normal information |
The following are custom fields | |||
ftitle | char(120) | Subtitle field | |
smalltext | char(255) | Introduction field | |
diggtop | int(11) | DIGG field |