Blog Module Table Structure
Blog
| Field | Description |
|---|---|
| ID | Blog ID. |
| NAME | Blog name. |
| DESCRIPTION | Blog description. |
| DATE_CREATE | Date when blog was created. |
| DATE_UPDATE | Date when blog was modified last. |
| ACTIVE | Blog activity flag. |
| OWNER_ID | User - blog owner ID. |
| URL | Blog address. |
| GROUP_ID | Blog group ID. |
| ENABLE_COMMENTS | Flag - whether comments in blog are permitted. |
| ENABLE_IMG_VERIF | Flag - whether to use CAPTCHA for anonymous comments. |
| ENABLE_RSS | Flag - whether export to the blog RSS is permitted. |
| LAST_POST_ID | The ID of the last blog post. |
| LAST_POST_DATE | Date of the latest blog post. |
| AUTO_GROUPS | Open groups. |
| EMAIL_NOTIFY | Flag - specifies whether to send emails with new comments, messages. |
Blog posts
| Field | Description |
|---|---|
| ID | Blog post ID. |
| TITLE | Blog post header. |
| BLOG_ID | Blog post ID. |
| AUTHOR_ID | ID of the blog post author - site user. |
| CODE | Blog post code. |
| DETAIL_TEXT | Blog post text. |
| DATE_CREATE | Blog post creation date. |
| DATE_PUBLISH | Date when blog post was published. |
| KEYWORDS | Blog post keywords. |
| PUBLISH_STATUS | Blog post status. Values: P - comment is visible, K - comment is hidden. |
| CATEGORY_ID | Blog post category ID. |
| ATRIBUTE | Blog post attributes. |
| ENABLE_TRACKBACK | Flag - specifies whether trackbacks are enabled for this blog post. |
| ENABLE_COMMENTS | Flag - whether comments are permitted for this blog post. |
| NUM_COMMENTS | Number of comments to the blog post. |
| NUM_TRACKBACKS | Number of trackbacks to the blog post. |
Comments blog posts
| Field | Description |
|---|---|
| ID | Comment ID. |
| BLOG_ID | Blog ID. |
| POST_ID | Blog post ID. |
| PARENT_ID | Parent comment ID. |
| AUTHOR_ID | ID of the user - comment author. |
| ICON_ID | Comment icon ID. |
| AUTHOR_NAME | Name of the anonymous comment author. |
| AUTHOR_EMAIL | Email of the anonymous comment author. |
| AUTHOR_IP | IP of the comment author. |
| AUTHOR_IP1 | IP of the comment author. |
| DATE_CREATE | Date when comment was created. |
| TITLE | Comment header. |
| POST_TEXT | Comment text. |
Blog groups
| Field | Description |
|---|---|
| ID | Group ID. |
| NAME | Group name. |
| SITE_ID | Group site ID. |
Trackbacks for blog posts
| Field | Description |
|---|---|
| ID | Trackback ID. |
| TITLE | Trackback header. |
| URL | Trackback address. |
| PREVIEW_TEXT | Trackback text. |
| BLOG_NAME | Blog name. |
| BLOG_ID | Blog ID. |
| POST_DATE | Date when blog post was created. |
| POST_ID | Blog post ID. |
Blog users
| Field | Description |
|---|---|
| ID | Blog user ID. |
| USER_ID | Site user ID. |
| ALIAS | Blog user alias. |
| DESCRIPTION | Blog user description. |
| AVATAR | Blog user avatar. |
| INTERESTS | Blog user interests. |
| LAST_VISIT | Date of the last visit. |
| DATE_REG | Blog user registration date. |
| ALLOW_POST | Flag. It determines, whether user is permitted to create blog posts. |
Blog user groups
| Field | Description |
|---|---|
| ID | Blog user group ID. |
| NAME | Blog user group name. |
| BLOG_ID | User group blog ID. |
© «Bitrix24», 2001-2024