Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
code 🔑
active_flag
decimal_points
is_custom_flag
name
symbol
CURRENCY ⇱
id 🔑
owner_id ➤ USER
active_flag
address_*
cc_email
created_at
label
name
update_time
visible_to
custom_*
ORGANIZATION ⇱
id 🔑
update_time 🔑
created_user_id ➤ USER
currency ➤ CURRENCY.code
org_id ➤ ORGANIZATION
person_id ➤ PERSON
pipeline_id ➤ PIPELINE
stage_id ➤ STAGE
active_flag
cc_email
close_time
created_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_HISTORY ⇱
id 🔑
default_currency ➤ CURRENCY.code
role_id ➤ ROLE
activated
active_flag
created_at
has_created_company
icon_url
is_admin
last_login
locale
modified_time
name
phone
timezone_name
timezone_offset
USER ⇱
id 🔑
org_id ➤ ORGANIZATION
owner_id ➤ USER
active_flag
cc_email
company_id
created_at
name
picture_is
phone
update_time
visible_to
custom_*
PERSON ⇱
id 🔑
assigned_to_user_id ➤ USER
created_by_user_id ➤ USER
deal_id ➤ DEAL_HISTORY
last_notification_user_id ➤ USER
update_user_id ➤ USER
user_id ➤ USER
active_flag
created_at
attendees
busy_flag
company_id
deal_dropbox_bcc
done
due_date
due_time
duration
last_notification_time
marked_as_done_time
note
person_dropbox_bcc
public_description
reference_id
reference_type
source_timezone
subject
type
update_time
location_*
custom_*
ACTIVITY ⇱
id 🔑
active_flag
created_at
deal_probability
name
order_nr
selected
update_time
url_title
PIPELINES ⇱
id 🔑
pipeline_id ➤ PIPELINE
active_flag
created_at
deal_probability
name
order_nr
rotten_days
rotten_flag
update_time
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
id 🔑
mail_thread_id ➤ MAIL_THREAD
user_id ➤ USER
body_url
created_at
deleted_flag
draft_flag
from_email_address
from_linked_person_id
has_attachments_flag
has_body_flag
has_inline_attachments_flag
has_real_attachments_flag
mail_link_tracking_enabled_flag
mail_tracking_status
message_time
read_flag
sent_flag
sent_from_pipedrive_flag
smart_bcc_flag
snippet
subject
synced_flag
update_time
write_flag
MAIL_MESSAGE ⇱
id 🔑
deal_id ➤ DEAL_HISTORY
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