# Bigin by Zoho CRM schema ERD

Table and field reference for the Fivetran Bigin by Zoho CRM connector.

## Table & Field Reference

### call_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| call_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| color_code | Unknown |  |
| name | Unknown |  |

### event_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | PK, FK |
| 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 | PK, FK |
| color_code | Unknown |  |
| name | Unknown |  |

### account_partner_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| color_code | Unknown |  |
| name | Unknown |  |

### pipeline_market

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| market | Unknown |  |

### pipeline_partner_type

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| type | Unknown |  |

### pipeline_property_management_system

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| management_system | Unknown |  |

### pipeline_prospect_pain_point

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| pipeline_id | Unknown | PK, FK |
| 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_** |  |  |

## Relationships

- call_tag(call_id) → call(id)
- call(modified_by_id) → users(id)
- call(owner_id) → users(id)
- call(created_by_id) → users(id)
- contact_tag(contact_id) → contact(id)
- contact(modified_by_id) → users(id)
- contact(owner_id) → users(id)
- contact(created_by_id) → users(id)
- contact(account_id) → account(id)
- task_tag(task_id) → task(id)
- task(modified_by_id) → users(id)
- task(owner_id) → users(id)
- task(created_by_id) → users(id)
- task(related_to_id) → account(id)
- event_tag(event_id) → event(id)
- event_participant(event_id) → event(id)
- event(modified_by_id) → users(id)
- event(owner_id) → users(id)
- event(created_by_id) → users(id)
- event(related_to_id) → account(id)
- account_tag(account_id) → account(id)
- account_partner_type(account_id) → account(id)
- account(modified_by_id) → users(id)
- account(owner_id) → users(id)
- account(created_by_id) → users(id)
- product_tag(product_id) → product(id)
- product(modified_by_id) → users(id)
- product(owner_id) → users(id)
- product(created_by_id) → users(id)
- pipeline_tag(pipeline_id) → pipeline(id)
- pipeline_market(pipeline_id) → pipeline(id)
- pipeline_partner_type(pipeline_id) → pipeline(id)
- pipeline_property_management_system(pipeline_id) → pipeline(id)
- pipeline_prospect_pain_point(pipeline_id) → pipeline(id)
- pipeline(modified_by_id) → users(id)
- pipeline(owner_id) → users(id)
- pipeline(created_by_id) → users(id)
- pipeline(account_id) → account(id)
- pipeline(contact_id) → contact(id)
- users(modified_by_id) → users(id)
- users(created_by_id) → users(id)
- users(profile_id) → users(id)