HelpDesk
Explore the interactive ERD
Table & Field Reference
reply_address
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
email_domain_id | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
email | Unknown | |
prefix | Unknown | |
updated_at | Unknown | |
verified | Unknown |
blocked_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
email | Unknown | |
updated_at | Unknown |
view
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
filter | Json | |
name | Unknown | |
ordering | Unknown | |
updated_at | Unknown |
template_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
template_id | Unknown | PKFK |
cid | Unknown | |
name | Unknown | |
size | Unknown | |
type | Unknown |
template
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
content_appearance | Json | |
content_text | Unknown | |
content_type | Unknown | |
created_at | Unknown | |
created_by_type | Unknown | |
name | Unknown | |
type | Unknown | |
updated_at | Unknown |
ticket_custom_field_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
ticket_custom_field_id | Unknown | PKFK |
ticket_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
api_key | Unknown | |
created_at | Unknown | |
created_by_type | Unknown | |
display_name | Unknown | |
role_level | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Unknown |
license
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
default_team_id | Unknown | FK |
default_template_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
detected_languages | Json | |
landing_page | Unknown | |
past_due | Unknown | |
referrer | Unknown | |
source_id | Unknown | |
state | Unknown | |
type | Unknown | |
updated_at | Unknown | |
url | Unknown | |
utm_campaign | Unknown | |
utm_content | Unknown | |
utm_medium | Unknown | |
utm_source | Unknown | |
utm_term | Unknown | |
verified_at | Unknown | |
verified_by | Unknown | |
flags_** | ||
settings_** |
canned_response_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
canned_response_id | Unknown | PKFK |
cid | Unknown | |
name | Unknown | |
size | Unknown | |
type | Unknown |
canned_response
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
team_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
rich_text_obj | Json | |
shortcut | Json | |
text | Unknown | |
updated_at | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
team_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
name | Unknown | |
updated_at | Unknown |
macros_team
| Column | Type | Keys |
|---|---|---|
macros_id | Unknown | PKFK |
team_id | Unknown | PKFK |
macros_action
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
macros_id | Unknown | PKFK |
agent_id | Unknown | FK |
canned_response_id | Unknown | FK |
tag_id | Unknown | FK |
team_id | Unknown | FK |
follower | Unknown | |
is_private | Unknown | |
priority | Unknown | |
random_agent | Unknown | |
round_robin | Unknown | |
spam | Unknown | |
status | Unknown | |
template | Json | |
type | Unknown |
macros
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
description | Unknown | |
name | Unknown | |
updated_at | Unknown |
email_domain_dns_cname
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
email_domain_id | Unknown | PKFK |
host | Unknown | |
value | Unknown |
email_domain_dns_txt
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
email_domain_id | Unknown | PKFK |
host | Unknown | |
value | Unknown |
email_domain
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
inbox_used | Unknown | |
name | Unknown | |
status | Unknown | |
updated_at | Unknown |
mailbox
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
agent_id | Unknown | FK |
created_by | Unknown | FK |
license_id | Unknown | FK |
team_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
description | Unknown | |
inbox_used | Unknown | |
name | Unknown | |
updated_at | Unknown |
agent_role
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_id | Unknown | PKFK |
role | Unknown |
agent_team
| Column | Type | Keys |
|---|---|---|
agent_id | Unknown | PKFK |
team_id | Unknown | PKFK |
agent_attachment
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
agent_id | Unknown | PKFK |
cid | Unknown | |
name | Unknown | |
size | Unknown | |
type | Unknown |
agent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
auto_assignment | Unknown | |
created_at | Unknown | |
created_by_type | Unknown | |
email | Unknown | |
email_notifications_active | Unknown | |
email_verified | Unknown | |
google_analytics_client_id | Unknown | |
google_analytics_session_id | Unknown | |
invert_colors_in_dark_mode | Unknown | |
job_title | Unknown | |
name | Unknown | |
signature_rich_text_obj | Json | |
signature_text | Unknown | |
status | Unknown | |
theme | Unknown | |
time_zone | Unknown | |
updated_at | Unknown | |
web_push_notifications_active | Unknown | |
weekly_reports | Unknown | |
custom_** |
rule_action
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
rule_id | Unknown | PKFK |
agent_id | Unknown | FK |
tag_id | Unknown | FK |
team_id | Unknown | FK |
canned_response_id | Unknown | |
followers | Unknown | |
is_private | Unknown | |
priority | Unknown | |
random_agent | Unknown | |
round_robin | Unknown | |
spam | Unknown | |
status | Unknown | |
template | Json | |
type | Unknown |
rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
active | Unknown | |
created_at | Unknown | |
created_by_type | Unknown | |
description | Unknown | |
limit_per_ticket | Unknown | |
name | Unknown | |
ordering | Unknown | |
quantifiers | Unknown | |
trigger | Json | |
type | Unknown | |
updated_at | Unknown | |
use_counter | Unknown |
subscription
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
license_id | Unknown | FK |
activated_at | Unknown | |
cancelled_at | Unknown | |
created_at | Unknown | |
current_period_ends_at | Unknown | |
current_period_started_at | Unknown | |
expires_at | Unknown | |
plan_code | Unknown | |
quantity | Unknown | |
state | Unknown | |
trial_ends_at | Unknown | |
trial_started_at | Unknown | |
unit_amount_in_cents | Unknown | |
updated_at | Unknown |
trusted_email
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
email | Unknown | |
updated_at | Unknown |
team
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
created_by | Unknown | FK |
license_id | Unknown | FK |
reply_address_id | Unknown | FK |
template_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
integration_external_id | Unknown | |
name | Unknown | |
notify_team_about_assigned_ticket | Unknown | |
notify_team_about_requesters_activity | Unknown | |
reply_name | Unknown | |
tag_reminder | Unknown | |
unauth_reply_creates_new_ticket | Unknown | |
updated_at | Unknown |
ticket_team
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
ticket_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | PKFK |
author_id | Unknown | FK |
author_type | Unknown | |
date | Unknown | |
detailed_source | Unknown | |
message_is_private | Unknown | |
message_text | Unknown | |
rich_text_obj | Unknown | |
source_from | Unknown | |
source_type | Unknown | |
status_new | Unknown | |
status_old | Unknown | |
type | Unknown |
ticket_follower
| Column | Type | Keys |
|---|---|---|
follower_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
ticket_cc
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
ticket_id | Unknown | PKFK |
name | Unknown |
ticket_event_delivery_status
| Column | Type | Keys |
|---|---|---|
entity_id | Unknown | PK |
ticket_event_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
date | Unknown | |
status | Unknown |
ticket_tag
| Column | Type | Keys |
|---|---|---|
tag_id | Unknown | PKFK |
ticket_id | Unknown | PKFK |
child_ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
ticket_id | Unknown | PKFK |
ticket
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignment_agent_id | Unknown | FK |
created_by | Unknown | FK |
license_id | Unknown | FK |
parent_ticket_id | Unknown | FK |
source_mailbox_id | Unknown | FK |
updated_by | Unknown | FK |
created_at | Unknown | |
created_by_type | Unknown | |
detected_language | Unknown | |
integration_reference_id | Unknown | |
integration_reference_type | Unknown | |
integration_reference_url | Unknown | |
integration_type | Unknown | |
integrations | Unknown | |
last_message_at | Unknown | |
priority | Unknown | |
rating_comment | Unknown | |
rating_rate | Unknown | |
rating_request_sent | Unknown | |
rating_requested_at | Unknown | |
requester_email | Unknown | |
requester_name | Unknown | |
silo | Unknown | |
source_detailed_source | Unknown | |
source_external | Unknown | |
source_from | Unknown | |
source_integration_type | Unknown | |
source_reference_id | Unknown | |
source_reference_type | Unknown | |
source_type | Unknown | |
spam_reason | Unknown | |
spam_status | Unknown | |
status | Unknown | |
subject | Unknown | |
updated_at | Unknown |