1 of 1

id 🔑

available

occasional

signature

ticket_scope

created_at

updated_at�available_since

contact_active�contact_email

contact_job_title

contact_language

contact_last_login_at

contact_mobile�contact_name

contact_phone

contact_time_zone

contact_created_at

contact_updated_at

AGENT ⇱

id 🔑

name

note

created_at

updated_at

description

custom_*

COMPANY ⇱

company_id 🔑 ➤ COMPANY

domain 🔑

COMPANY_DOMAIN ⇱

id 🔑

company_id 🔑 ➤ COMPANY

active

address

description

email

job_title

language

mobile

name

phone

time_zone

twitter_id

created_at

updated_at

custom_*

CONTACT ⇱

id 🔑

escalate_to ➤ AGENT

business_hour_id ➤ BUSINESS_HOUR

description

name

unassigned_for

created_at

updated_at

auto_ticket_assign

GROUP ⇱

id 🔑

description

name

default

created_at

updated_at

ROLE ⇱

id 🔑

email_config_id ➤ EMAIL_CONFIG

group_id ➤ GROUP

responder_id ➤ AGENT

company_id ➤ COMPANY

product_id ➤ PRODUCT�association_type

fr_escalated

spam

priority

requester_id

source

status

subject

type

created_at

updated_at

due_by

fr_due_by

is_escalated

description_text

description

stats_resolved_at

stats_first_responded_at

stats_closed_at

custom_*

TICKET ⇱

ticket_id 🔑 ➤ TICKET

email 🔑

TICKET_CC_EMAIL ⇱

ticket_id 🔑 ➤ TICKET

email 🔑

TICKET_FWD_EMAIL ⇱

ticket_id 🔑 ➤ TICKET

email 🔑

TICKET_REPLY_CC_EMAIL ⇱

ticket_id 🔑 ➤ TICKET

email 🔑

TICKET_TO_EMAIL ⇱

id 🔑

contact_id ➤ CONTACT

ticket_id ➤ TICKET

body_text

body

incoming

private

support_email

source

created_at

updated_at

from_email

CONVERSATION ⇱

conversation_id 🔑 ➤ CONVERSATION

email 🔑

CONVERSATION_TO_EMAIL ⇱

conversation_id 🔑 ➤ CONVERSATION

email 🔑

CONVERSATION_CC_EMAIL ⇱

conversation_id 🔑 ➤ CONVERSATION

email 🔑

CONVERSATION_BCC_EMAIL ⇱

conversation_id 🔑 ➤ CONVERSATION

id 🔑

content_type

size

name

attachment_url

created_at

updated_at

CONVERSATION_ATTACHMENT ⇱

id 🔑

name

description

created_at

updated_at

DISCUSSION_CATEGORY ⇱

id 🔑

discussion_category_id ➤ DISCUSSION_CATEGORY

name

description

position

forum_type

forum_visibility

topics_count

posts_count

DISCUSSION_FORUM ⇱

id 🔑

discussion_forum_id ➤ DISCUSSION_FORUM

title

user_id

locked

published

stamp_type

replied_by

posts_count

hits

user_votes�merged_topic_id

sticky

created_at

updated_at

replied_at

DISCUSSION_TOPIC ⇱

id 🔑

discussion_topic_id ➤ DISCUSSION_TOPIC

contact_id ➤ CONTACT

body_text

body

answer

published

spam

trash

created_at

updated_at

DISCUSSION_COMMENT ⇱

id 🔑

title

created_at

updated_at

SURVEY ⇱

id 🔑

survey_id 🔑 ➤ SURVEY

label

accepted_ratings

SURVEY_QUESTION ⇱

id 🔑

survey_id ➤ SURVEY

agent_id ➤ AGENT�group_id ➤ GROUP

ticket_id ➤ TICKET

contact_id ➤ CONTACT

feedback

created_at

updated_at

SATISFACTION_RATING ⇱

survey_question_id 🔑 ➤ SURVEY_QUESTION

satisfaction_rating_id 🔑 ➤ SATISFACTION_RATING

value

SATISFACTION_RATING_VALUE ⇱

id 🔑

agent_id ➤ AGENT

ticket_id ➤ TICKET

company_id ➤ COMPANY

billable

note

timer_running

time_spent

created_at

updated_at

executed_at

start_time

TIME_ENTRIES ⇱

id 🔑

product_id ➤ PRODUCT

group_id ➤ GROUP

name

to_email

reply_email

primary_role

active

created_at

updated_at

EMAIL_CONFIG ⇱

id 🔑

name

description

created_at

updated_at

PRODUCT ⇱

id 🔑

name

description

created_at

updated_at

BUSINESS_HOUR ⇱

agent_id 🔑 ➤ AGENT

group_id 🔑 ➤ GROUP

AGENT_GROUP

agent_id 🔑 ➤ AGENT

role_id 🔑 ➤ ROLE

AGENT_ROLE

ticket_id 🔑 ➤ TICKET

index 🔑

tag

TICKET_TAG ⇱