| id |
int(11) |
Information ID |
|
| classid |
smallint(6) |
Column ID |
|
| onclick |
int(11) |
Number of clicks |
|
| newspath |
char(20) |
Storage date directory |
|
| keyboard |
char(160) |
Keywords |
|
| keyid |
char(255) |
Related link information ID collection |
Multiple information IDs are separated by half-width commas "," |
| userid |
int(11) |
Publisher User ID |
|
| username |
char(30) |
Publisher Username |
|
| ztid |
char(255) |
Topic ID |
Multiple topic IDs are separated by "|", for example: |1|5| |
| checked |
tinyint(1) |
Whether to review |
1 means reviewed, 0 means not reviewed |
| istop |
tinyint(1) |
Top level |
|
| truetime |
int(10) |
Real release time |
unixTimestamp |
| ismember |
tinyint(1) |
Whether members publish |
0 is for backend release, 1 is for frontend member release |
| dokey |
tinyint(1) |
Whether to replace content keywords |
0 means no replacement, 1 means replacement |
| userfen |
smallint(6) |
Deduction points |
|
| isgood |
tinyint(1) |
Whether it is recommended |
1 is recommended, 0 is not recommended |
| titlefont |
char(20) |
Add color and bold to the title |
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 is the content template selected for the column used |
| plnum |
int(11) |
Number of comments |
|
| firsttitle |
tinyint(1) |
Whether it is a headline |
1 is headlines, 0 is general information |
| isqf |
tinyint(1) |
Whether to issue information |
1 is the issued information, 0 is the non-issued information |
| totaldown |
int(11) |
Number of downloads |
|
| title |
char(200) |
Title field |
|
| newstime |
int(10) |
Publish time field |
unixTimestamp |
| titlepic |
char(200) |
Title Image Field |
|
| closepl |
tinyint(1) |
Whether to close comments |
1 means closing comments, 0 means not closing comments |
| havehtml |
tinyint(1) |
Whether HTML tags have been generated |
1 means generated, 0 means not generated |
| lastdotime |
int(10) |
Information modification time |
unixTimestamp |
| haveaddfen |
tinyint(1) |
Whether points tokens have been given away |
Mark that points will no longer be given after submission |
| infopfen |
int(11) |
Total Rating |
|
| 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 synchronized replication information |
|
| ttid |
smallint(6) |
Title Category ID |
|
| infotags |
char(160) |
TAGS |
|
| ispic |
tinyint(1) |
Whether the title picture |
1 is the title image 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 |
|
