# Insightly schema ERD

Table and field reference for the Fivetran Insightly connector.

## Table & Field Reference

### contact_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| link_object_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### contact_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | PK, FK |
| create_task_yearly | Unknown |  |
| occasion_date | Unknown |  |
| occasion_name | Unknown |  |
| repeat_yearly | Unknown |  |

### contact_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| contact_id | Unknown | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| address_mail_city | Unknown |  |
| address_mail_country | Unknown |  |
| address_mail_postcode | Unknown |  |
| address_mail_state | Unknown |  |
| address_mail_street | Unknown |  |
| address_other_city | Unknown |  |
| address_other_country | Unknown |  |
| address_other_postcode | Unknown |  |
| address_other_state | Unknown |  |
| address_other_street | Unknown |  |
| assistant_name | Unknown |  |
| background | Unknown |  |
| date_created_utc | Unknown |  |
| date_of_birth | Unknown |  |
| date_updated_utc | Unknown |  |
| email_address | Unknown |  |
| email_opted_out | Unknown |  |
| first_name | Unknown |  |
| image_url | Unknown |  |
| last_activity_date_utc | Unknown |  |
| last_name | Unknown |  |
| next_activity_date_utc | Unknown |  |
| phone | Unknown |  |
| phone_assistant | Unknown |  |
| phone_fax | Unknown |  |
| phone_home | Unknown |  |
| phone_mobile | Unknown |  |
| phone_other | Unknown |  |
| salutation | Unknown |  |
| social_facebook | Unknown |  |
| social_linkedin | Unknown |  |
| social_twitter | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

### lead_status

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_status | Unknown |  |
| field_order | Unknown |  |
| status | Unknown |  |
| status_type | Unknown |  |

### note_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| note_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### custom_field_option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| custom_field_custom_object_name | Unknown | PK, FK |
| custom_field_name | Unknown | PK, FK |
| option_default | Unknown |  |
| option_value | Unknown |  |

### custom_field

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| custom_object_name | Unknown | PK, FK |
| default_value | Unknown |  |
| editable | Unknown |  |
| field_for | Unknown |  |
| field_help_text | Unknown |  |
| field_label | Unknown |  |
| field_order | Unknown |  |
| field_type | Unknown |  |
| join_object | Unknown |  |
| visible | Unknown |  |

### email_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email_id | Unknown | FK |
| link_object_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### email_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| email_id | Unknown | PK, FK |

### email

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| date_created_utc | Unknown |  |
| email_date_utc | Unknown |  |
| email_from | Unknown |  |
| format | Unknown |  |
| queued_send_date_utc | Unknown |  |
| size | Unknown |  |
| subject | Unknown |  |

### event_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| event_id | Unknown | FK |
| link_object_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| all_day | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| details | Unknown |  |
| end_date_utc | Unknown |  |
| location | Unknown |  |
| reminder_date_utc | Unknown |  |
| reminder_sent | Unknown |  |
| start_date_utc | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

### contact_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### quote_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_item_id | Unknown | FK |
| price_book_entry_id | Unknown | FK |
| quote_id | Unknown | FK |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| list_price | Unknown |  |
| quantity | Unknown |  |
| sort_order | Unknown |  |
| subtotal | Unknown |  |
| total_price | Unknown |  |
| unit_price | Unknown |  |
| custom_** |  |  |

### email_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### forum_post

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_contact_id | Unknown | FK |
| edited_contact_id | Unknown | FK |
| forum_id | Unknown | FK |
| ticket_id | Unknown | FK |
| closed | Unknown |  |
| comment_count | Unknown |  |
| date_created | Unknown |  |
| date_edited | Unknown |  |
| date_update | Unknown |  |
| downvote_count | Unknown |  |
| featured | Unknown |  |
| follower_count | Unknown |  |
| message | Unknown |  |
| pending | Unknown |  |
| pinned | Unknown |  |
| post_name | Unknown |  |
| spam | Unknown |  |
| status | Unknown |  |
| upvote_count | Unknown |  |

### project_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| background_color | Unknown |  |
| name | Unknown |  |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| active | Unknown |  |
| code | Unknown |  |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| default_price | Unknown |  |
| description | Unknown |  |
| family | Unknown |  |
| image_url | Unknown |  |
| name | Unknown |  |
| sku | Unknown |  |
| custom_** |  |  |

