Description:
Stores comments made on issues. Each comment is tied to a specific issue and includes metadata about creation, state, and author.
🔑 Primary Key
id
| Field Name | Data Type | Description |
|---|---|---|
id |
NUMBER | Unique identifier for the issue comment. |
created_at |
TIMESTAMP_TZ | Timestamp when the comment was created. |
state |
NUMBER | State of the comment (reuses the issue state enum): 0 => CREATED, 1 => CLOSED, 2 => WAITING, 3 => IN_REPAIR. |
state_name |
TEXT | String label for state. |
text |
TEXT | Content of the comment. |
created_by |
NUMBER | Identifier of the user who created the comment. |
issue_id |
NUMBER | Identifier of the issue the comment belongs to. |
_snowflake_inserted_at |
TIMESTAMP_NTZ | System timestamp when the record was inserted into Snowflake. |
_snowflake_updated_at |
TIMESTAMP_NTZ | System timestamp when the record was last updated in Snowflake. |
_snowflake_deleted |
BOOLEAN | True if the record was deleted in the source. |