Fivetran documentation

Search the docs

/

Bigin by Zoho CRM

Explore the interactive ERD

Table & Field Reference

call_tag

Column	Type	Keys
`id`	Unknown	PK
`call_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

call

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`agenda`	Unknown
`calendar_booking_call`	Unknown
`caller_id`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`dialled_number`	Unknown
`duration`	Unknown
`duration_in_seconds`	Unknown
`editable`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`modified_time`	Instant
`reminder`	Unknown
`se_module`	Unknown
`sharing_permission`	Unknown
`start_time`	Unknown
`status`	Unknown
`subject`	Unknown
`telephony_call`	Unknown
`type`	Unknown
`what_id`	Unknown
`what_id_name`	Unknown
`who_id`	Unknown
`who_id_name`	Unknown
`zia_visions`	Unknown

contact_tag

Column	Type	Keys
`id`	Unknown	PK
`contact_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`approval_state`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`date_of_birth`	Unknown
`department`	Unknown
`description`	Unknown
`editable`	Unknown
`email`	Unknown
`email_opt_out`	Unknown
`field_states`	Unknown
`first_name`	Unknown
`followed`	Unknown
`followers`	Unknown
`full_name`	Unknown
`home_phone`	Unknown
`last_activity_time`	Unknown
`last_name`	Unknown
`locked_for_me`	Unknown
`mailing_city`	Unknown
`mailing_country`	Unknown
`mailing_state`	Unknown
`mailing_street`	Unknown
`mailing_zip`	Unknown
`mobile`	Unknown
`modified_time`	Instant
`phone`	Unknown
`record_image`	Unknown
`reporting_to_id`	Unknown
`reporting_to_name`	Unknown
`role`	Unknown
`sharing_permission`	Unknown
`title`	Unknown
`unsubscribed_mode`	Unknown
`unsubscribed_time`	Unknown
`zia_owner_assignment`	Unknown
`zia_visions`	Unknown

task_tag

Column	Type	Keys
`id`	Unknown	PK
`task_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`related_to_id`	Unknown	FK
`approval_state`	Unknown
`closed_time`	Unknown
`contact`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`due_date`	Unknown
`editable`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`locked_for_me`	Unknown
`modified_time`	Instant
`priority`	Unknown
`recurring_activity`	Unknown
`related_module`	Unknown
`remind_at`	Unknown
`sharing_permission`	Unknown
`status`	Unknown
`subject`	Unknown
`u_id`	Unknown
`zia_owner_assignment`	Unknown
`zia_visions`	Unknown

event_tag

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

event_participant

Column	Type	Keys
`id`	Unknown	PK
`event_id`	Unknown	PKFK
`email`	Unknown
`invited`	Unknown
`name`	Unknown
`number`	Unknown
`status`	Unknown
`type`	Unknown

event

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`related_to_id`	Unknown	FK
`all_day`	Unknown
`approval_state`	Unknown
`calendar_booking_event`	Unknown
`cancelled`	Unknown
`check_in_time`	Unknown
`colour_code`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`editable`	Unknown
`end_date_time`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`meeting_details`	Unknown
`modified_time`	Instant
`recurrence_id`	Unknown
`recurring_activity`	Unknown
`related_module`	Unknown
`remind_at`	Unknown
`send_notification`	Unknown
`sharing_permission`	Unknown
`start_date_time`	Unknown
`title`	Unknown
`u_id`	Unknown
`venue`	Unknown
`zia_visions`	Unknown

account_tag

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

account_partner_type

Column	Type	Keys
`index`	Unknown	PK
`account_id`	Unknown	PKFK
`type`	Unknown

account

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`annual_revenue`	Unknown
`approval_state`	Unknown
`billing_city`	Unknown
`billing_code`	Unknown
`billing_country`	Unknown
`billing_state`	Unknown
`billing_street`	Unknown
`buyer`	Unknown
`champion`	Unknown
`competitors`	Json
`created_time`	Unknown
`crm`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`editable`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`last_activity_time`	Unknown
`live_date`	Unknown
`locked_for_me`	Unknown
`modified_time`	Instant
`name`	Unknown
`onboarding_lead`	Unknown
`ownership`	Unknown
`parent_account`	Unknown
`phone`	Unknown
`property_count`	Unknown
`record_image`	Unknown
`sharing_permission`	Unknown
`stage`	Unknown
`type`	Unknown
`unit_count`	Unknown
`website`	Unknown
`zia_owner_assignment`	Unknown
`zia_visions`	Unknown

product_tag

Column	Type	Keys
`id`	Unknown	PK
`product_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`approval_state`	Unknown
`category`	Unknown
`code`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`description`	Unknown
`editable`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`is_active`	Unknown
`locked_for_me`	Unknown
`modified_time`	Instant
`name`	Unknown
`record_image`	Unknown
`sharing_permission`	Unknown
`taxable`	Unknown
`unit_price`	Unknown
`zia_visions`	Unknown

