# SheetDiscussions ## Documentation The conversations on the sheets and on their rows. The comments are in SheetComments. A filter on sheet_id reads one sheet only. - Catalog: `Smartsheet` - Schema: `Sheets` - Primary Keys: `discussion_id` This is a read-only table. The Smartsheet API may not support changing the data or the Invantive UniversalSQL driver for Smartsheet does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Smartsheet API. ## Table Columns The columns of the table `SheetDiscussions` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `comment_count` | `int32` | | ☐ | The number of comments. | | `created_by_email` | `varchar2` | | ☐ | The e-mail address of who started the discussion. | | `discussion_id` | `int64` | | ☑ | The id of the discussion. | | `last_commented_at` | `datetime` | | ☐ | When the latest comment was made, UTC. | | `last_commented_by_email` | `varchar2` | | ☐ | The e-mail address of who made the latest comment. | | `parent_id` | `int64` | | ☐ | The sheet or row the discussion is on. | | `parent_type` | `varchar2` | | ☐ | What the discussion is on: SHEET or ROW. | | `read_only` | `char` | | ☐ | Whether the user can no longer reply. | | `sheet_id` | `int64` | | ☑ | The sheet of the discussion. | | `title` | `varchar2` | | ☐ | The title: the text of the first comment. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `sheet_id` | [[Sheets-Sheets\|Sheets.Sheets]] | `sheet_id` | Declared by the connector, not enforced by the platform | | `sheet_id`, `parent_id` | [[Sheets-SheetRows\|Sheets.SheetRows]] | `sheet_id`, `row_id` | In words only: A row only when parent_type is ROW; otherwise the sheet itself. | ## Referenced By The columns of these tables refer to a row of this table. | Table | Columns | Guarantee | |---|---|---| | [[Sheets-SheetComments\|Sheets.SheetComments]] | `discussion_id` | Declared by the connector, not enforced by the platform |