# Close schema ERD

Table and field reference for the Fivetran Close connector.

## Table & Field Reference

### form_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| form_configuration_id | Unknown |  |
| form_id | Unknown |  |
| form_name | Unknown |  |
| ip_address | Unknown |  |
| organization_id | Unknown |  |
| origin | Unknown |  |
| responses | Json |  |
| source_url | Unknown |  |
| type | Unknown |  |
| users | Json |  |
| values_by_name | Json |  |
| custom_values_** |  |  |

### dialer_user

| Column | Type | Keys |
| --- | --- | --- |
| dialer_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| is_active | Unknown |  |
| state | Unknown |  |

### dialer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| caller_id | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| is_user_dependent | Unknown |  |
| music_preference | Unknown |  |
| organization_id | Unknown |  |
| ring_mode | Unknown |  |
| source_type | Unknown |  |
| source_value | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### shared_association

| Column | Type | Keys |
| --- | --- | --- |
| object_type | Unknown | PK |
| shared_custom_field_id | Unknown | FK |
| custom_activity_type_id | Unknown |  |
| editable_with_roles | Json |  |
| required | Unknown |  |

### shared_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| choices | Json |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### bulk_delete

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| n_leads | Unknown |  |
| n_leads_processed | Unknown |  |
| organization_id | Unknown |  |
| query | Unknown |  |
| send_done_email | Unknown |  |
| status | Unknown |  |

### contact_email

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| contact_id | Unknown | PK, FK |
| type | Unknown |  |

### contact_phone

| Column | Type | Keys |
| --- | --- | --- |
| phone | Unknown | PK |
| contact_id | Unknown | PK, FK |
| country | Unknown |  |
| phone_formatted | Unknown |  |
| type | Unknown |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| display_name | Unknown |  |
| integration_links | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| title | Unknown |  |

### lead_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| label | Unknown |  |
| organization_id | Unknown |  |

### note_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| attachment | Json |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| note | Unknown |  |
| note_mention | Json |  |
| organization_id | Unknown |  |
| pinned_at | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |

### opportunity_status_change_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| new_status_id | Unknown | FK |
| old_status_id | Unknown | FK |
| opportunity_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| contact_id | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| lead_id | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| status_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| annualized_expected_value | Unknown |  |
| annualized_value | Unknown |  |
| confidence | Unknown |  |
| date_created | Unknown |  |
| date_lost | Unknown |  |
| date_updated | Instant |  |
| date_won | Unknown |  |
| expected_value | Unknown |  |
| integration_links | Json |  |
| note | Unknown |  |
| organization_id | Unknown |  |
| status_display_name | Unknown |  |
| value | Unknown |  |
| value_currency | Unknown |  |
| value_formatted | Unknown |  |
| value_period | Unknown |  |

### bulk_edit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| lead_status_id | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| n_leads | Unknown |  |
| n_leads_processed | Unknown |  |
| organization_id | Unknown |  |
| query | Unknown |  |
| send_done_email | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |

### custom_activity_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_activity_id | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| back_reference_is_visible | Unknown |  |
| converting_to_type | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| is_shared | Unknown |  |
| name | Unknown |  |
| referenced_custom_type_id | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |

### custom_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| api_create_only | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| email | Unknown |  |
| email_verification_token_generated_at | Unknown |  |
| email_verified_at | Unknown |  |
| first_name | Unknown |  |
| image | Unknown |  |
| last_name | Unknown |  |
| last_used_timezone | Unknown |  |
| organizations | Json |  |

### sequence_step

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| email_template_id | Unknown | FK |
| sequence_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| delay | Unknown |  |
| required | Unknown |  |
| step_allowed_delay | Unknown |  |
| step_type | Unknown |  |
| threading | Unknown |  |

### sequence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| schedule_id | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |

### opportunity_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| pipeline_id | Unknown | FK |
| label | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### task_email

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| task_id | Unknown | PK, FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_to | Unknown | FK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| date | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| is_complete | Unknown |  |
| object_id | Unknown |  |
| object_type | Unknown |  |
| opportunity_note | Unknown |  |
| opportunity_value | Unknown |  |
| opportunity_value_formatted | Unknown |  |
| opportunity_value_period | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |
| view | Unknown |  |

### custom_activity_instance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| custom_activity_type_id | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| organization_id | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| user_name | Unknown |  |
| users | Json |  |

