Legend
🔑 = primary key
➤ = key relation
code 🔑
active_flag
decimal_points
is_custom_flag
name
symbol
CURRENCY ⇱
organization_id 🔑
owner_id ➤ USER
active_flag
address_*
cc_email
created_at
label
name
update_time
visible_to
custom_*
ORGANIZATION
deal_id 🔑
created_user_id ➤ USER
currency ➤ CURRENCY
org_id ➤ ORGANIZATION
person_id ➤ PERSON
pipeline_id ➤ PIPELINE
stage_id ➤ STAGE
active_flag
cc_email
close_time
created_at
updated_at
deleted
expected_close_date
formatted_value
formatted_weighted_value
label
lost_reason
lost_time
org_hidden
person_hidden
probability
stage_change_time
stage_order_nr
status
title
value
visible_to
weighted_value
weighted_value_currency
won_time
custom_*
DEAL
user_id 🔑
default_currency ➤ CURRENCY
role_id ➤ ROLE
active_flag
created_at
has_created_company
icon_url
is_admin
last_login_at
locale
modified_at
name
phone
timezone_name
timezone_offset
USER
person_id 🔑
organization_id ➤ ORGANIZATION
owner_id ➤ USER
active_flag
cc_email
company_id
created_at
primary_email
name
picture_id
primary_phone
update_time
visible_to
custom_*
PERSON
activity_id 🔑
created_at
updated_at
updated_by
activity_type
duration
subject
company_id
user_id ➤ USER
conference_meeting_client
conference_meeting_url
conference_meeting_id
due_at
is_busy
done_at
public_description
location
organization_id ➤ ORGANIZATION
person_id ➤ PERSON
deal_id ➤ DEAL
is_active
source_timezone
lead_id ➤ LEAD
project_id
location_*
ACTIVITY
pipeline_id 🔑
active_flag
created_at
updated_at
deal_probability_flag
name
order_nr
selected
url_title
PIPELINE
stage_id 🔑
pipeline_id ➤ PIPELINE
active_flag
created_at
updated_at
deal_probability
name
order_nr
rotten_days
rotten_flag
STAGE
activity_id 🔑 ➤ ACTIVITY
person_id 🔑 ➤ PERSON
primary_flag
ACTIVITY_PARTICIPANT
id 🔑
activity_id ➤ ACTIVITY
deal_id ➤ DEAL_HISTORY
mail_message_id ➤ MAIL_MESSAGE
product_id ➤ PRODUCT
active_flag
created_at
description
file_name
file_size
inline_flag
log_id
name
remote_id
remote_location
s3_bucket
update_time
url
FILE ⇱
id 🔑
deal_id ➤ DEAL_HISTORY
last_updated_user_id ➤ USER
person_id ➤ PERSON
user_id ➤ USER
active_flag
content
created_at
pinned_to_deals_flag
pinned_to_organization_flag
update_time
NOTE ⇱
id 🔑
active_flag
name
parent_role_id
ROLE ⇱
id 🔑
owner_id ➤ USER
active_flag
category
code
created_at
description
name
prices
selectable
tax
unit
update_time
custom_*
PRODUCT ⇱
product_id 🔑 ➤ PRODUCT
deal_id 🔑 ➤ DEAL_HISTORY
PRODUCT_DEAL ⇱
id 🔑
updated_time 🔑
product_id ➤ PRODUCT
currency ➤ CURRENCY.code
cost
overhead_cost
price
PRODUCT_PRICE_HISTORY
mail_message_id 🔑
mail_thread_id ➤ MAIL_THREAD
user_id ➤ USER
body_url
created_at
is_deleted
is_draft
from_email_address
from_linked_person_id
has_attachments
has_body
has_inline_attachments
has_real_attachments
has_mail_link_tracking_enabled
mail_tracking_status
message_time
is_read
is_sent
is_sent_from_pipedrive
has_smart_bcc
snippet
subject
is_synced
updated_at
MAIL_MESSAGE ⇱
mail_thread_id 🔑
deal_id ➤ DEAL
MAIL_THREAD ⇱
recipient_id 🔑
mail_message_id 🔑 ➤ MAIL_MESSAGE
linked_person_id 🔑 ➤ PERSON
email_address
EMAIL_TO
recipient_id 🔑
mail_message_id 🔑 ➤ MAIL_MESSAGE
linked_person_id 🔑 ➤ PERSON
email_address
EMAIL_BCC
recipient_id 🔑
mail_message_id 🔑 ➤ MAIL_MESSAGE
linked_person_id 🔑 ➤ PERSON
email_address
EMAIL_CC
id 🔑
activity_type ➤ ACTIVITY
active_flag
color
created_at
icon_key
is_custom_flag
name
update_time
ACTIVITY_TYPE ⇱
person_id 🔑 ➤ PERSON
email 🔑
label
primary
PERSON_EMAIL
person_id 🔑 ➤ PERSON
phone 🔑
label
primary
PERSON_PHONE
deal_id 🔑 ➤ DEAL
date_entered 🔑
stage_id 🔑 ➤ STAGE
DEAL STAGE HISTORY
Planned
Released
lead_id 🔑
created_at
updated_at
title
owner_id ➤ USER
creator_id ➤ USER
person_id ➤ PERSON
organization_id ➤ ORGANIZATION
source_name
is_archived
was_seen
value_amount
value_currency
next_activity_id
visible_to
cc_email
LEAD
team_id 🔑
created_at
created_by ➤ USER
description
is_active
is_deleted
manager_id ➤ USER
name
TEAM
team_id 🔑 ➤ TEAM
user_id 🔑 ➤ USER
TEAM USER ASSOCIATION