### quote_document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| quote_id | Unknown | FK |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| file_id | Unknown |  |
| file_name | Unknown |  |
| quotation_name | Unknown |  |

### task_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_object_id | Unknown | FK |
| relationship_id | Unknown | FK |
| task_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_by_user_id | Unknown | FK |
| assigned_team_id | Unknown | FK |
| created_user_id | Unknown | FK |
| email_id | Unknown | FK |
| milestone_id | Unknown | FK |
| opportunity_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| parent_task_id | Unknown | FK |
| project_id | Unknown | FK |
| responsible_user_id | Unknown | FK |
| stage_id | Unknown | FK |
| task_category_id | Unknown | FK |
| assigned_date_utc | Unknown |  |
| completed | Unknown |  |
| completed_date_utc | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| details | Unknown |  |
| due_date | Unknown |  |
| owner_visible | Unknown |  |
| percent_complete | Unknown |  |
| priority | Unknown |  |
| publicly_visible | Unknown |  |
| recurrence | Unknown |  |
| reminder_date_utc | Unknown |  |
| reminder_sent | Unknown |  |
| start_date | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

### pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_set_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| pipeline_id | Unknown | FK |
| stage_name | Unknown |  |
| stage_order | Unknown |  |

### project_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_object_id | Unknown | FK |
| project_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### project_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| project_id | Unknown | PK, FK |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| opportunity_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| pipeline_id | Unknown | FK |
| project_category_id | Unknown | FK |
| responsible_user_id | Unknown | FK |
| stage_id | Unknown | FK |
| completed_date | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| image_url | Unknown |  |
| last_activity_date_utc | Unknown |  |
| next_activity_date_utc | Unknown |  |
| project_details | Unknown |  |
| project_name | Unknown |  |
| started_date | Unknown |  |
| status | Unknown |  |
| custom_** |  |  |

### task_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| background_color | Unknown |  |
| name | Unknown |  |

### lead_source

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| default_value | Unknown |  |
| field_order | Unknown |  |
| name | Unknown |  |

### organisation_email_domain

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| email_domain | Unknown |  |

### organisation_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_object_id | Unknown | FK |
| organisation_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### organisation_date

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | PK, FK |
| create_task_yearly | Unknown |  |
| occasion_date | Unknown |  |
| occasion_name | Unknown |  |
| repeat_yearly | Unknown |  |

### organisation_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| organisation_id | Unknown | PK, FK |

### organisation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| visible_team_id | Unknown | FK |
| address_billing_city | Unknown |  |
| address_billing_country | Unknown |  |
| address_billing_postcode | Unknown |  |
| address_billing_state | Unknown |  |
| address_billing_street | Unknown |  |
| address_ship_city | Unknown |  |
| address_ship_country | Unknown |  |
| address_ship_postcode | Unknown |  |
| address_ship_state | Unknown |  |
| address_ship_street | Unknown |  |
| background | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| image_url | Unknown |  |
| last_activity_date_utc | Unknown |  |
| name | Unknown |  |
| next_activity_date_utc | Unknown |  |
| phone | Unknown |  |
| phone_fax | Unknown |  |
| social_facebook | Unknown |  |
| social_linkedin | Unknown |  |
| social_twitter | Unknown |  |
| website | Unknown |  |
| custom_** |  |  |

### prospect_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| prospect_id | Unknown | PK, FK |

### prospect

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_user_id | Unknown | FK |
| lead_id | Unknown | FK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_postcode | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| date_created | Unknown |  |
| date_update | Unknown |  |
| description | Unknown |  |
| do_not_call | Unknown |  |
| do_not_email | Unknown |  |
| do_not_sync | Unknown |  |
| email_address | Unknown |  |
| employee_count | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| grade | Unknown |  |
| grade_profile_id | Unknown |  |
| industry | Unknown |  |
| last_activity_date | Unknown |  |
| last_name | Unknown |  |
| lead_conversion_date | Unknown |  |
| mobile | Unknown |  |
| opted_out | Unknown |  |
| organisation_name | Unknown |  |
| phone | Unknown |  |
| salutation | Unknown |  |
| score | Unknown |  |
| title | Unknown |  |
| custom_** |  |  |

