Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
ticket_id 🔑 ➤ TICKET�name 🔑
_fivetran_start 🔑�timestamp
source
source_id�value
_fivetran_end
_fivetran_active
TICKET_PROPERTY_HISTORY ⇱
id 🔑
object_type
portal_id
is_deleted
property_*
TICKET ⇱
ticket_id 🔑 ➤ TICKET
contact_id 🔑 ➤ CONTACT
TICKET_CONTACT ⇱
ticket_id 🔑 ➤ TICKET
deal_id 🔑 ➤ DEAL
TICKET_DEAL ⇱
ticket_id 🔑 ➤ TICKET
comapny_id 🔑 ➤ COMPANY
TICKET_COMPANY ⇱
ticket_id 🔑 ➤ TICKET
engagement_id 🔑 ➤ ENGAGEMENT
TICKET_ENGAGEMENT ⇱
id 🔑
property_email
property_*
CONTACT ⇱
id 🔑�is_deleted�portal_id
deal_pipeline_id ➤ DEAL_PIPELINE
deal_pipeline_stage_id ➤ DEAL_PIPELINE_STAGE
owner_id ➤ OWNER�property_*
DEAL ⇱
id 🔑�is_deleted�portal_id
property_*
COMPANY ⇱
id 🔑�portal_id
active
owner_id
Type
activityType
created_at
last_updated
timestamp
ENGAGEMENT ⇱
For extended ERD check the HubSpot Sales/CRM Schema
stage_id 🔑
pipeline_id ➤ TICKET_PIPELINE
active
created_at
display_order
is_closed
label
ticket_state
updated_at
TICKET_PIPELINE_STAGE ⇱
pipeline_id 🔑
active
created_at
display_order
label
object_type_id
updated_at
TICKET_PIPELINE ⇱