# CommentThreads ## Documentation The comment threads left on the pages of the sites in the Designer. Holds names and e-mail addresses of collaborators. - Catalog: `Webflow` - Schema: `Comments` - Primary Keys: `id` This is a read-only table. The Webflow API may not support changing the data or the Invantive UniversalSQL driver for Webflow does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Webflow API. ## Table Columns The columns of the table `CommentThreads` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `author_email` | `varchar2` | | ☐ | The e-mail address of that user. | | `author_name` | `varchar2` | | ☐ | The name of that user. | | `author_user_id` | `varchar2` | | ☐ | The user who started the thread. | | `breakpoint` | `varchar2` | | ☐ | The breakpoint, such as main or tablet, the comment was left on. | | `content` | `varchar2` | | ☐ | The text of the first comment. | | `created_on` | `datetime` | | ☐ | When the thread was started, UTC. | | `id` | `varchar2` | | ☑ | The id of the thread. | | `is_resolved` | `char` | | ☐ | Whether the thread is resolved. | | `item_id` | `varchar2` | | ☐ | The CMS item the comment is on, on a template page. | | `last_updated` | `datetime` | | ☐ | When the thread was last changed, UTC. | | `locale_id` | `varchar2` | | ☐ | The locale the comment was left in. | | `page_id` | `varchar2` | | ☐ | The page the comment is on. | | `site_id` | `varchar2` | | ☑ | The site. | | `url` | `varchar2` | | ☐ | The address of the page. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `page_id` | [[Pages-Pages\|Pages.Pages]] | `id` | Declared by the connector, not enforced by the platform |