---
title: "DiscussionForumTopics (Freshdesk)"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Views.DiscussionForumTopics
original: https://documentation.invantive.eu/en/datamodels/freshdesk/Freshdesk.Views.DiscussionForumTopics
updated: 2026-06-04T07:55:59Z
license: https://documentation.invantive.eu/en/
---

# DiscussionForumTopics: Freshdesk

`read only`

- Catalog: `Freshdesk`
- Schema: `Views`

Can only retrieve data.

## Table Columns

The columns of the table `DiscussionForumTopics` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.

| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `body_html` | `varchar2` | Body (HTML) | [ ] |  | Message body of the topic. |
| `comment_count` | `int64` | Comment Count | [ ] |  |  |
| `created_at` | `datetime` | Created at | [ ] |  | Date/time at which the record was created. |
| `forum_id` | `int64` | Forum ID | [ ] |  | ID of the containing forum. |
| `hits` | `int64` | Hits | [ ] |  | Number of views of the topic. |
| `id` | `int64` | ID | [ ] |  | Unique ID of the topic. |
| `last_post_id` | `int64` | Last Post ID | [ ] |  | ID of the latest comment on the topic. |
| `locked` | `char` | Locked | [ ] |  | Whether the topic has been locked. |
| `merged_topic_id` | `int64` | Merged Topic ID | [ ] |  |  |
| `posts_count` | `int64` | Posts Count | [ ] |  | Number of posts in the topic. |
| `published` | `char` | Published | [ ] |  |  |
| `replied_at` | `datetime` | Replied at | [ ] |  | Timestamp of the latest comment made in the topic. |
| `replied_by` | `int64` | Replied by | [ ] |  | ID of the user who made the latest comment in the topic. |
| `stamp_type` | `int64` | Stamp Type | [ ] |  |  |
| `sticky` | `char` | Sticky | [ ] |  | Whether the topic should stay on top of the forum for additional visibility. |
| `title` | `varchar2` | Title | [ ] |  | Title of the topic. |
| `updated_at` | `datetime` | Updated at | [ ] |  | Date/time at which the record was last updated. |
| `user_id` | `int64` | User ID | [ ] |  | ID of the user. |
| `user_votes` | `int64` | User Votes | [ ] |  | Number of votes in the topic. |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Freshdesk](/en/release-notes/drivers?driver=freshdesk)

