# TicketAttachments - Catalog: `Freshdesk` - Schema: `Views` This is a read-only view. The Freshdesk API may not support changing the data or the Invantive UniversalSQL driver for Freshdesk does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Freshdesk API. ## View Columns The columns of the view `TicketAttachments` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `attachments_attachment_url` | `varchar2` | Attachments URL | ☐ | | | `attachments_content_type` | `varchar2` | Attachments Content Type | ☐ | | | `attachments_created_at` | `datetime` | Attachments Created at | ☐ | | | `attachments_id` | `int64` | Attachments ID | ☐ | | | `attachments_name` | `varchar2` | Attachments Name | ☐ | | | `attachments_size` | `int64` | Attachments Size | ☐ | | | `attachments_updated_at` | `datetime` | Attachments Updated at | ☐ | | | `cf_reference_number` | `decimal` | Reference Number | ☐ | Custom field #10000152167 of type custom_number. | | `company_id` | `int64` | Company ID | ☐ | | | `created_at` | `datetime` | Created at | ☐ | Date/time at which the record was created. | | `description_text` | `varchar2` | Description | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `due_by` | `datetime` | Due by | ☐ | | | `email_config_id` | `int64` | Email Configuration ID | ☐ | | | `fr_due_by` | `datetime` | From Due by | ☐ | | | `fr_escalated` | `char` | From Escalated | ☐ | | | `group_id` | `int64` | Group ID | ☐ | | | `id` | `int64` | ID | ☐ | | | `is_escalated` | `char` | Is Escalated | ☐ | | | `priority` | `int64` | Priority | ☐ | | | `product_id` | `int64` | Product ID | ☐ | | | `requester_id` | `int64` | Requester ID | ☐ | | | `responder_id` | `int64` | Responder ID | ☐ | | | `source` | `int64` | Source | ☐ | | | `spam` | `char` | Spam | ☐ | | | `status` | `int64` | Status | ☐ | | | `subject` | `varchar2` | Subject | ☐ | | | `ticket_email` | `varchar2` | Email | ☐ | Email address of the requester. If no contact exists with this email address in Freshdesk, it will be added as a new contact. | | `ticket_name` | `varchar2` | Name | ☐ | Name of the requester. | | `ticket_subject` | `varchar2` | Subject | ☐ | Ticket subject. | | `type` | `varchar2` | Type | ☐ | | | `updated_at` | `datetime` | Updated at | ☐ | Date/time at which the record was last updated. |