ticket_type Table (552)
A ticket (request) typeFields
| 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 | Yes |
| default_priority | Default ticket priority for new tickets | FK ticket_priority | Yes |
| reply_template | Reply template to use when replying to a ticket of this type | FK reply_template | 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 | No |
| updated | Last updated when | UtcDateTime | No |
| updated_associate_id | Last updated by whom | FK associate | 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 |
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 | Employees, resources and other users - except for External persons |
| mail_in_filter | This table contains entries for the mailboxes the eJournal system is fetching mail from (POP3 or IMAP). |
| ms_filter | This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails. |
| reply_template | Templates for automatic and manual replies to emails/sms organized hierachically |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_priority | This table contains the ticket priorities. |
| 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 | This table user defined ticket status values. |
| ticket_type_priority | Link table defining what Priorities are relevant to a particular Ticket type |
| ticket_type_status | Link table defining what Statuses are relevant to a particular Ticket type |
| UserGroup | Secondary user groups |
Replication Flags
- None
Security Flags
- No access control via user’s Role.