### phone_number

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| forward_to | Unknown |  |
| forward_to_enabled | Unknown |  |
| forward_to_formatted | Unknown |  |
| is_group_number | Unknown |  |
| label | Unknown |  |
| number | Unknown |  |
| number_formatted | Unknown |  |
| organization_id | Unknown |  |
| participants | Json |  |
| phone_numbers | Json |  |
| phone_numbers_formatted | Json |  |
| sms_enabled | Unknown |  |
| supports_sms_to_countries | Json |  |
| type | Unknown |  |
| voicemail_greeting_url | Unknown |  |

### opportunity_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| choices | Json |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### email_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| attachments | Json |  |
| body | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| is_archived | Unknown |  |
| is_shared | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| subject | Unknown |  |

### task_completed_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| task_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| organization_id | Unknown |  |
| task_text | Unknown |  |
| type | Unknown |  |

### activity_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| choices | Json |  |
| custom_activity_type_id | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| referenced_custom_type_id | Unknown |  |
| type | Unknown |  |

### integration_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### contact_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| choices | Json |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| editable | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| permission | Json |  |

### whatsapp_message_activity_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| whatsapp_message_activity_id | Unknown | PK, FK |
| content_type | Unknown |  |
| filename | Unknown |  |
| size | Unknown |  |
| thumbnail_url | Unknown |  |
| url | Unknown |  |

### whatsapp_message_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| external_whatsapp_message_id | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| attachments | Json |  |
| created_by_name | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| direction | Unknown |  |
| integration_link | Unknown |  |
| integration_name | Unknown |  |
| local_phone | Unknown |  |
| local_phone_formatted | Unknown |  |
| message_html | Unknown |  |
| message_markdown | Unknown |  |
| organization_id | Unknown |  |
| remote_phone | Unknown |  |
| remote_phone_formatted | Unknown |  |
| response_to_id | Unknown |  |
| sequence_id | Unknown |  |
| sequence_name | Unknown |  |
| sequence_subscription_id | Unknown |  |
| source | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |
| updated_by_name | Unknown |  |

### email_activity_attachment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_activity_id | Unknown | FK |
| content_type | Unknown |  |
| filename | Unknown |  |
| size | Unknown |  |
| url | Unknown |  |

### email_activity_to

| Column | Type | Keys |
| --- | --- | --- |
| receiver | Unknown | PK |
| email_activity_id | Unknown | PK, FK |

### email_body_text

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_activity_id | Unknown | FK |
| expand | Unknown |  |
| text | Unknown |  |

### email_envelope_sender

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| email_activity_id | Unknown | PK, FK |
| name | Unknown |  |

### email_envelope_to

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| email_activity_id | Unknown | PK, FK |
| name | Unknown |  |

### email_envelope_from

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| email_activity_id | Unknown | PK, FK |
| name | Unknown |  |

### email_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| followup_sequence_id | Unknown | FK |
| lead_id | Unknown | FK |
| sequence_id | Unknown | FK |
| sequence_subscription_id | Unknown | FK |
| template_id | Unknown | FK |
| thread_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| attachments | Json |  |
| bcc | Json |  |
| bulk_email_action_id | Unknown |  |
| cc | Json |  |
| date_created | Unknown |  |
| date_scheduled | Unknown |  |
| date_sent | Unknown |  |
| date_updated | Unknown |  |
| direction | Unknown |  |
| email_account_id | Unknown |  |
| envelope_bcc | Json |  |
| envelope_cc | Json |  |
| envelope_date | Unknown |  |
| envelope_in_reply_to | Unknown |  |
| envelope_is_autoreply | Unknown |  |
| envelope_message_id | Unknown |  |
| envelope_subject | Unknown |  |
| followup_sequence_delay | Unknown |  |
| has_reply | Unknown |  |
| in_reply_to_id | Unknown |  |
| message_ids | Json |  |
| need_smtp_credentials | Unknown |  |
| opens | Json |  |
| opens_summary | Unknown |  |
| organization_id | Unknown |  |
| reference | Json |  |
| send_as_id | Unknown |  |
| send_attempts | Json |  |
| sender | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |
| users | Json |  |

### lead_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accepts_multiple_values | Unknown |  |
| back_reference_is_visible | Unknown |  |
| choices | Json |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| editable_with_roles | Json |  |
| is_shared | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| referenced_custom_type_id | Unknown |  |
| type | Unknown |  |