### custom_object

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| created_user_id | Unknown | FK |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| description | Unknown |  |
| enable_navbar | Unknown |  |
| enable_workflow | Unknown |  |
| plural_label | Unknown |  |
| record_name_display_format | Unknown |  |
| record_name_label | Unknown |  |
| record_name_type | Unknown |  |
| singular_label | Unknown |  |

### relationship

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| for_contacts | Unknown |  |
| for_organisations | Unknown |  |
| forward | Unknown |  |
| forward_title | Unknown |  |
| reverse | Unknown |  |
| reverse_title | Unknown |  |

### opportunity_state_history

| Column | Type | Keys |
| --- | --- | --- |
| date_changed | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| for_opportunity_state | Unknown |  |
| state_reason | Unknown |  |
| state_reason_id | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| account_owner | Unknown |  |
| active | Unknown |  |
| administrator | Unknown |  |
| contact_display | Unknown |  |
| contact_order | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| email_address | Unknown |  |
| email_drop_box_address | Unknown |  |
| email_drop_box_identifier | Unknown |  |
| first_name | Unknown |  |
| instance_id | Unknown |  |
| last_name | Unknown |  |
| profile_id | Unknown |  |
| role_id | Unknown |  |
| task_week_start | Unknown |  |
| timezone_id | Unknown |  |
| user_currency | Unknown |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_user_id | Unknown | FK |
| opportunity_id | Unknown | FK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| price_book_id | Unknown | FK |
| address_billing_city | Unknown |  |
| address_billing_country | Unknown |  |
| address_billing_name | Unknown |  |
| address_billing_postcode | Unknown |  |
| address_billing_state | Unknown |  |
| address_billing_street | Unknown |  |
| address_shipping_city | Unknown |  |
| address_shipping_country | Unknown |  |
| address_shipping_name | Unknown |  |
| address_shipping_postcode | Unknown |  |
| address_shipping_state | Unknown |  |
| address_shipping_street | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| discount | Unknown |  |
| grand_total | Unknown |  |
| is_syncing | Unknown |  |
| line_item_count | Unknown |  |
| quotation_currency_code | Unknown |  |
| quotation_description | Unknown |  |
| quotation_email | Unknown |  |
| quotation_expiration_date | Unknown |  |
| quotation_fax | Unknown |  |
| quotation_name | Unknown |  |
| quotation_number | Unknown |  |
| quotation_phone | Unknown |  |
| quote_status | Unknown |  |
| shipping_handling | Unknown |  |
| subtotal | Unknown |  |
| tax | Unknown |  |
| total_price | Unknown |  |
| custom_** |  |  |

### opportunity_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| background_color | Unknown |  |
| name | Unknown |  |

### milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| project_id | Unknown | FK |
| completed | Unknown |  |
| completed_date_utc | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| due_date | Unknown |  |
| responsible_user | Unknown |  |
| title | Unknown |  |

### note_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | PK, FK |
| comment_id | Unknown | FK |
| note_id | Unknown | FK |

### organisation_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### price_book

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| active | Unknown |  |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| description | Unknown |  |
| is_standard | Unknown |  |
| name | Unknown |  |

### note_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_object_id | Unknown | FK |
| note_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| body | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| title | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_set_id | Unknown | PK, FK |
| assigned_team_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| responsible_user_id | Unknown | FK |
| all_day | Unknown |  |
| category_id | Unknown |  |
| details | Unknown |  |
| due_days_after_start | Unknown |  |
| due_days_before_end | Unknown |  |
| duration | Unknown |  |
| event_days_after_start | Unknown |  |
| event_days_before_end | Unknown |  |
| event_time | Unknown |  |
| name | Unknown |  |
| owner_visible | Unknown |  |
| publicly_visible | Unknown |  |
| reminder | Unknown |  |
| reminder_days_before_due | Unknown |  |
| reminder_time | Unknown |  |
| skip_fri | Unknown |  |
| skip_mon | Unknown |  |
| skip_sat | Unknown |  |
| skip_sun | Unknown |  |
| skip_thu | Unknown |  |
| skip_tue | Unknown |  |
| skip_wed | Unknown |  |
| type | Unknown |  |

### activity_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| for_contact | Unknown |  |
| for_lead | Unknown |  |
| for_opportunity | Unknown |  |
| for_organisation | Unknown |  |
| for_project | Unknown |  |
| name | Unknown |  |

### pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| for_opportunities | Unknown |  |
| for_projects | Unknown |  |
| pipeline_name | Unknown |  |

### opportunity_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | FK |
| price_book_entry_id | Unknown | FK |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| description | Unknown |  |
| discount | Unknown |  |
| list_price | Unknown |  |
| quantity | Unknown |  |
| service_date | Unknown |  |
| subtotal | Unknown |  |
| total_price | Unknown |  |
| unit_price | Unknown |  |
| custom_** |  |  |

### forum_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_contact_id | Unknown | FK |
| edited_contact_id | Unknown | FK |
| forum_id | Unknown | FK |
| post_id | Unknown | FK |
| answer | Unknown |  |
| body | Unknown |  |
| date_created | Unknown |  |
| date_edited | Unknown |  |
| date_update | Unknown |  |
| downvote_count | Unknown |  |
| official | Unknown |  |
| pending | Unknown |  |
| spam | Unknown |  |
| upvote_count | Unknown |  |

### price_book_entry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| price_book_id | Unknown | FK |
| product_id | Unknown | FK |
| active | Unknown |  |
| currency_code | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| price | Unknown |  |
| use_standard_price | Unknown |  |
| custom_** |  |  |

### lead_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### forum_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_date | Unknown |  |
| name | Unknown |  |
| updated_date | Unknown |  |

### ticket_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| ticket_id | Unknown | PK, FK |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contact_id | Unknown | FK |
| created_user_id | Unknown | FK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| date_closed | Unknown |  |
| date_created | Unknown |  |
| date_solved | Unknown |  |
| date_updated | Unknown |  |
| priority | Unknown |  |
| source | Unknown |  |
| subject | Unknown |  |
| ticket_comment_body | Unknown |  |
| ticket_number | Unknown |  |
| ticket_status | Unknown |  |
| ticket_type | Unknown |  |
| to_email_address | Unknown |  |
| custom_** |  |  |

### team_member

| Column | Type | Keys |
| --- | --- | --- |
| permission_id | Unknown | PK |
| member_user_id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| name | Unknown |  |

### opportunity_file_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| content_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| file_category_id | Unknown |  |
| file_name | Unknown |  |
| file_size | Unknown |  |
| url | Unknown |  |

### custom_object_record

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_user_id | Unknown | FK |
| visible_team_id | Unknown | FK |
| date_created_utc | Unknown |  |
| record_name | Unknown |  |
| visible_to | Unknown |  |
| custom_** |  |  |

### opportunity_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| link_object_id | Unknown | FK |
| opportunity_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### opportunity_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| opportunity_id | Unknown | PK, FK |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| opportunity_category_id | Unknown | FK |
| organisation_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| pipeline_id | Unknown | FK |
| price_book_id | Unknown | FK |
| responsible_user_id | Unknown | FK |
| stage_id | Unknown | FK |
| actual_close_date | Unknown |  |
| bid_amount | Unknown |  |
| bid_currency | Unknown |  |
| bid_duration | Unknown |  |
| bid_type | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| details | Unknown |  |
| forecast_close_date | Unknown |  |
| image_url | Unknown |  |
| last_activity_date_utc | Unknown |  |
| name | Unknown |  |
| next_activity_date_utc | Unknown |  |
| probability | Unknown |  |
| state | Unknown |  |
| value | Unknown |  |
| custom_** |  |  |

### forum

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_user_id | Unknown | FK |
| forum_category_id | Unknown | FK |
| date_created | Unknown |  |
| date_updated | Unknown |  |
| description | Unknown |  |
| forum_name | Unknown |  |
| forum_order | Unknown |  |
| forum_type | Unknown |  |
| visibility | Unknown |  |

### lead_link

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lead_id | Unknown | FK |
| link_object_id | Unknown | FK |
| relationship_id | Unknown | FK |
| detail | Unknown |  |
| is_forward | Unknown |  |
| link_object_name | Unknown |  |
| role | Unknown |  |