pipeline_tag

Column	Type	Keys
`id`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`color_code`	Unknown
`name`	Unknown

pipeline_market

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`market`	Unknown

pipeline_partner_type

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`type`	Unknown

pipeline_property_management_system

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`management_system`	Unknown

pipeline_prospect_pain_point

Column	Type	Keys
`index`	Unknown	PK
`pipeline_id`	Unknown	PKFK
`pain_point`	Unknown

pipeline

Column	Type	Keys
`id`	Unknown	PK
`account_id`	Unknown	FK
`contact_id`	Unknown	FK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`owner_id`	Unknown	FK
`approval_state`	Unknown
`closing_date`	Unknown
`created_time`	Unknown
`currency_symbol`	Unknown
`deal_name`	Unknown
`description`	Unknown
`editable`	Unknown
`field_states`	Unknown
`followed`	Unknown
`followers`	Unknown
`last_activity_time`	Unknown
`lead_source`	Unknown
`locked_for_me`	Unknown
`modified_time`	Instant
`name`	Unknown
`next_step`	Unknown
`onboarding_poc`	Unknown
`opportunity_type`	Unknown
`partner_success_manager`	Unknown
`pipeline_number`	Unknown
`priority`	Unknown
`probability`	Unknown
`property_count`	Unknown
`segment`	Unknown
`sharing_permission`	Unknown
`stage`	Unknown
`sub_pipeline`	Unknown
`total_arr_opportunity`	Unknown
`total_revenue_opportunity`	Unknown
`total_unit_count`	Unknown
`unit_count`	Unknown
`zia_owner_assignment`	Unknown
`zia_visions`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`created_by_id`	Unknown	FK
`modified_by_id`	Unknown	FK
`profile_id`	Unknown	FK
`alias`	Unknown
`category`	Unknown
`city`	Unknown
`confirm`	Unknown
`country`	Unknown
`country_locale`	Unknown
`created_time`	Unknown
`current_shift`	Unknown
`date_format`	Unknown
`decimal_separator`	Unknown
`default_tab_group`	Unknown
`dob`	Unknown
`email`	Unknown
`fax`	Unknown
`first_name`	Unknown
`full_name`	Unknown
`is_on_line`	Unknown
`languages`	Unknown
`last_name`	Unknown
`locale`	Unknown
`microsoft`	Unknown
`mobile`	Unknown
`modified_time`	Unknown
`name_format`	Unknown
`next_shift`	Unknown
`normal_tab_background`	Unknown
`normal_tab_font_color`	Unknown
`number_separator`	Unknown
`offsets`	Unknown
`personal_account`	Unknown
`phone`	Unknown
`role_id`	Unknown
`role_name`	Unknown
`sandbox_developer`	Unknown
`selected_tab_background`	Unknown
`selected_tab_font_color`	Unknown
`shift_effective_from`	Unknown
`signature`	Unknown
`sort_order_preference`	Unknown
`state`	Unknown
`status`	Unknown
`status_reason_s`	Unknown
`street`	Unknown
`theme_background`	Unknown
`theme_new_background`	Unknown
`theme_screen`	Unknown
`theme_type`	Unknown
`time_format`	Unknown
`time_zone`	Unknown
`website`	Unknown
`zip`	Unknown
`zuid`	Unknown
`custom_fields_`