### send_as

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| allowed_user_id | Unknown | FK |
| allowing_user_id | Unknown | FK |
| organization_id | Unknown |  |

### bulk_sequence_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| sequence_id | Unknown | FK |
| updated_by | Unknown | FK |
| action_type | Unknown |  |
| contact_preference | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| n_leads | Unknown |  |
| n_leads_processed | Unknown |  |
| organization_id | Unknown |  |
| query | Unknown |  |
| send_done_email | Unknown |  |
| sender_account_id | Unknown |  |
| sender_email | Unknown |  |
| sender_name | Unknown |  |
| status | Unknown |  |

### bulk_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| template_id | Unknown | FK |
| updated_by | Unknown | FK |
| contact_preference | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| n_leads | Unknown |  |
| n_leads_processed | Unknown |  |
| organization_id | Unknown |  |
| query | Unknown |  |
| send_done_email | Unknown |  |
| status | Unknown |  |

### connected_account_identity

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| connected_account_id | Unknown | PK, FK |
| name | Unknown |  |

### connected_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| imap | Unknown |  |
| organization_id | Unknown |  |
| smtp_host | Unknown |  |
| smtp_port | Unknown |  |
| smtp_use_ssl | Unknown |  |
| smtp_username | Unknown |  |
| synced_calendars | Json |  |
| type | Unknown |  |

### lead_status_change_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| new_status_id | Unknown | FK |
| old_status_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| organization_id | Unknown |  |
| users | Json |  |

### created_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| import_id | Unknown |  |
| organization_id | Unknown |  |
| source | Unknown |  |
| users | Json |  |

### outcome_applies_to

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| outcome_id | Unknown | PK, FK |
| applies_to | Unknown |  |

### outcome

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |

### sms_attachment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sms_activity_id | Unknown | PK, FK |
| content_type | Unknown |  |
| filename | Unknown |  |
| media_id | Unknown |  |
| size | Unknown |  |
| url | Unknown |  |

### sms_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| cost | Unknown |  |
| date_created | Unknown |  |
| date_sent | Unknown |  |
| date_updated | Unknown |  |
| direction | Unknown |  |
| local_country_iso | Unknown |  |
| local_phone | Unknown |  |
| organization_id | Unknown |  |
| remote_country_iso | Unknown |  |
| remote_phone | Unknown |  |
| remote_phone_formatted | Unknown |  |
| status | Unknown |  |
| text | Unknown |  |
| type | Unknown |  |

### group_member

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### groups

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |
| organization_id | Unknown |  |

### lead_address

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| lead_id | Unknown | FK |
| address_1 | Unknown |  |
| address_2 | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| label | Unknown |  |
| state | Unknown |  |
| zipcode | Unknown |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| first_communication_user_id | Unknown | FK |
| last_activity_user_id | Unknown | FK |
| last_communication_user_id | Unknown | FK |
| next_task_user_id | Unknown | FK |
| primary_opportunity_pipeline_id | Unknown | FK |
| primary_opportunity_status | Unknown | FK |
| primary_opportunity_user_id | Unknown | FK |
| status_id | Unknown | FK |
| updated_by | Unknown | FK |
| active_opportunity_value_summary | Unknown |  |
| contacts_summary | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| display_name | Unknown |  |
| first_call_created | Unknown |  |
| first_call_note | Unknown |  |
| first_communication_date | Unknown |  |
| first_communication_summary | Unknown |  |
| first_communication_type | Unknown |  |
| first_source | Unknown |  |
| html_url | Unknown |  |
| integration_links | Json |  |
| last_activity_date | Unknown |  |
| last_activity_type | Unknown |  |
| last_call_created | Unknown |  |
| last_call_duration | Unknown |  |
| last_call_note | Unknown |  |
| last_communication_date | Unknown |  |
| last_communication_summary | Unknown |  |
| last_communication_type | Unknown |  |
| last_email_date | Unknown |  |
| last_email_subject | Unknown |  |
| last_incoming_email_date | Unknown |  |
| last_lead_status_change_date | Unknown |  |
| last_note_created | Unknown |  |
| last_outgoing_call_date | Unknown |  |
| local_time | Unknown |  |
| name | Unknown |  |
| next_task_date | Unknown |  |
| next_task_due_date | Unknown |  |
| next_task_text | Unknown |  |
| organization_id | Unknown |  |
| primary_address_summary | Unknown |  |
| primary_email | Unknown |  |
| primary_email_type | Unknown |  |
| primary_phone | Unknown |  |
| primary_phone_country | Unknown |  |
| primary_phone_formatted | Unknown |  |
| primary_phone_type | Unknown |  |
| times_communicated | Unknown |  |
| url | Unknown |  |
| won_opportunity_value_summary | Unknown |  |