### lead_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| lead_id | Unknown | PK, FK |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| converted_contact_id | Unknown | FK |
| converted_opportunity_id | Unknown | FK |
| converted_organisation_id | Unknown | FK |
| created_user_id | Unknown | FK |
| lead_source_id | Unknown | FK |
| lead_status_id | Unknown | FK |
| owner_user_id | Unknown | FK |
| responsible_user_id | Unknown | FK |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_postcode | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| converted | Unknown |  |
| converted_date_utc | Unknown |  |
| date_created_utc | Unknown |  |
| date_updated_utc | Unknown |  |
| email | Unknown |  |
| email_opted_out | Unknown |  |
| fax | Unknown |  |
| first_name | Unknown |  |
| image_url | Unknown |  |
| industry | Unknown |  |
| last_activity_date_utc | Unknown |  |
| last_name | Unknown |  |
| lead_description | Unknown |  |
| lead_rating | Unknown |  |
| mobile | Unknown |  |
| next_activity_date_utc | Unknown |  |
| phone | Unknown |  |
| salutation | Unknown |  |
| title | Unknown |  |
| website | Unknown |  |
| custom_** |  |  |

## Relationships

- contact_link(contact_id) → contact(id)
- contact_link(link_object_id) → lead(id)
- contact_link(relationship_id) → relationship(id)
- contact_date(contact_id) → contact(id)
- contact_tag(contact_id) → contact(id)
- contact(organisation_id) → organisation(id)
- contact(owner_user_id) → users(id)
- contact(created_user_id) → users(id)
- note_file_attachment(owner_user_id) → users(id)
- note_file_attachment(note_id) → note(id)
- custom_field_option(custom_field_name) → custom_field(name)
- custom_field_option(custom_field_custom_object_name) → custom_field(custom_object_name)
- custom_field(custom_object_name) → custom_object(name)
- email_link(email_id) → email(id)
- email_link(link_object_id) → contact(id)
- email_link(relationship_id) → relationship(id)
- email_tag(email_id) → email(id)
- email(owner_user_id) → users(id)
- email(created_user_id) → users(id)
- event_link(event_id) → event(id)
- event_link(link_object_id) → contact(id)
- event_link(relationship_id) → relationship(id)
- event(owner_user_id) → users(id)
- contact_file_attachment(owner_user_id) → users(id)
- contact_file_attachment(contact_id) → contact(id)
- quote_item(price_book_entry_id) → price_book_entry(id)
- quote_item(quote_id) → quote(id)
- quote_item(opportunity_item_id) → opportunity_item(id)
- email_file_attachment(owner_user_id) → users(id)
- email_file_attachment(email_id) → email(id)
- forum_post(created_contact_id) → contact(id)
- forum_post(ticket_id) → ticket(id)
- forum_post(edited_contact_id) → contact(id)
- forum_post(forum_id) → forum(id)
- product(owner_user_id) → users(id)
- product(created_user_id) → users(id)
- quote_document(quote_id) → quote(id)
- quote_document(owner_user_id) → users(id)
- task_link(task_id) → task(id)
- task_link(link_object_id) → contact(id)
- task_link(relationship_id) → relationship(id)
- task(opportunity_id) → opportunity(id)
- task(stage_id) → pipeline_stage(id)
- task(assigned_team_id) → team(id)
- task(email_id) → email(id)
- task(owner_user_id) → users(id)
- task(milestone_id) → milestone(id)
- task(task_category_id) → task_category(id)
- task(project_id) → project(id)
- task(created_user_id) → users(id)
- task(responsible_user_id) → users(id)
- task(assigned_by_user_id) → users(id)
- task(parent_task_id) → task(id)
- pipeline_stage(pipeline_id) → pipeline(id)
- pipeline_stage(activity_set_id) → activity_set(id)
- pipeline_stage(owner_user_id) → users(id)
- project_link(project_id) → project(id)
- project_link(link_object_id) → contact(id)
- project_link(relationship_id) → relationship(id)
- project_tag(project_id) → project(id)
- project(opportunity_id) → opportunity(id)
- project(pipeline_id) → pipeline(id)
- project(stage_id) → pipeline_stage(id)
- project(owner_user_id) → users(id)
- project(created_user_id) → users(id)
- project(responsible_user_id) → users(id)
- project(project_category_id) → project_category(id)
- organisation_email_domain(organisation_id) → organisation(id)
- organisation_link(organisation_id) → organisation(id)
- organisation_link(link_object_id) → contact(id)
- organisation_link(relationship_id) → relationship(id)
- organisation_date(organisation_id) → organisation(id)
- organisation_tag(organisation_id) → organisation(id)
- organisation(owner_user_id) → users(id)
- organisation(visible_team_id) → team(id)
- organisation(created_user_id) → users(id)
- prospect_tag(prospect_id) → prospect(id)
- prospect(lead_id) → lead(id)
- prospect(organisation_id) → organisation(id)
- prospect(owner_user_id) → users(id)
- prospect(created_user_id) → users(id)
- prospect(contact_id) → contact(id)
- custom_object(created_user_id) → users(id)
- opportunity_state_history(opportunity_id) → opportunity(id)
- users(contact_id) → contact(id)
- quote(opportunity_id) → opportunity(id)
- quote(organisation_id) → organisation(id)
- quote(owner_user_id) → users(id)
- quote(created_user_id) → users(id)
- quote(contact_id) → contact(id)
- quote(price_book_id) → price_book(id)
- milestone(owner_user_id) → users(id)
- milestone(project_id) → project(id)
- note_comment(owner_user_id) → users(id)
- note_comment(comment_id) → forum_comment(id)
- note_comment(note_id) → note(id)
- organisation_file_attachment(owner_user_id) → users(id)
- organisation_file_attachment(organisation_id) → organisation(id)
- price_book(owner_user_id) → users(id)
- price_book(created_user_id) → users(id)
- note_link(note_id) → note(id)
- note_link(link_object_id) → contact(id)
- note_link(relationship_id) → relationship(id)
- note(owner_user_id) → users(id)
- activity(assigned_team_id) → team(id)
- activity(activity_set_id) → activity_set(id)
- activity(owner_user_id) → users(id)
- activity(responsible_user_id) → users(id)
- activity_set(owner_user_id) → users(id)
- pipeline(owner_user_id) → users(id)
- opportunity_item(opportunity_id) → opportunity(id)
- opportunity_item(price_book_entry_id) → price_book_entry(id)
- forum_comment(post_id) → forum_post(id)
- forum_comment(created_contact_id) → contact(id)
- forum_comment(edited_contact_id) → contact(id)
- forum_comment(forum_id) → forum(id)
- price_book_entry(product_id) → product(id)
- price_book_entry(created_user_id) → users(id)
- price_book_entry(price_book_id) → price_book(id)
- lead_file_attachment(owner_user_id) → users(id)
- lead_file_attachment(lead_id) → lead(id)
- ticket_tag(ticket_id) → ticket(id)
- ticket(organisation_id) → organisation(id)
- ticket(owner_user_id) → users(id)
- ticket(created_user_id) → users(id)
- ticket(contact_id) → contact(id)
- team_member(team_id) → team(id)
- team_member(member_user_id) → users(id)
- opportunity_file_attachment(owner_user_id) → users(id)
- opportunity_file_attachment(opportunity_id) → opportunity(id)
- custom_object_record(owner_user_id) → users(id)
- custom_object_record(visible_team_id) → team(id)
- opportunity_link(opportunity_id) → opportunity(id)
- opportunity_link(link_object_id) → contact(id)
- opportunity_link(relationship_id) → relationship(id)
- opportunity_tag(opportunity_id) → opportunity(id)
- opportunity(pipeline_id) → pipeline(id)
- opportunity(stage_id) → pipeline_stage(id)
- opportunity(organisation_id) → organisation(id)
- opportunity(opportunity_category_id) → opportunity_category(id)
- opportunity(owner_user_id) → users(id)
- opportunity(created_user_id) → users(id)
- opportunity(responsible_user_id) → users(id)
- opportunity(price_book_id) → price_book(id)
- forum(forum_category_id) → forum_category(id)
- forum(created_user_id) → users(id)
- lead_link(lead_id) → lead(id)
- lead_link(link_object_id) → contact(id)
- lead_link(relationship_id) → relationship(id)
- lead_tag(lead_id) → lead(id)
- lead(converted_contact_id) → contact(id)
- lead(converted_opportunity_id) → opportunity(id)
- lead(lead_status_id) → lead_status(id)
- lead(lead_source_id) → lead_source(id)
- lead(owner_user_id) → users(id)
- lead(created_user_id) → users(id)
- lead(responsible_user_id) → users(id)
- lead(converted_organisation_id) → organisation(id)