Salesloft

Explore the interactive ERD

Table & Field Reference

meeting_attendee

Column	Type	Keys
`index`	Int	PK
`meeting_id`	Long	PKFK
`deleted_at`	Instant
`email`	String
`name`	String
`organizer`	Boolean
`status`	String
`status_changed`	Boolean

task

Column	Type	Keys
`id`	Long	PK
`created_by_user_id`	Long	FK
`person_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`current_state`	String
`description`	String
`due_at`	Instant
`due_date`	LocalDate
`subject`	String
`updated_at`	Instant

cadence_tag

Column	Type	Keys
`index`	Int	PK
`cadence_id`	Long	PKFK
`tag_name`	String

meeting_guest

Column	Type	Keys
`index`	Int	PK
`meeting_id`	Long	PKFK
`guest`	String

action

Column	Type	Keys
`id`	Long	PK
`cadence_id`	Long	FK
`person_id`	Long	FK
`step_id`	Long	FK
`task_id`	Long	FK
`user_id`	Long	FK
`action_details_id`	Long
`created_at`	Instant
`due`	Boolean
`due_on`	Instant
`multitouch_group_id`	Long
`status`	String
`type`	String
`updated_at`	Instant

people_tag

Column	Type	Keys
`index`	Int	PK
`people_id`	Long	PKFK
`tag_name`	String

account_stage

Column	Type	Keys
`id`	Long	PK
`account_stage_order`	Int
`created_at`	Instant
`name`	String
`updated_at`	Instant

crm_user

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`created_at`	Instant
`crm_id`	String
`updated_at`	Instant

calendar_event_attendee

Column	Type	Keys
`index`	Int	PK
`calendar_event_id`	String	PKFK

people_contact_restriction

Column	Type	Keys
`index`	Int	PK
`people_id`	Long	PKFK
`contact_restriction`	String

account_tier

Column	Type	Keys
`id`	Long	PK
`account_tier_order`	Int
`created_at`	Instant
`name`	String
`updated_at`	Instant

email_detail

Column	Type	Keys
`id`	Long	PK
`email_template_id`	Long	FK
`created_at`	Instant
`updated_at`	Instant

call_instruction

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`instructions`	String
`updated_at`	Instant

email

Column	Type	Keys
`id`	Long	PK
`action_id`	Long	FK
`cadence_id`	Long	FK
`crm_activity_id`	Long	FK
`email_template_id`	Long	FK
`recipient_id`	Long	FK
`step_id`	Long	FK
`task_id`	Long	FK
`user_id`	Long	FK
`bounced`	Boolean
`click_tracking`	Boolean
`created_at`	Instant
`error_message`	String
`mailing_id`	Long
`personalization`	String
`recipient_email_address`	String
`send_after`	Instant
`sent_at`	Instant
`status`	String
`subject`	String
`updated_at`	Instant
`view_tracking`	Boolean

call_disposition

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

opportunity

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`creator_id`	Long	FK
`most_recent_cadence_id`	Long	FK
`most_recent_step_account_id`	Long	FK
`most_recent_step_id`	Long	FK
`owner_id`	Long	FK
`account_crm_id`	String
`account_name`	String
`amount`	String
`close_date`	LocalDate
`created_at`	Instant
`created_by_crm_id`	String
`created_date`	Instant
`crm_id`	String
`crm_last_updated_date`	Instant
`crm_type`	String
`crm_url`	String
`currency_iso_code`	String
`is_closed`	Boolean
`is_won`	Boolean
`most_recent_step_number`	Int
`name`	String
`opportunity_type`	String
`opportunity_window_person_id`	Long
`opportunity_window_started_at`	Instant
`owner_crm_id`	String
`owner_crm_name`	String
`probability`	String
`stage_name`	String
`updated_at`	Instant

call

Column	Type	Keys
`id`	Long	PK
`action_id`	Long	FK
`cadence_id`	Long	FK
`called_person_id`	Long	FK
`crm_activity_id`	Long	FK
`note_id`	Long	FK
`step_id`	Long	FK
`task_id`	Long	FK
`user_id`	Long	FK
`call_to`	String
`created_at`	Instant
`disposition`	String
`duration`	Double
`sentiment`	String
`updated_at`	Instant

calendar_event

Column	Type	Keys
`id`	String	PK
`all_day`	String
`body_html`	String
`busy`	Boolean
`calendar_id`	String
`canceled_at`	Instant
`created_at`	Instant
`creator`	String
`description`	String
`end_time`	Instant
`html_link`	String
`i_cal_uid`	String
`location`	String
`organizer`	String
`provider`	String
`recurring`	String
`start_time`	Instant
`status`	String
`tenant_id`	Long
`title`	String
`updated_at`	Instant
`user_guid`	String

meeting_setting

Column	Type	Keys
`id`	Long	PK
`active_meeting_created_at`	Instant
`active_meeting_updated_at`	Instant
`active_meeting_url`	String
`allow_booking_on_behalf`	Boolean
`allow_booking_overtime`	Boolean
`allow_event_overlap`	Boolean
`availability_limit`	Long
`availability_limit_enabled`	Boolean
`buffer_time_duration`	Long
`calendar_type`	String
`created_at`	Instant
`default_meeting_length`	Long
`description`	String
`email_address`	String
`enable_calendar_sync`	Boolean
`enable_dynamic_location`	Boolean
`location`	String
`primary_calendar_connection_failed`	Boolean
`primary_calendar_id`	String
`primary_calendar_name`	String
`schedule_buffer_enabled`	Boolean
`schedule_delay`	Long
`share_event_detail`	Boolean
`time_zone`	String
`title`	String
`updated_at`	Instant
`user_guid`	String
`user_slug`	String

team_template_attachment

Column	Type	Keys
`id`	Long	PK
`team_template_id`	String	FK
`attachment_file_size`	Double
`attachment_id`	Long
`download_url`	String
`name`	String

opportunity_tag

Column	Type	Keys
`index`	Int	PK
`opportunity_id`	Long	PKFK
`tag_name`	String

account_tag

Column	Type	Keys
`index`	Int	PK
`account_id`	Long	PKFK
`tag_name`	String

person_stage

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`person_stage_order`	Int
`updated_at`	Instant

import

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`current_people_count`	Long
`imported_people_count`	Long
`name`	String
`updated_at`	Instant

step

Column	Type	Keys
`id`	Long	PK
`cadence_id`	Long	FK
`created_at`	Instant
`day`	Int
`detail_id`	Long
`disabled`	Boolean
`display_name`	String
`name`	String
`step_number`	String
`type`	String
`updated_at`	Instant

email_template_attachment

Column	Type	Keys
`id`	Long	PK
`email_template_id`	Long	FK
`attachment_file_size`	Double
`attachment_id`	String
`created_at`	Instant
`download_url`	String
`name`	String
`updated_at`	Instant

groups

Column	Type	Keys
`id`	Long	PK
`parent_id`	Long	FK
`name`	String

team_template_tag

Column	Type	Keys
`index`	Int	PK
`team_template_id`	String	PKFK
`tag_name`	String

meeting_setting_times_available

Column	Type	Keys
`day`	String	PK
`meeting_setting_id`	Long	PKFK
`enabled`	Boolean
`end_time`	String
`is_valid`	Boolean
`start_time`	String

transcription_sentence

Column	Type	Keys
`order_number`	Int	PK
`transcription_id`	String	PKFK
`conversation_id`	String	FK
`end_time`	Double
`recording_attendee_id`	String
`start_time`	Double
`text`	String

cadence_membership

Column	Type	Keys
`id`	Long	PK
`cadence_id`	Long	FK
`latest_action_id`	Long	FK
`person_id`	Long	FK
`user_id`	Long	FK
`added_at`	Instant
`created_at`	Instant
`current_state`	String
`currently_on_cadence`	Boolean
`person_deleted`	Boolean
`updated_at`	Instant

team_tag

Column	Type	Keys
`id`	Long	PK
`name`	String

email_template_tag

Column	Type	Keys
`index`	Int	PK
`email_template_id`	Long	PKFK
`tag_name`	String

other_detail

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`instructions`	String
`updated_at`	Instant

success

Column	Type	Keys
`id`	Long	PK
`latest_action_id`	Long	FK
`latest_cadence_id`	Long	FK
`latest_call_id`	Long	FK
`latest_email_id`	Long	FK
`latest_step_id`	Long	FK
`person_id`	Long	FK
`user_id`	Long	FK
`created_at`	Instant
`succeeded_at`	Instant
`success_window_started_at`	Instant
`updated_at`	Instant

team_template

Column	Type	Keys
`id`	String	PK
`attachment_id`	String	FK
`last_modified_user_id`	Long	FK
`archived_at`	Instant
`body`	String
`body_preview`	String
`click_tracking_enabled`	Boolean
`created_at`	Instant
`last_modified_at`	Instant
`last_used_at`	Instant
`open_tracking_enabled`	Boolean
`subject`	String
`title`	String
`updated_at`	Instant

email_template

Column	Type	Keys
`id`	Long	PK
`email_template_attachment_id`	String	FK
`group_id`	Long	FK
`team_template_id`	String	FK
`template_owner_id`	Long	FK
`archived_at`	Instant
`body`	String
`body_preview`	String
`cadence_template`	Boolean
`click_tracking_enabled`	Boolean
`created_at`	Instant
`last_used_at`	Instant
`open_tracking_enabled`	Boolean
`shared`	Boolean
`subject`	String
`title`	String
`updated_at`	Instant

team

Column	Type	Keys
`id`	Long	PK
`allow_automated_email_steps`	Boolean
`call_recording_disabled`	Boolean
`click_tracking_default`	Boolean
`created_at`	Instant
`custom_tracking_domain`	String
`deactivated`	Boolean
`dispositions_required`	Boolean
`email_daily_limit`	Long
`group_privacy_setting`	String
`license_limit`	String
`local_dial_enabled`	Boolean
`name`	String
`plan`	String
`record_by_default`	Boolean
`sentiments_required`	Boolean
`team_visibility_default`	String
`updated_at`	Instant

call_recording

Column	Type	Keys
`index`	Int	PK
`call_id`	Long	PKFK

users

Column	Type	Keys
`id`	Long	PK
`group_id`	Long	FK
`phone_number_assignment_id`	Long	FK
`team_id`	Long	FK
`active`	Boolean
`bcc_email_address`	String
`click_to_call_enabled`	Boolean
`created_at`	Instant
`crm_connected`	Boolean
`email`	String
`email_client_configured`	Boolean
`email_client_email_address`	String
`email_signature`	String
`email_signature_click_tracking_disabled`	Boolean
`email_signature_type`	String
`first_name`	String
`from_address`	String
`full_email_address`	String
`guid`	String
`job_role`	String
`last_name`	String
`local_dial_enabled`	Boolean
`name`	String
`sending_email_address`	String
`slack_username`	String
`team_admin`	Boolean
`time_zone`	String
`twitter_handle`	String
`updated_at`	Instant

people

Column	Type	Keys
`id`	Long	PK
`account_id`	Long	FK
`import_id`	Long	FK
`last_completed_step_cadence_id`	Long	FK
`last_completed_step_id`	Long	FK
`last_contacted_by_id`	Long	FK
`most_recent_cadence_id`	Long	FK
`owner_id`	Long	FK
`person_stage_id`	Long	FK
`bouncing`	Boolean
`city`	String
`country`	String
`created_at`	Instant
`crm_id`	String
`crm_object_type`	String
`crm_url`	String
`display_name`	String
`do_not_contact`	Boolean
`email_address`	String
`eu_resident`	Boolean
`first_name`	String
`full_email_address`	String
`home_phone`	String
`job_seniority`	String
`last_contacted_at`	Instant
`last_contacted_type`	String
`last_name`	String
`last_replied_at`	Instant
`linkedin_url`	String
`locale`	String
`mobile_phone`	String
`owner_crm_id`	String
`person_company_industry`	String
`person_company_name`	String
`person_company_website`	String
`personal_email_address`	String
`personal_website`	String
`phone`	String
`phone_extension`	String
`secondary_email_address`	String
`state`	String
`title`	String
`twitter_handle`	String
`updated_at`	Instant
`work_city`	String
`work_country`	String
`work_state`	String

transcription

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`created_at`	Instant
`language_code`	String
`updated_at`	Instant

cadence

Column	Type	Keys
`id`	Long	PK
`added_stage_id`	Long	FK
`bounced_stage_id`	Long	FK
`cadence_priority_id`	Long	FK
`creator_id`	Long	FK
`finished_stage_id`	Long	FK
`owner_id`	Long	FK
`replied_stage_id`	Long	FK
`archived_at`	Instant
`cadence_framework_id`	Long
`cadence_function`	String
`created_at`	Instant
`draft`	Boolean
`name`	String
`opt_out_link_included`	Boolean
`remove_bounces_enabled`	Boolean
`remove_replies_enabled`	Boolean
`shared`	Boolean
`team_cadence`	Boolean
`updated_at`	Instant

crm_activity_field

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`crm_object_type`	String
`field`	String
`field_type`	String
`salesforce_object_type`	String
`source`	String
`title`	String
`updated_at`	Instant
`value`	String

integration_detail

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`instructions`	String
`integration_id`	Long
`integration_name`	String
`integration_step_type_guid`	String
`integration_step_type_icon`	String
`integration_step_type_label`	String
`updated_at`	Instant

meeting

Column	Type	Keys
`id`	Long	PK
`cadence_id`	Long	FK
`person_id`	Long	FK
`step_id`	Long	FK
`account_id`	String
`all_day`	Boolean
`booked_by_meetings_settings_email_address`	String
`booked_by_user_guid`	String
`calendar_id`	String
`calendar_type`	String
`canceled_at`	Instant
`created_at`	Instant
`crm_reference_what_crm_id`	String
`crm_reference_what_crm_object_label`	String
`crm_reference_what_crm_object_type`	String
`crm_reference_what_crm_url`	String
`crm_reference_what_description_1`	String
`crm_reference_what_description_2`	String
`crm_reference_what_description_3`	String
`crm_reference_who_crm_id`	String
`crm_reference_who_crm_object_label`	String
`crm_reference_who_crm_object_type`	String
`crm_reference_who_crm_url`	String
`crm_reference_who_description_1`	String
`crm_reference_who_description_2`	String
`crm_reference_who_description_3`	String
`description`	String
`end_time`	Instant
`event_id`	String
`event_source`	String
`i_cal_uid`	String
`location`	String
`meeting_type`	String
`no_show`	Boolean
`owned_by_meetings_settings_email_address`	String
`recipient_email`	String
`recipient_name`	String
`start_time`	Instant
`status`	String
`strict_attribution`	Boolean
`task_id`	String
`title`	String
`updated_at`	Instant

call_data_record

Column	Type	Keys
`id`	Long	PK
`call_id`	Long	FK
`called_person_id`	Long	FK
`user_id`	Long	FK
`call_from`	String
`call_to`	String
`call_type`	String
`call_uuid`	String
`created_at`	Instant
`direction`	String
`duration`	Double
`status`	String
`updated_at`	Instant

conversation

Column	Type	Keys
`id`	String	PK
`account_id`	Long	FK
`person_id`	Long	FK
`call_id`	String
`created_at`	Instant
`duration`	Long
`event_end_date`	Instant
`event_start_date`	Instant
`is_api`	Boolean
`language_code`	String
`media_type`	String
`organization_id`	String
`owner_id`	String
`platform`	String
`started_recording_at`	Long
`title`	String
`transcription_id`	String
`updated_at`	Instant
`user_guid`	String

call_sentiment

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`updated_at`	Instant

account

Column	Type	Keys
`id`	Long	PK
`account_tier_id`	Long	FK
`company_stage_id`	Long	FK
`creator_id`	Long	FK
`last_contacted_person_id`	Long	FK
`last_created_by_id`	Long	FK
`owner_id`	Long	FK
`archieved_at`	Instant
`city`	String
`company_type`	String
`conversational_name`	String
`country`	String
`created_at`	Instant
`crm_id`	String
`crm_object_type`	String
`crm_url`	String
`description`	String
`do_not_contact`	Boolean
`domain`	String
`founded_date`	String
`industry`	String
`last_contacted_at`	Instant
`last_contacted_type`	String
`linkedin_url`	String
`locale`	String
`name`	String
`owner_crm_id`	String
`people_count`	String
`phone`	String
`postal_code`	String
`revenue_range`	String
`size`	String
`state`	String
`street`	String
`twitter_handle`	String
`updated_at`	Instant
`website`	String

cadence_priority

Column	Type	Keys
`id`	Long	PK
`created_at`	Instant
`name`	String
`priority`	Int
`updated_at`	Instant

phone_number_assignment

Column	Type	Keys
`id`	Long	PK
`user_id`	Long	FK
`number`	String

note

Column	Type	Keys
`id`	Long	PK
`call_id`	Long	FK
`user_id`	Long	FK
`associated_type`	String
`associated_with_id`	Long
`content`	String
`created_at`	Instant
`updated_at`	Instant

crm_activity

Column	Type	Keys
`id`	Long	PK
`person_id`	Long	FK
`user_id`	Long	FK
`activity_type`	String
`created_at`	Instant
`crm_id`	String
`description`	String
`error`	String
`subject`	String
`updated_at`	Instant