### email_thread_participant

| Column | Type | Keys |
| --- | --- | --- |
| email | Unknown | PK |
| email_thread_activity_id | Unknown | PK, FK |
| name | Unknown |  |

### email_thread_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| latest_normalized_subject | Unknown |  |
| n_emails | Unknown |  |
| organization_id | Unknown |  |
| type | Unknown |  |
| users | Json |  |

### pipline_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| pipeline_id | Unknown | FK |
| label | Unknown |  |
| type | Unknown |  |

### pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |

### call_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| sequence_id | Unknown | FK |
| sequence_subscription_id | Unknown | FK |
| transferred_from_user_id | Unknown | FK |
| transferred_to_user_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| activity_at | Unknown |  |
| call_method | Unknown |  |
| coach_legs | Json |  |
| cost | Double |  |
| date_answered | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| dialer_id | Unknown |  |
| dialer_saved_search_id | Unknown |  |
| direction | Unknown |  |
| disposition | Unknown |  |
| duration | Unknown |  |
| forwarded_to | Unknown |  |
| has_recording | Unknown |  |
| is_forwarded | Unknown |  |
| is_joinable | Unknown |  |
| is_to_group_number | Unknown |  |
| local_country_iso | Unknown |  |
| local_phone | Unknown |  |
| local_phone_formatted | Unknown |  |
| note | Unknown |  |
| organization_id | Unknown |  |
| phone | Unknown |  |
| recording_expires_at | Unknown |  |
| recording_url | Unknown |  |
| remote_country_iso | Unknown |  |
| remote_phone | Unknown |  |
| remote_phone_formatted | Unknown |  |
| source | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| users | Json |  |
| voicemail_duration | Unknown |  |
| voicemail_url | Unknown |  |

### form_field_definition_choice

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| form_field_definition_id | Unknown | PK, FK |
| form_id | Unknown | PK, FK |
| label | Unknown |  |
| value | Unknown |  |

### form_field_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| form_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| is_archived | Unknown |  |
| name | Unknown |  |
| organization_id | Unknown |  |

### meeting_attendee

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_activity_id | Unknown | PK, FK |
| contact_id | Unknown | FK |
| user_id | Unknown | FK |
| is_organizer | Unknown |  |
| status | Unknown |  |

### meeting_activity_transcript_utterance

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_activity_id | Unknown | PK, FK |
| meeting_activity_transcript_index | Unknown | PK, FK |
| ends | Unknown |  |
| speaker_label | Unknown |  |
| speaker_side | Unknown |  |
| start | Unknown |  |
| text | Unknown |  |

### meeting_activity_transcript

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| meeting_activity_id | Unknown | PK, FK |
| summary_html | Unknown |  |
| summary_text | Unknown |  |

### meeting_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| connected_account_id | Unknown | FK |
| contact_id | Unknown | FK |
| created_by | Unknown | FK |
| lead_id | Unknown | FK |
| updated_by | Unknown | FK |
| user_id | Unknown | FK |
| calendar_event_link | Unknown |  |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| duration | Unknown |  |
| ends_at | Unknown |  |
| is_recurring | Unknown |  |
| location | Unknown |  |
| note | Unknown |  |
| organization_id | Unknown |  |
| source | Unknown |  |
| starts_at | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| users | Json |  |

## Relationships

