> ## Documentation Index > Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt > Use this file to discover all available pages before exploring further. # ticket_type table > A ticket (request) type ## ticket\_type Table (552) A ticket (request) type ## Fields | Name | Description | Type | Nullable | | ----------------------------- | ----------------------------------------------------------------------------------------- | -------------------------------------------- | :------: | | ticket\_type\_id | Primary key | PK | No | | name | The list item | String(4000) | No | | rank | Rank order | UShort | Yes | | tooltip | Tooltip or other description | String(4000) | Yes | | icon | Name of the icon | String(32) | No | | default\_status | Default ticket status for new tickets | FK [ticket\_status](./ticket-status.mdx) | Yes | | default\_priority | Default ticket priority for new tickets | FK [ticket\_priority](./ticket-priority.mdx) | Yes | | reply\_template | Reply template to use when replying to a ticket of this type | FK [reply\_template](./reply-template.mdx) | Yes | | is\_external | Is this request type visible to external people and they can submit requests of this type | Bool | Yes | | registered | Registered when | UtcDateTime | No | | registered\_associate\_id | Registered by whom | FK [associate](./associate.mdx) | No | | updated | Last updated when | UtcDateTime | No | | updated\_associate\_id | Last updated by whom | FK [associate](./associate.mdx) | No | | updatedCount | Number of updates made to this record | UShort | No | | is\_default | Is this Ticket Type marked as default | Bool | Yes | | show\_in\_new | Enables this request type to be accessible in +New in top bar | Bool | No | | exclude\_signature | Do not insert user signature automatically | Bool | No | | exclude\_email\_recipients | Create request without initially having to send outbound e-mail | Bool | No | | external\_as\_default | Ability to set external access level for this request type | Bool | No | | visible\_for\_groups | Array of references to the visible for groups | FKArray | Yes | | reply\_forward\_no\_signature | Do not insert user signature when replying or forwarding the message | Bool | No | | reply\_external\_as\_default | Set external access level when replying the message | Bool | No | ticket_type table relationship diagram ## Indexes | Fields | Types | Description | | -------------------- | ------------ | ----------- | | name | String(4000) | Unique | | default\_status | FK | Index | | default\_priority | FK | Index | | reply\_template | FK | Index | | visible\_for\_groups | FKArray | Full text | ## Relationships | Table | Description | | -------------------------------------------------------------- | ------------------------------------------------------------------------------------------------------------------------ | | [associate](./associate) | Employees, resources and other users - except for External persons | | [mail\_in\_filter](./mail-in-filter) | This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP). | | [ms\_filter](./ms-filter) | This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails. | | [reply\_template](./reply-template) | Templates for automatic and manual replies to emails/sms organized hierachically | | [ticket](./ticket) | This table contains the tickets (requests) of the system. Its purpose should be evident. | | [ticket\_priority](./ticket-priority) | This table contains the ticket priorities. | | [ticket\_rel\_def\_ticket\_type](./ticket-rel-def-ticket-type) | Link table defining what Ticket types are involved in this relation. Will have M:N rows for a single relation definition | | [ticket\_status](./ticket-status) | This table user defined ticket status values. | | [ticket\_type\_priority](./ticket-type-priority) | Link table defining what Priorities are relevant to a particular Ticket type | | [ticket\_type\_status](./ticket-type-status) | Link table defining what Statuses are relevant to a particular Ticket type | | [UserGroup](./usergroup) | Secondary user groups | ## Replication Flags * None ## Security Flags * No access control via user's Role. ## Related topics - [ticket_rel_def_ticket_type table](/en/database/tables/ticket-rel-def-ticket-type.md) - [ticket_type_priority table](/en/database/tables/ticket-type-priority.md) - [ticket_type_status table](/en/database/tables/ticket-type-status.md) - [Ticket table](/en/api/bulk-operations/bulk-update/reference/ticket-table.md) - [ticket_status table](/en/database/tables/ticket-status.md) - [Post Ticket Type Entity](/en/api/reference/restful/rest/tickettype/post-ticket-type-entity.md)