- form_submission(user_id) → users(id)
- form_submission(lead_id) → lead(id)
- form_submission(created_by) → users(id)
- form_submission(updated_by) → users(id)
- form_submission(contact_id) → contact(id)
- dialer_user(user_id) → users(id)
- dialer_user(dialer_id) → dialer(id)
- shared_association(shared_custom_field_id) → shared_custom_field(id)
- shared_custom_field(created_by) → users(id)
- shared_custom_field(updated_by) → users(id)
- bulk_delete(created_by) → users(id)
- bulk_delete(updated_by) → users(id)
- contact_email(contact_id) → contact(id)
- contact_phone(contact_id) → contact(id)
- contact(lead_id) → lead(id)
- contact(created_by) → users(id)
- contact(updated_by) → users(id)
- note_activity(user_id) → users(id)
- note_activity(lead_id) → lead(id)
- note_activity(created_by) → users(id)
- note_activity(updated_by) → users(id)
- note_activity(contact_id) → contact(id)
- opportunity_status_change_activity(opportunity_id) → opportunity(id)
- opportunity_status_change_activity(user_id) → users(id)
- opportunity_status_change_activity(old_status_id) → opportunity_status(id)
- opportunity_status_change_activity(created_by) → users(id)
- opportunity_status_change_activity(updated_by) → users(id)
- opportunity_status_change_activity(new_status_id) → opportunity_status(id)
- opportunity(user_id) → users(id)
- opportunity(lead_id) → lead(id)
- opportunity(created_by) → users(id)
- opportunity(status_id) → opportunity_status(id)
- opportunity(updated_by) → users(id)
- opportunity(contact_id) → contact(id)
- bulk_edit(lead_status_id) → lead_status(id)
- bulk_edit(created_by) → users(id)
- bulk_edit(updated_by) → users(id)
- custom_activity_field(custom_activity_id) → custom_activity(id)
- custom_activity(created_by) → users(id)
- custom_activity(updated_by) → users(id)
- sequence_step(updated_by_id) → users(id)
- sequence_step(created_by_id) → users(id)
- sequence_step(email_template_id) → email_template(id)
- sequence_step(sequence_id) → sequence(id)
- sequence(updated_by_id) → users(id)
- sequence(created_by_id) → users(id)
- opportunity_status(pipeline_id) → pipeline(id)
- task_email(task_id) → task(id)
- task(assigned_to) → users(id)
- task(lead_id) → lead(id)
- task(created_by) → users(id)
- task(updated_by) → users(id)
- task(contact_id) → contact(id)
- custom_activity_instance(user_id) → users(id)
- custom_activity_instance(lead_id) → lead(id)
- custom_activity_instance(created_by) → users(id)
- custom_activity_instance(updated_by) → users(id)
- custom_activity_instance(contact_id) → contact(id)
- phone_number(user_id) → users(id)
- opportunity_custom_field(created_by) → users(id)
- opportunity_custom_field(updated_by) → users(id)
- email_template(created_by) → users(id)
- email_template(updated_by) → users(id)
- task_completed_activity(user_id) → users(id)
- task_completed_activity(task_id) → task(id)
- task_completed_activity(lead_id) → lead(id)
- task_completed_activity(created_by) → users(id)
- task_completed_activity(updated_by) → users(id)
- activity_custom_field(created_by) → users(id)
- activity_custom_field(updated_by) → users(id)
- integration_link(created_by) → users(id)
- integration_link(updated_by) → users(id)
- contact_custom_field(created_by) → users(id)
- contact_custom_field(updated_by) → users(id)
- whatsapp_message_activity_attachment(whatsapp_message_activity_id) → whatsapp_message_activity(id)
- whatsapp_message_activity(external_whatsapp_message_id) → whatsapp_message_activity(id)
- whatsapp_message_activity(user_id) → users(id)
- whatsapp_message_activity(lead_id) → lead(id)
- whatsapp_message_activity(created_by) → users(id)
- whatsapp_message_activity(updated_by) → users(id)
- whatsapp_message_activity(contact_id) → contact(id)
- email_activity_attachment(email_activity_id) → email_activity(id)
- email_activity_to(email_activity_id) → email_activity(id)
- email_body_text(email_activity_id) → email_activity(id)
- email_envelope_sender(email_activity_id) → email_activity(id)
- email_envelope_to(email_activity_id) → email_activity(id)
- email_envelope_from(email_activity_id) → email_activity(id)
- email_activity(template_id) → email_template(id)
- email_activity(user_id) → users(id)
- email_activity(sequence_id) → sequence(id)
- email_activity(lead_id) → lead(id)
- email_activity(created_by) → users(id)
- email_activity(thread_id) → email_thread_activity(id)
- email_activity(sequence_subscription_id) → bulk_sequence_subscription(id)
- email_activity(followup_sequence_id) → sequence(id)
- email_activity(updated_by) → users(id)
- email_activity(contact_id) → contact(id)
- lead_custom_field(created_by) → users(id)
- lead_custom_field(updated_by) → users(id)
- send_as(allowed_user_id) → users(id)
- send_as(allowing_user_id) → users(id)
- bulk_sequence_subscription(sequence_id) → sequence(id)
- bulk_sequence_subscription(created_by) → users(id)
- bulk_sequence_subscription(updated_by) → users(id)
- bulk_email(template_id) → email_template(id)
- bulk_email(created_by) → users(id)
- bulk_email(updated_by) → users(id)
- connected_account_identity(connected_account_id) → connected_account(id)
- connected_account(user_id) → users(id)
- lead_status_change_activity(user_id) → users(id)
- lead_status_change_activity(old_status_id) → lead_status(id)
- lead_status_change_activity(lead_id) → lead(id)
- lead_status_change_activity(created_by) → users(id)
- lead_status_change_activity(updated_by) → users(id)
- lead_status_change_activity(new_status_id) → lead_status(id)
- lead_status_change_activity(contact_id) → contact(id)
- created_activity(user_id) → users(id)
- created_activity(lead_id) → lead(id)
- created_activity(created_by) → users(id)
- created_activity(updated_by) → users(id)
- created_activity(contact_id) → contact(id)
- outcome_applies_to(outcome_id) → outcome(id)
- outcome(created_by) → users(id)
- outcome(updated_by) → users(id)
- sms_attachment(sms_activity_id) → sms_activity(id)
- sms_activity(user_id) → users(id)
- sms_activity(lead_id) → lead(id)
- sms_activity(created_by) → users(id)
- sms_activity(updated_by) → users(id)
- sms_activity(contact_id) → contact(id)
- group_member(user_id) → users(id)
- group_member(group_id) → groups(id)
- lead_address(lead_id) → lead(id)
- lead(last_communication_user_id) → users(id)
- lead(next_task_user_id) → users(id)
- lead(first_communication_user_id) → users(id)
- lead(primary_opportunity_pipeline_id) → pipeline(id)
- lead(last_activity_user_id) → users(id)
- lead(created_by) → users(id)
- lead(status_id) → lead_status(id)
- lead(primary_opportunity_status) → opportunity_status(id)
- lead(updated_by) → users(id)
- lead(primary_opportunity_user_id) → users(id)
- email_thread_participant(email_thread_activity_id) → email_thread_activity(id)
- email_thread_activity(user_id) → users(id)
- email_thread_activity(lead_id) → lead(id)
- email_thread_activity(created_by) → users(id)
- email_thread_activity(updated_by) → users(id)
- email_thread_activity(contact_id) → contact(id)
- pipline_status(id) → opportunity_status(id)
- pipline_status(pipeline_id) → pipeline(id)
- pipeline(created_by) → users(id)
- pipeline(updated_by) → users(id)
- call_activity(user_id) → users(id)
- call_activity(sequence_id) → sequence(id)
- call_activity(lead_id) → lead(id)
- call_activity(created_by) → users(id)
- call_activity(sequence_subscription_id) → bulk_sequence_subscription(id)
- call_activity(transferred_to_user_id) → users(id)
- call_activity(transferred_from_user_id) → users(id)
- call_activity(updated_by) → users(id)
- call_activity(contact_id) → contact(id)
- form_field_definition_choice(form_id) → form_field_definition(form_id)
- form_field_definition_choice(form_field_definition_id) → form_field_definition(id)
- form_field_definition(form_id) → form(id)
- form(created_by) → users(id)
- form(updated_by) → users(id)
- meeting_attendee(user_id) → users(id)
- meeting_attendee(contact_id) → contact(id)
- meeting_attendee(meeting_activity_id) → meeting_activity(id)
- meeting_activity_transcript_utterance(meeting_activity_id) → meeting_activity_transcript(meeting_activity_id)
- meeting_activity_transcript_utterance(meeting_activity_transcript_index) → meeting_activity_transcript(index)
- meeting_activity_transcript(meeting_activity_id) → meeting_activity(id)
- meeting_activity(user_id) → users(id)
- meeting_activity(lead_id) → lead(id)
- meeting_activity(created_by) → users(id)
- meeting_activity(connected_account_id) → connected_account(id)
- meeting_activity(updated_by) → users(id)
- meeting_activity(contact_id) → contact(id)