# HubSpot schema ERD

Table and field reference for the Fivetran HubSpot connector.

## Table & Field Reference

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Long | PK, FK |
| user_id | Long | PK, FK |
| is_secondary_user | Boolean |  |

### quote_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| order_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### email_event_delivered

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| response | String |  |
| smtp_id | String |  |

### deal_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| deal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### marketing_campaign_asset

| Column | Type | Keys |
| --- | --- | --- |
| asset_type | String | PK |
| id | String | PK |
| campaign_id | String | PK, FK |
| name | String |  |

### course_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| course_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### lead_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| lead_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### owner_team

| Column | Type | Keys |
| --- | --- | --- |
| owner_id | Long | PK, FK |
| team_id | Long | PK, FK |
| is_team_primary | Boolean |  |

### email_event_deferred

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| attempt | Long |  |
| response | String |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| deal_id | Long | PK |
| is_deleted | Boolean |  |
| portal_id | Long |  |

### order_payment

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| order_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### lead_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| lead_id | Long | PK, FK |
| type_id | Long | PK, FK |

### feedback_submission_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| feedback_submission_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### goal_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| goal_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event_spam_report

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| ip_address | String |  |
| user_agent | String |  |

### lead_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| stage_id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| lead_state | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### payment_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### goal_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| goal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| listing_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### project_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### quote_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| quote_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### course_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### cart_task

| Column | Type | Keys |
| --- | --- | --- |
| task_id | Long | PK |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| type_id | Long | PK, FK |

### activity_login

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_id | Long | FK |
| country_code | String |  |
| email | String |  |
| ip_address | String |  |
| location | String |  |
| login_at | Instant |  |
| login_succeeded | Boolean |  |
| region_code | String |  |
| user_agent | String |  |

### cart_quote

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### payment_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| payment_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### contact_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| from_contact_id | Long | PK, FK |
| to_contact_id | Long | PK, FK |
| type_id | Long | PK, FK |

### service_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### cart_line_item

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| line_item_id | Long | PK, FK |
| type_id | Long | PK, FK |

### engagement

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| type | String | PK |
| portal_id | Long |  |

### custom_event_definition_association

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| custom_event_definition_id | String | PK, FK |
| allows_custom_labels | Boolean |  |
| cardinality | String |  |
| category | String |  |
| from_object_type | String |  |
| from_object_type_id | String |  |
| has_all_associated_objects | Boolean |  |
| has_cascading_deletes | Boolean |  |
| has_user_enforced_max_from_object_ids | Boolean |  |
| has_user_enforced_max_to_object_ids | Boolean |  |
| hidden | Boolean |  |
| inverse_allows_custom_labels | Boolean |  |
| inverse_cardinality | String |  |
| inverse_has_all_associated_objects | Boolean |  |
| inverse_id | Long |  |
| inverse_label | String |  |
| inverse_name | String |  |
| is_inverse_primary | Boolean |  |
| is_primary | Boolean |  |
| label | String |  |
| max_from_object_ids | Long |  |
| max_to_object_ids | Long |  |
| name | String |  |
| portal_unique_identifier | String |  |
| to_object_type | String |  |
| to_object_type_id | String |  |

### service_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| service_id | Long | PK, FK |
| type_id | Long | PK, FK |

### sequence_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| contact_id | Long | FK |
| sequence_id | String | FK |
| enrolled_at | Instant |  |
| enrolled_by | String |  |
| enrolled_by_email | String |  |
| sequence_name | String |  |
| to_email | String |  |
| updated_at | Instant |  |

### listing_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### order_feedback_submission

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| feedback_submission_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### marketing_campaign_spend_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | PK, FK |
| amount | Double |  |
| created_at | Long |  |
| description | String |  |
| name | String |  |
| spend_total | Double |  |
| updated_at | Long |  |

### subscription_payment

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| payment_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### invoice_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| invoice_id | Long | PK, FK |
| type_id | Long | PK, FK |

### custom_event_definition_property_option

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| custom_event_definition_id | String | PK, FK |
| property_name | String | PK, FK |
| description | String |  |
| display_order | Int |  |
| hidden | Boolean |  |
| value | String |  |

### course_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### property_option

| Column | Type | Keys |
| --- | --- | --- |
| label | String | PK |
| hubspot_object | String | PK, FK |
| name | String | PK, FK |
| description | String |  |
| display_order | Int |  |
| hidden | Boolean |  |
| value | String |  |

### company_list_member

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Long | PK, FK |
| company_list_id | Long | PK, FK |
| added_at | Instant |  |

### feedback_submission

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### company_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| created_by_id | String |  |
| filters_updated_at | Instant |  |
| list_version | Long |  |
| name | String |  |
| object_type_id | String |  |
| processing_status | String |  |
| processing_type | String |  |
| updated_at | Instant |  |

### service_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| service_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### deal_split

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| deal_id | Long | PK, FK |
| owner_id | Long | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| deal_split_percentage | Double |  |
| updated_at | Instant |  |

### custom_event_definition_property

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| custom_event_definition_id | String | PK, FK |
| calculated | Boolean |  |
| created_at | Instant |  |
| created_user_id | Long |  |
| data_sensitivity | String |  |
| description | String |  |
| display_order | Int |  |
| external_options | Boolean |  |
| field_type | String |  |
| form_field | Boolean |  |
| group_name | String |  |
| has_unique_value | Boolean |  |
| hidden | Boolean |  |
| label | String |  |
| modification_metadata_archivable | Boolean |  |
| modification_metadata_read_only_definition | Boolean |  |
| modification_metadata_read_only_value | Boolean |  |
| type | String |  |
| updated_at | Instant |  |
| updated_user_id | Long |  |

### course_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| course_id | Long | PK, FK |
| type_id | Long | PK, FK |

### invoice_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| invoice_id | Long | PK, FK |
| type_id | Long | PK, FK |

### contact_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| contact_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### order_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### conversation_actor

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| avatar | String |  |
| email | String |  |
| name | String |  |
| type | String |  |

### engagement_lead

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| lead_id | Long | PK, FK |
| type_id | Long | PK, FK |

### submission_response

| Column | Type | Keys |
| --- | --- | --- |
| field_name | String | PK |
| field_value | String | PK |
| object_type_id | String | PK |
| conversion_id | String | PK, FK |
| form_id | String | PK, FK |
| page_url | String |  |
| submitted_at | Long |  |

### conversation_thread

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| associated_contact_id | String | FK |
| associated_ticket_id | String | FK |
| inbox_id | String | FK |
| original_channel_account_id | String | FK |
| original_channel_id | String | FK |
| assigned_to | String |  |
| closed_at | Instant |  |
| created_at | Instant |  |
| latest_message_received_timestamp | Instant |  |
| latest_message_sent_timestamp | Instant |  |
| latest_message_timestamp | Instant |  |
| spam | String |  |
| status | String |  |

### subscription_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### course_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| course_id | Long | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| type_id | Long | PK, FK |

### email_event_bounce

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| category | String |  |
| response | String |  |
| status | String |  |

### subscription_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| subscription_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### service

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### contact_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| created_at | Instant |  |
| created_by_id | String |  |
| filters_updated_at | Instant |  |
| list_version | Long |  |
| name | String |  |
| object_type_id | String |  |
| processing_status | String |  |
| processing_type | String |  |
| updated_at | Instant |  |

### project_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### engagement_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| type_id | Long | PK, FK |

### invoice_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| invoice_id | Long | PK, FK |
| type_id | Long | PK, FK |

### marketing_email_campaign

| Column | Type | Keys |
| --- | --- | --- |
| campaign_id | Long | PK, FK |
| marketing_email_id | Long | PK, FK |

### email_event_status_change

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| bounced | Boolean |  |
| portal_subscription_status | String |  |
| requested_by | String |  |
| source | String |  |
| subscriptions | Json |  |

### course_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| course_id | Long | PK, FK |
| deal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| subscription_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event_open

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| browser | Json |  |
| duration | String |  |
| ip_address | String |  |
| location | Json |  |
| user_agent | String |  |

### goal_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| goal_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### sources_analytics_overall_report

| Column | Type | Keys |
| --- | --- | --- |
| breakdown | String | PK |
| bounce_rate | Double |  |
| bounces | Long |  |
| contact_to_customer_rate | Double |  |
| contacts | Long |  |
| contacts_per_pageview | Double |  |
| customers | Long |  |
| leads | Long |  |
| leads_per_view | Double |  |
| marketing_qualified_leads | Long |  |
| new_visitor_session_rate | Double |  |
| opportunities | Long |  |
| pageviews_minus_exits | Long |  |
| pageviews_per_session | Double |  |
| raw_views | Long |  |
| returning_visits | Long |  |
| sales_qualified_leads | Long |  |
| session_to_contact_rate | Double |  |
| standard_views | Long |  |
| subscribers | Long |  |
| time | Long |  |
| time_per_session | Double |  |
| visitors | Long |  |
| visits | Long |  |

### company_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| company_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### project_listing

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| listing_id | Long | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### tax_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| tax_id | Long | PK, FK |
| type_id | Long | PK, FK |

### deal_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| deal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### line_item_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| line_item_id | Long | PK, FK |
| type_id | Long | PK, FK |

### owner

| Column | Type | Keys |
| --- | --- | --- |
| owner_id | Long | PK |
| active_user_id | Long |  |
| created_at | Instant |  |
| email | String |  |
| first_name | String |  |
| is_active | Boolean |  |
| last_name | String |  |
| updated_at | Instant |  |
| user_id_including_inactive | Long |  |

### discount_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| invoice_id | Long | PK, FK |
| type_id | Long | PK, FK |

### lead_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| lead_id | Long | PK, FK |
| type_id | Long | PK, FK |

### payment_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| payment_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### project_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### order_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_feedback_submission

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| feedback_submission_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### engagement_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### discount_order

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### feedback_submission_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| feedback_submission_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### order_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| line_item_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event_forward

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| browser | Json |  |
| ip_address | String |  |
| location | Json |  |
| user_agent | String |  |

### cart_discount

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| type_id | Long | PK, FK |

### goal_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| goal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### goal_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| goal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### service_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| service_id | Long | PK, FK |
| type_id | Long | PK, FK |

### cart_contact

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| type_id | Long | PK, FK |

### ticket_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| email_campaign_id | Long | FK |
| app_id | Long |  |
| caused_by_created | Instant |  |
| caused_by_id | String |  |
| created | Instant |  |
| filtered_event | Boolean |  |
| obsoleted_by_created | Instant |  |
| obsoleted_by_id | String |  |
| portal_id | Long |  |
| recipient | String |  |
| sent_by_created | Instant |  |
| sent_by_id | String |  |
| type | String |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |

### cart_ticket

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### contact_form_submission

| Column | Type | Keys |
| --- | --- | --- |
| timestamp | Instant | PK |
| contact_id | Long | PK, FK |
| form_id | String | PK, FK |
| page_id | String |  |
| portal_id | Long |  |

### marketing_campaign_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_type | String | PK |
| campaign_id | String | PK, FK |
| contact_id | String | PK, FK |

### tax_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| quote_id | Long | PK, FK |
| tax_id | Long | PK, FK |
| type_id | Long | PK, FK |

### lead_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| lead_id | Long | PK, FK |
| type_id | Long | PK, FK |

### discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### quote_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| acting_user_id | Long | FK |
| action | String |  |
| category | String |  |
| occurred_at | Instant |  |
| sub_category | String |  |
| target_object_id | String |  |

### cart_order

| Column | Type | Keys |
| --- | --- | --- |
| cart_id | Long | PK, FK |
| category | String | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### sessions_analytics_overall_report

| Column | Type | Keys |
| --- | --- | --- |
| breakdown | String | PK |
| desktop | Long |  |
| direct_traffic | Long |  |
| email_marketing | Long |  |
| mobile | Long |  |
| other_campaigns | Long |  |
| paid_search | Long |  |
| social_media | Long |  |

### fee_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| fee_id | Long | PK, FK |
| invoice_id | Long | PK, FK |
| type_id | Long | PK, FK |

### association_type

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK |
| id | Long | PK |
| from_object_type | String |  |
| label | String |  |
| name | String |  |
| to_object_type | String |  |

### lead

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### listing_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| listing_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| order_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### feedback_submission_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| feedback_submission_id | Long | PK, FK |
| type_id | Long | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| portal_id | Long |  |

### marketing_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| created_at | Instant |  |
| hs_audience | String |  |
| hs_budget_items_sum_amount | Double |  |
| hs_campaign_status | String |  |
| hs_color_hex | String |  |
| hs_created_by_user_id | String |  |
| hs_currency_code | String |  |
| hs_end_date | String |  |
| hs_name | String |  |
| hs_notes | String |  |
| hs_object_id | String |  |
| hs_owner | String |  |
| hs_spend_items_sum_amount | Double |  |
| hs_start_date | String |  |
| hs_utm | String |  |
| updated_at | Instant |  |

### marketing_event_custom_property

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| marketing_event_id | Long | PK, FK |
| value | String |  |

### project_service

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| project_id | Long | PK, FK |
| service_id | Long | PK, FK |
| type_id | Long | PK, FK |

### discount_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| discount_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### ticket_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| ticket_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp_instant | Instant |  |
| value | String |  |

### email_event_suppressed

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| bcc | Json |  |
| cc | Json |  |
| email_campaign_group_id | String |  |
| from | String |  |
| reply_to | Json |  |
| subject | String |  |

### merged_deal

| Column | Type | Keys |
| --- | --- | --- |
| deal_id | Long | PK, FK |
| merged_deal_id | Long | PK, FK |

### tax_payment

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| payment_id | Long | PK, FK |
| tax_id | Long | PK, FK |
| type_id | Long | PK, FK |

### fee

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| portal_id | Long |  |

### quote_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| line_item_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| is_deleted | Boolean |  |
| portal_id | Long |  |

### ticket_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| from_ticket_id | Long | PK, FK |
| to_ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| listing_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| listing_id | Long | PK, FK |
| type_id | Long | PK, FK |

### payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### course_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| course_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_id | Long |  |
| app_name | String |  |
| content_id | Long |  |
| name | String |  |
| num_included | Int |  |
| num_queued | Int |  |
| sub_type | String |  |
| subject | String |  |
| type | String |  |

### activity_security

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_id | Long | FK |
| acting_user | String |  |
| country_code | String |  |
| created_at | Instant |  |
| info_url | String |  |
| ip_address | String |  |
| location | String |  |
| object_id | String |  |
| region_code | String |  |
| type | String |  |

### marketing_campaign_budget_item

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| campaign_id | String | PK, FK |
| amount | Double |  |
| budget_total | Double |  |
| created_at | Long |  |
| currency_code | String |  |
| description | String |  |
| name | String |  |
| remaining_budget | Double |  |
| updated_at | Long |  |

### subscription_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| line_item_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| listing_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### project_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| project_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### payment_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### project_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### contact_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| contact_id | Long | PK, FK |
| type_id | Long | PK, FK |

### sequence

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| user_id | String | PK, FK |
| created_at | Instant |  |
| folder_id | String |  |
| name | String |  |
| updated_at | Instant |  |

### ticket_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### discount_payment

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### conversation_message_sender

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| actor_id | String | FK |
| message_id | String | FK |
| thread_id | String | FK |
| delivery_identifier_type | String |  |
| delivery_identifier_value | String |  |
| name | String |  |
| sender_field | String |  |

### service_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| service_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event_click

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| browser | Json |  |
| ip_address | String |  |
| location | Json |  |
| referer | String |  |
| url | String |  |
| user_agent | String |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| line_item_id | Long | PK, FK |
| type_id | Long | PK, FK |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| is_deleted | Boolean |  |

### service_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| service_id | Long | PK, FK |
| type_id | Long | PK, FK |

### fee_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| fee_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### conversation_channel_account

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| channel_id | String | FK |
| inbox_id | String | FK |
| active | Boolean |  |
| authorized | Boolean |  |
| created_at | Instant |  |
| delivery_identifier_type | String |  |
| delivery_identifier_value | String |  |
| name | String |  |

### tax_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| tax_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### email_event_print

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| browser | Json |  |
| ip_address | String |  |
| location | Json |  |
| user_agent | String |  |

### discount_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| product_id | Long | FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| primary_team_id | Long | FK |
| role_id | Long | FK |
| email | String |  |
| first_name | String |  |
| last_name | String |  |

### deal_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| from_deal_id | Long | PK, FK |
| to_deal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### marketing_event_participant

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| marketing_event_id | String | PK, FK |
| contact_id | String | FK |
| created_at | Instant |  |
| properties_** |  |  |

### fee_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| fee_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### order_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### deal_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| pipeline_id | String | PK |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### payment_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### invoice_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| invoice_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### deal_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| deal_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### project_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### engagement_goal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| goal_id | Long | PK, FK |
| type_id | Long | PK, FK |

### engagement_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| type_id | Long | PK, FK |

### listing

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### order

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### deal_stage

| Column | Type | Keys |
| --- | --- | --- |
| deal_id | Long | PK, FK |
| date_entered | Instant |  |
| source | String |  |
| source_id | String |  |
| value | String |  |

### marketing_email

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| campaign | String | FK |
| subscription_id | Long | FK |
| ab_sample_size_default | String |  |
| ab_sampling_default | String |  |
| ab_status | String |  |
| ab_success_metric | String |  |
| ab_test_percentage | Long |  |
| active_domain | String |  |
| archived | Boolean |  |
| business_unit_id | String |  |
| campaign_name | String |  |
| campaign_utm | String |  |
| cloned_from | String |  |
| created_at | Instant |  |
| created_by_id | String |  |
| custom_reply_to | String |  |
| deleted_at | Instant |  |
| feedback_survey_id | String |  |
| folder_id | Long |  |
| folder_id_v_2 | Long |  |
| from_name | String |  |
| hours_to_wait | Long |  |
| is_ab | Boolean |  |
| is_ab_variation | Boolean |  |
| is_published | Boolean |  |
| is_transactional | Boolean |  |
| jitter_send_time | Boolean |  |
| language | String |  |
| limit_send_frequency | Boolean |  |
| name | String |  |
| office_location_id | String |  |
| preferences_group_id | String |  |
| publish_date | Instant |  |
| published_at | Instant |  |
| published_by_email | String |  |
| published_by_id | String |  |
| published_by_name | String |  |
| reply_to | String |  |
| send_on_publish | Boolean |  |
| state | String |  |
| subcategory | String |  |
| subject | String |  |
| subscription_name | String |  |
| suppress_graymail | Boolean |  |
| test_id | String |  |
| type | String |  |
| updated_at | Instant |  |
| updated_by_id | String |  |
| rss_data_** |  |  |
| webversion_** |  |  |

### conversation_message_history

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| thread_id | String | PK, FK |
| channel_account_id | String | FK |
| channel_id | String | FK |
| from_inbox_id | String | FK |
| to_inbox_id | String | FK |
| assigned_from | String |  |
| assigned_to | String |  |
| client_type | String |  |
| created_at | Instant |  |
| created_by | String |  |
| direction | String |  |
| in_reply_to_id | String |  |
| new_status | String |  |
| rich_text | String |  |
| status_type | String |  |
| subject | String |  |
| text | String |  |
| truncation_status | String |  |
| type | String |  |
| updated_at | Instant |  |

### email_event_dropped

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| bcc | Json |  |
| cc | Json |  |
| drop_message | String |  |
| drop_reason | String |  |
| from | String |  |
| reply_to | Json |  |
| subject | String |  |

### course_project

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| course_id | Long | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### lead_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| pipeline_id | String | PK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### payment_invoice

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### ticket_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### cart

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### marketing_event_list

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| marketing_event_id | Long | PK, FK |
| created_by_id | String | FK |
| created_at | Instant |  |
| deleted_at | Instant |  |
| filters_updated_at | Instant |  |
| list_version | Long |  |
| name | String |  |
| object_type_id | String |  |
| processing_status | String |  |
| processing_type | String |  |
| size | Long |  |
| updated_at | Instant |  |
| updated_by_id | String |  |

### course

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### discount_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| discount_id | Long | PK, FK |
| line_item_id | Long | PK, FK |
| type_id | Long | PK, FK |

### role

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| name | String |  |
| requires_billing_write | Boolean |  |

### project_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| project_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### email_event_sent

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK, FK |
| bcc | Json |  |
| cc | Json |  |
| from | String |  |
| reply_to | Json |  |
| subject | String |  |

### fee_payment

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| fee_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### custom_event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| type | String | PK, FK |
| object_id | String |  |
| object_type | String |  |
| occurred_at | Instant |  |

### deal_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| stage_id | String | PK |
| pipeline_id | String | FK |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| probability | Double |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### appointment_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| appointment_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| type | String | PK |
| object_id | String |  |
| object_type | String |  |
| occurred_at | Instant |  |

### utm_analytics_overall_report

| Column | Type | Keys |
| --- | --- | --- |
| breakdown | String | PK |
| utm_type | String | PK |
| bounce_rate | Double |  |
| bounces | Long |  |
| new_visitor_session_rate | Double |  |
| pageviews_minus_exits | Long |  |
| pageviews_per_session | Double |  |
| raw_views | Long |  |
| returning_visits | Long |  |
| standard_views | Long |  |
| time | Long |  |
| time_per_session | Double |  |
| visitors | Long |  |
| visits | Long |  |

### form

| Column | Type | Keys |
| --- | --- | --- |
| guid | String | PK |
| action | String |  |
| created_at | Instant |  |
| css_class | String |  |
| follow_up_id | String |  |
| form_type | String |  |
| lead_nurturing_campaign_id | String |  |
| method | String |  |
| name | String |  |
| notify_recipients | String |  |
| portal_id | Int |  |
| redirect | String |  |
| submit_text | String |  |
| updated_at | Instant |  |

### ticket_pipeline

| Column | Type | Keys |
| --- | --- | --- |
| pipeline_id | String | PK |
| created_at | Instant |  |
| display_order | Int |  |
| label | String |  |
| updated_at | Instant |  |

### subscription_order

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| order_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### contact_list_member

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| contact_list_id | Long | PK, FK |
| added_at | Instant |  |

### company_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| from_company_id | Long | PK, FK |
| to_company_id | Long | PK, FK |
| type_id | Long | PK, FK |

### project_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| project_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| order_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### service_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| service_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription_quote

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| quote_id | Long | PK, FK |
| subscription_id | Long | PK, FK |
| type_id | Long | PK, FK |

### conversation_message_recipient

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| actor_id | String | FK |
| message_id | String | FK |
| thread_id | String | FK |
| delivery_identifier_type | String |  |
| delivery_identifier_value | String |  |
| name | String |  |
| recipient_field | String |  |

### email_subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| active | Boolean |  |
| description | String |  |
| name | String |  |
| portal_id | Long |  |

### invoice_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| invoice_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### subscription

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### ticket_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| stage_id | String | PK |
| pipeline_id | String | FK |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| ticket_state | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### payment_line_item

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| line_item_id | Long | PK, FK |
| payment_id | Long | PK, FK |
| type_id | Long | PK, FK |

### marketing_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| app_id | String |  |
| app_name | String |  |
| attendees | Long |  |
| cancellations | Long |  |
| created_at | Instant |  |
| end_date_time | Instant |  |
| event_cancelled | Boolean |  |
| event_completed | Boolean |  |
| event_description | String |  |
| event_name | String |  |
| event_organizer | String |  |
| event_status | String |  |
| event_type | String |  |
| event_url | String |  |
| external_event_id | String |  |
| no_shows | Long |  |
| registrants | Long |  |
| start_date_time | Instant |  |
| updated_at | Instant |  |

### geolocation_analytics_overall_report

| Column | Type | Keys |
| --- | --- | --- |
| breakdown | String | PK |
| bounce_rate | Double |  |
| bounces | Long |  |
| contacts | Long |  |
| contacts_per_pageview | Double |  |
| leads | Long |  |
| leads_per_view | Double |  |
| new_visitor_session_rate | Double |  |
| pageviews_minus_exits | Long |  |
| pageviews_per_session | Double |  |
| raw_views | Long |  |
| returning_visits | Long |  |
| session_to_contact_rate | Double |  |
| standard_views | Long |  |
| time | Long |  |
| time_per_session | Double |  |
| visitors | Long |  |
| visits | Long |  |

### property

| Column | Type | Keys |
| --- | --- | --- |
| hubspot_object | String | PK |
| name | String | PK |
| archived | Boolean |  |
| archived_at | Instant |  |
| calculated | Boolean |  |
| calculation_formula | String |  |
| created_at | Instant |  |
| description | String |  |
| field_type | String |  |
| group_name | String |  |
| has_unique_value | Boolean |  |
| hubspot_defined | Boolean |  |
| label | String |  |
| referenced_object_type | String |  |
| show_currency_symbol | Boolean |  |
| type | String |  |
| updated_at | Instant |  |
| updated_user_id | String |  |
| modification_metadata_** |  |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### engagement_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| type_id | Long | PK, FK |

### marketing_email_contact

| Column | Type | Keys |
| --- | --- | --- |
| contact_id | Long | PK, FK |
| marketing_email_id | Long | PK, FK |
| is_contact_included | Boolean |  |

### course_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| course_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### listing_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| listing_id | Long | PK, FK |
| type_id | Long | PK, FK |

### payment_ticket

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| payment_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### ticket_contact

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| contact_id | Long | PK, FK |
| ticket_id | Long | PK, FK |
| type_id | Long | PK, FK |

### order_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### conversation_inbox

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| active | Boolean |  |
| created_at | Instant |  |
| name | String |  |
| type | String |  |
| updated_at | Instant |  |

### discount_deal

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| deal_id | Long | PK, FK |
| discount_id | Long | PK, FK |
| type_id | Long | PK, FK |

### quote_company

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| company_id | Long | PK, FK |
| quote_id | Long | PK, FK |
| type_id | Long | PK, FK |

### goal

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |

### email_subscription_change

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| caused_by_event_id | String | FK |
| email_subscription_id | Long | FK |
| change | String |  |
| change_type | String |  |
| portal_id | Long |  |
| recipient | String |  |
| source | String |  |
| timestamp | Instant |  |

### order_engagement

| Column | Type | Keys |
| --- | --- | --- |
| category | String | PK, FK |
| engagement_id | Long | PK, FK |
| engagement_type | String | PK, FK |
| order_id | Long | PK, FK |
| type_id | Long | PK, FK |

### product_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| product_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### conversation_channel

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| name | String |  |

### cart_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| cart_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### custom_event_definition

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| type | String | PK |
| combo_event_rules | Json |  |
| created_at | Instant |  |
| created_user_id | Long |  |
| labels_plural | String |  |
| labels_singular | String |  |
| name | String |  |
| object_type_id | String |  |

### service_pipeline_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| pipeline_id | String | FK |
| archived | Boolean |  |
| created_at | Instant |  |
| display_order | Int |  |
| is_closed | Boolean |  |
| label | String |  |
| updated_at | Instant |  |
| write_permissions | String |  |

### line_item_property_history

| Column | Type | Keys |
| --- | --- | --- |
| name | String | PK |
| line_item_id | Long | PK, FK |
| source | String |  |
| source_id | String |  |
| timestamp | Instant |  |
| value | String |  |

### marketing_email_contact_list

| Column | Type | Keys |
| --- | --- | --- |
| contact_list_id | Long | PK, FK |
| marketing_email_id | Long | PK, FK |
| is_mailing_list_included | Boolean |  |

## Relationships

- team_user(team_id) → team(id)
- team_user(user_id) → users(id)
- quote_deal(quote_id) → quote(id)
- quote_deal(deal_id) → deal(deal_id)
- quote_deal(type_id) → association_type(category)
- quote_deal(category) → association_type(category)
- order_property_history(order_id) → order(id)
- email_event_delivered(id) → email_event(id)
- deal_company(deal_id) → deal(deal_id)
- deal_company(company_id) → company(id)
- deal_company(type_id) → association_type(category)
- deal_company(category) → association_type(category)
- order_contact(order_id) → order(id)
- order_contact(contact_id) → contact(id)
- order_contact(type_id) → association_type(category)
- order_contact(category) → association_type(category)
- marketing_campaign_asset(campaign_id) → marketing_campaign(id)
- course_property_history(course_id) → course(id)
- lead_property_history(lead_id) → lead(id)
- owner_team(owner_id) → owner(owner_id)
- owner_team(team_id) → team(id)
- email_event_deferred(id) → email_event(id)
- order_payment(order_id) → order(id)
- order_payment(payment_id) → payment(id)
- order_payment(type_id) → association_type(category)
- order_payment(category) → association_type(category)
- subscription_deal(subscription_id) → subscription(id)
- subscription_deal(deal_id) → deal(deal_id)
- subscription_deal(type_id) → association_type(category)
- subscription_deal(category) → association_type(category)
- lead_company(lead_id) → lead(id)
- lead_company(company_id) → company(id)
- lead_company(type_id) → association_type(category)
- lead_company(category) → association_type(category)
- feedback_submission_property_history(feedback_submission_id) → feedback_submission(id)
- goal_ticket(goal_id) → goal(id)
- goal_ticket(ticket_id) → ticket(id)
- goal_ticket(type_id) → association_type(category)
- goal_ticket(category) → association_type(category)
- email_event_spam_report(id) → email_event(id)
- lead_pipeline_stage(pipeline_id) → lead_pipeline(pipeline_id)
- payment_contact(payment_id) → payment(id)
- payment_contact(contact_id) → contact(id)
- payment_contact(type_id) → association_type(category)
- payment_contact(category) → association_type(category)
- subscription_contact(subscription_id) → subscription(id)
- subscription_contact(contact_id) → contact(id)
- subscription_contact(type_id) → association_type(category)
- subscription_contact(category) → association_type(category)
- goal_contact(goal_id) → goal(id)
- goal_contact(contact_id) → contact(id)
- goal_contact(type_id) → association_type(category)
- goal_contact(category) → association_type(category)
- listing_ticket(listing_id) → listing(id)
- listing_ticket(ticket_id) → ticket(id)
- listing_ticket(type_id) → association_type(category)
- listing_ticket(category) → association_type(category)
- project_deal(project_id) → project(id)
- project_deal(deal_id) → deal(deal_id)
- project_deal(type_id) → association_type(category)
- project_deal(category) → association_type(category)
- quote_property_history(quote_id) → quote(id)
- course_pipeline_stage(pipeline_id) → course_pipeline(id)
- cart_task(cart_id) → cart(id)
- cart_task(type_id) → association_type(category)
- cart_task(category) → association_type(category)
- activity_login(user_id) → users(id)
- cart_quote(cart_id) → cart(id)
- cart_quote(quote_id) → quote(id)
- cart_quote(type_id) → association_type(category)
- cart_quote(category) → association_type(category)
- payment_property_history(payment_id) → payment(id)
- contact_contact(from_contact_id) → contact(id)
- contact_contact(to_contact_id) → contact(id)
- contact_contact(type_id) → association_type(category)
- contact_contact(category) → association_type(category)
- cart_line_item(cart_id) → cart(id)
- cart_line_item(line_item_id) → line_item(id)
- cart_line_item(type_id) → association_type(category)
- cart_line_item(category) → association_type(category)
- custom_event_definition_association(custom_event_definition_id) → custom_event_definition(id)
- service_engagement(service_id) → service(id)
- service_engagement(engagement_type) → engagement(id)
- service_engagement(engagement_id) → engagement(id)
- service_engagement(type_id) → association_type(category)
- service_engagement(category) → association_type(category)
- sequence_enrollment(contact_id) → contact(id)
- sequence_enrollment(sequence_id) → sequence(id)
- order_feedback_submission(order_id) → order(id)
- order_feedback_submission(feedback_submission_id) → feedback_submission(id)
- order_feedback_submission(type_id) → association_type(category)
- order_feedback_submission(category) → association_type(category)
- marketing_campaign_spend_item(campaign_id) → marketing_campaign(id)
- subscription_payment(subscription_id) → subscription(id)
- subscription_payment(payment_id) → payment(id)
- subscription_payment(type_id) → association_type(category)
- subscription_payment(category) → association_type(category)
- invoice_deal(invoice_id) → invoice(id)
- invoice_deal(deal_id) → deal(deal_id)
- invoice_deal(type_id) → association_type(category)
- invoice_deal(category) → association_type(category)
- custom_event_definition_property_option(custom_event_definition_id) → custom_event_definition_property(custom_event_definition_id)
- custom_event_definition_property_option(property_name) → custom_event_definition_property(custom_event_definition_id)
- property_option(name) → property(name)
- property_option(hubspot_object) → property(hubspot_object)
- company_list_member(company_list_id) → company_list(id)
- company_list_member(company_id) → company(id)
- service_property_history(service_id) → service(id)
- deal_split(deal_id) → deal(deal_id)
- deal_split(owner_id) → owner(owner_id)
- custom_event_definition_property(custom_event_definition_id) → custom_event_definition(id)
- course_company(course_id) → course(id)
- course_company(company_id) → company(id)
- course_company(type_id) → association_type(category)
- course_company(category) → association_type(category)
- invoice_company(invoice_id) → invoice(id)
- invoice_company(company_id) → company(id)
- invoice_company(type_id) → association_type(category)
- invoice_company(category) → association_type(category)
- contact_property_history(contact_id) → contact(id)
- order_invoice(order_id) → order(id)
- order_invoice(invoice_id) → invoice(id)
- order_invoice(type_id) → association_type(category)
- order_invoice(category) → association_type(category)
- engagement_lead(engagement_id) → engagement(id)
- engagement_lead(engagement_type) → engagement(id)
- engagement_lead(lead_id) → lead(id)
- engagement_lead(type_id) → association_type(category)
- engagement_lead(category) → association_type(category)
- submission_response(form_id) → form(guid)
- submission_response(conversion_id) → contact_form_submission(contact_id)
- conversation_thread(inbox_id) → conversation_inbox(id)
- conversation_thread(associated_contact_id) → contact(id)
- conversation_thread(original_channel_account_id) → conversation_channel_account(id)
- conversation_thread(original_channel_id) → conversation_channel(id)
- conversation_thread(associated_ticket_id) → ticket(id)
- subscription_invoice(subscription_id) → subscription(id)
- subscription_invoice(invoice_id) → invoice(id)
- subscription_invoice(type_id) → association_type(category)
- subscription_invoice(category) → association_type(category)
- course_engagement(course_id) → course(id)
- course_engagement(engagement_type) → engagement(id)
- course_engagement(engagement_id) → engagement(id)
- course_engagement(type_id) → association_type(category)
- course_engagement(category) → association_type(category)
- email_event_bounce(id) → email_event(id)
- subscription_property_history(subscription_id) → subscription(id)
- project_pipeline_stage(pipeline_id) → project_pipeline(id)
- engagement_deal(engagement_id) → engagement(id)
- engagement_deal(engagement_type) → engagement(id)
- engagement_deal(deal_id) → deal(deal_id)
- engagement_deal(type_id) → association_type(category)
- engagement_deal(category) → association_type(category)
- invoice_contact(invoice_id) → invoice(id)
- invoice_contact(contact_id) → contact(id)
- invoice_contact(type_id) → association_type(category)
- invoice_contact(category) → association_type(category)
- marketing_email_campaign(campaign_id) → email_campaign(id)
- marketing_email_campaign(marketing_email_id) → marketing_email(id)
- email_event_status_change(id) → email_event(id)
- course_deal(course_id) → course(id)
- course_deal(deal_id) → deal(deal_id)
- course_deal(type_id) → association_type(category)
- course_deal(category) → association_type(category)
- subscription_ticket(subscription_id) → subscription(id)
- subscription_ticket(ticket_id) → ticket(id)
- subscription_ticket(type_id) → association_type(category)
- subscription_ticket(category) → association_type(category)
- email_event_open(id) → email_event(id)
- goal_property_history(goal_id) → goal(id)
- company_property_history(company_id) → company(id)
- project_listing(project_id) → project(id)
- project_listing(listing_id) → listing(id)
- project_listing(type_id) → association_type(category)
- project_listing(category) → association_type(category)
- tax_invoice(tax_id) → tax(id)
- tax_invoice(invoice_id) → invoice(id)
- tax_invoice(type_id) → association_type(category)
- tax_invoice(category) → association_type(category)
- deal_contact(deal_id) → deal(deal_id)
- deal_contact(contact_id) → contact(id)
- deal_contact(type_id) → association_type(category)
- deal_contact(category) → association_type(category)
- line_item_deal(line_item_id) → line_item(id)
- line_item_deal(deal_id) → deal(deal_id)
- line_item_deal(type_id) → association_type(category)
- line_item_deal(category) → association_type(category)
- discount_invoice(discount_id) → discount(id)
- discount_invoice(invoice_id) → invoice(id)
- discount_invoice(type_id) → association_type(category)
- discount_invoice(category) → association_type(category)
- lead_contact(lead_id) → lead(id)
- lead_contact(contact_id) → contact(id)
- lead_contact(type_id) → association_type(category)
- lead_contact(category) → association_type(category)
- payment_quote(payment_id) → payment(id)
- payment_quote(quote_id) → quote(id)
- payment_quote(type_id) → association_type(category)
- payment_quote(category) → association_type(category)
- order_deal(order_id) → order(id)
- order_deal(deal_id) → deal(deal_id)
- order_deal(type_id) → association_type(category)
- order_deal(category) → association_type(category)
- subscription_feedback_submission(subscription_id) → subscription(id)
- subscription_feedback_submission(feedback_submission_id) → feedback_submission(id)
- subscription_feedback_submission(type_id) → association_type(category)
- subscription_feedback_submission(category) → association_type(category)
- engagement_property_history(engagement_id) → engagement(id)
- engagement_property_history(engagement_type) → engagement(id)
- discount_order(discount_id) → discount(id)
- discount_order(order_id) → order(id)
- discount_order(type_id) → association_type(category)
- discount_order(category) → association_type(category)
- feedback_submission_ticket(feedback_submission_id) → feedback_submission(id)
- feedback_submission_ticket(ticket_id) → ticket(id)
- feedback_submission_ticket(type_id) → association_type(category)
- feedback_submission_ticket(category) → association_type(category)
- order_line_item(order_id) → order(id)
- order_line_item(line_item_id) → line_item(id)
- order_line_item(type_id) → association_type(category)
- order_line_item(category) → association_type(category)
- email_event_forward(id) → email_event(id)
- cart_discount(cart_id) → cart(id)
- cart_discount(discount_id) → discount(id)
- cart_discount(type_id) → association_type(category)
- cart_discount(category) → association_type(category)
- goal_deal(goal_id) → goal(id)
- goal_deal(deal_id) → deal(deal_id)
- goal_deal(type_id) → association_type(category)
- goal_deal(category) → association_type(category)
- goal_company(goal_id) → goal(id)
- goal_company(company_id) → company(id)
- goal_company(type_id) → association_type(category)
- goal_company(category) → association_type(category)
- service_company(service_id) → service(id)
- service_company(company_id) → company(id)
- service_company(type_id) → association_type(category)
- service_company(category) → association_type(category)
- cart_contact(cart_id) → cart(id)
- cart_contact(contact_id) → contact(id)
- cart_contact(type_id) → association_type(category)
- cart_contact(category) → association_type(category)
- ticket_engagement(ticket_id) → ticket(id)
- ticket_engagement(engagement_type) → engagement(id)
- ticket_engagement(engagement_id) → engagement(id)
- ticket_engagement(type_id) → association_type(category)
- ticket_engagement(category) → association_type(category)
- email_event(email_campaign_id) → email_campaign(id)
- cart_ticket(cart_id) → cart(id)
- cart_ticket(ticket_id) → ticket(id)
- cart_ticket(type_id) → association_type(category)
- cart_ticket(category) → association_type(category)
- contact_form_submission(contact_id) → contact(id)
- contact_form_submission(form_id) → form(guid)
- marketing_campaign_contact(campaign_id) → marketing_campaign(id)
- marketing_campaign_contact(contact_id) → contact(id)
- tax_quote(tax_id) → tax(id)
- tax_quote(quote_id) → quote(id)
- tax_quote(type_id) → association_type(category)
- tax_quote(category) → association_type(category)
- lead_deal(lead_id) → lead(id)
- lead_deal(deal_id) → deal(deal_id)
- lead_deal(type_id) → association_type(category)
- lead_deal(category) → association_type(category)
- quote_contact(quote_id) → quote(id)
- quote_contact(contact_id) → contact(id)
- quote_contact(type_id) → association_type(category)
- quote_contact(category) → association_type(category)
- audit_log(acting_user_id) → users(id)
- cart_order(cart_id) → cart(id)
- cart_order(order_id) → order(id)
- cart_order(type_id) → association_type(category)
- cart_order(category) → association_type(category)
- fee_invoice(fee_id) → fee(id)
- fee_invoice(invoice_id) → invoice(id)
- fee_invoice(type_id) → association_type(category)
- fee_invoice(category) → association_type(category)
- listing_contact(listing_id) → listing(id)
- listing_contact(contact_id) → contact(id)
- listing_contact(type_id) → association_type(category)
- listing_contact(category) → association_type(category)
- order_ticket(order_id) → order(id)
- order_ticket(ticket_id) → ticket(id)
- order_ticket(type_id) → association_type(category)
- order_ticket(category) → association_type(category)
- feedback_submission_contact(feedback_submission_id) → feedback_submission(id)
- feedback_submission_contact(contact_id) → contact(id)
- feedback_submission_contact(type_id) → association_type(category)
- feedback_submission_contact(category) → association_type(category)
- marketing_event_custom_property(marketing_event_id) → marketing_event(id)
- project_service(project_id) → project(id)
- project_service(service_id) → service(id)
- project_service(type_id) → association_type(category)
- project_service(category) → association_type(category)
- discount_property_history(discount_id) → discount(id)
- ticket_property_history(ticket_id) → ticket(id)
- email_event_suppressed(id) → email_event(id)
- merged_deal(deal_id) → deal(deal_id)
- merged_deal(merged_deal_id) → deal(deal_id)
- tax_payment(tax_id) → tax(id)
- tax_payment(payment_id) → payment(id)
- tax_payment(type_id) → association_type(category)
- tax_payment(category) → association_type(category)
- quote_line_item(quote_id) → quote(id)
- quote_line_item(line_item_id) → line_item(id)
- quote_line_item(type_id) → association_type(category)
- quote_line_item(category) → association_type(category)
- ticket_ticket(from_ticket_id) → ticket(id)
- ticket_ticket(to_ticket_id) → ticket(id)
- ticket_ticket(type_id) → association_type(category)
- ticket_ticket(category) → association_type(category)
- listing_engagement(listing_id) → listing(id)
- listing_engagement(engagement_type) → engagement(id)
- listing_engagement(engagement_id) → engagement(id)
- listing_engagement(type_id) → association_type(category)
- listing_engagement(category) → association_type(category)
- listing_company(listing_id) → listing(id)
- listing_company(company_id) → company(id)
- listing_company(type_id) → association_type(category)
- listing_company(category) → association_type(category)
- course_contact(course_id) → course(id)
- course_contact(contact_id) → contact(id)
- course_contact(type_id) → association_type(category)
- course_contact(category) → association_type(category)
- activity_security(user_id) → users(id)
- marketing_campaign_budget_item(campaign_id) → marketing_campaign(id)
- subscription_line_item(subscription_id) → subscription(id)
- subscription_line_item(line_item_id) → line_item(id)
- subscription_line_item(type_id) → association_type(category)
- subscription_line_item(category) → association_type(category)
- listing_property_history(listing_id) → listing(id)
- project_property_history(project_id) → project(id)
- payment_company(payment_id) → payment(id)
- payment_company(company_id) → company(id)
- payment_company(type_id) → association_type(category)
- payment_company(category) → association_type(category)
- listing_pipeline_stage(pipeline_id) → listing_pipeline(id)
- project_contact(project_id) → project(id)
- project_contact(contact_id) → contact(id)
- project_contact(type_id) → association_type(category)
- project_contact(category) → association_type(category)
- contact_company(contact_id) → contact(id)
- contact_company(company_id) → company(id)
- contact_company(type_id) → association_type(category)
- contact_company(category) → association_type(category)
- sequence(user_id) → users(id)
- ticket_deal(ticket_id) → ticket(id)
- ticket_deal(deal_id) → deal(deal_id)
- ticket_deal(type_id) → association_type(category)
- ticket_deal(category) → association_type(category)
- discount_payment(discount_id) → discount(id)
- discount_payment(payment_id) → payment(id)
- discount_payment(type_id) → association_type(category)
- discount_payment(category) → association_type(category)
- conversation_message_sender(actor_id) → conversation_actor(id)
- conversation_message_sender(message_id) → conversation_message_history(id)
- conversation_message_sender(thread_id) → conversation_thread(id)
- service_deal(service_id) → service(id)
- service_deal(deal_id) → deal(deal_id)
- service_deal(type_id) → association_type(category)
- service_deal(category) → association_type(category)
- email_event_click(id) → email_event(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice_line_item(line_item_id) → line_item(id)
- invoice_line_item(type_id) → association_type(category)
- invoice_line_item(category) → association_type(category)
- service_contact(service_id) → service(id)
- service_contact(contact_id) → contact(id)
- service_contact(type_id) → association_type(category)
- service_contact(category) → association_type(category)
- fee_quote(fee_id) → fee(id)
- fee_quote(quote_id) → quote(id)
- fee_quote(type_id) → association_type(category)
- fee_quote(category) → association_type(category)
- conversation_channel_account(channel_id) → conversation_channel(id)
- conversation_channel_account(inbox_id) → conversation_inbox(id)
- tax_property_history(tax_id) → tax(id)
- email_event_print(id) → email_event(id)
- discount_quote(discount_id) → discount(id)
- discount_quote(quote_id) → quote(id)
- discount_quote(type_id) → association_type(category)
- discount_quote(category) → association_type(category)
- line_item(product_id) → product(id)
- users(role_id) → role(id)
- users(primary_team_id) → team(id)
- deal_deal(from_deal_id) → deal(deal_id)
- deal_deal(to_deal_id) → deal(deal_id)
- deal_deal(type_id) → association_type(category)
- deal_deal(category) → association_type(category)
- marketing_event_participant(contact_id) → contact(id)
- marketing_event_participant(marketing_event_id) → marketing_event(id)
- fee_property_history(fee_id) → fee(id)
- order_pipeline_stage(pipeline_id) → order_pipeline(id)
- payment_deal(payment_id) → payment(id)
- payment_deal(deal_id) → deal(deal_id)
- payment_deal(type_id) → association_type(category)
- payment_deal(category) → association_type(category)
- invoice_property_history(invoice_id) → invoice(id)
- deal_property_history(deal_id) → deal(deal_id)
- project_company(project_id) → project(id)
- project_company(company_id) → company(id)
- project_company(type_id) → association_type(category)
- project_company(category) → association_type(category)
- engagement_goal(engagement_id) → engagement(id)
- engagement_goal(engagement_type) → engagement(id)
- engagement_goal(goal_id) → goal(id)
- engagement_goal(type_id) → association_type(category)
- engagement_goal(category) → association_type(category)
- engagement_contact(engagement_id) → engagement(id)
- engagement_contact(engagement_type) → engagement(id)
- engagement_contact(contact_id) → contact(id)
- engagement_contact(type_id) → association_type(category)
- engagement_contact(category) → association_type(category)
- deal_stage(deal_id) → deal(deal_id)
- marketing_email(campaign) → marketing_campaign(id)
- marketing_email(subscription_id) → email_subscription(id)
- conversation_message_history(channel_account_id) → conversation_channel_account(id)
- conversation_message_history(channel_id) → conversation_channel(id)
- conversation_message_history(from_inbox_id) → conversation_inbox(id)
- conversation_message_history(to_inbox_id) → conversation_inbox(id)
- conversation_message_history(thread_id) → conversation_thread(id)
- email_event_dropped(id) → email_event(id)
- course_project(course_id) → course(id)
- course_project(project_id) → project(id)
- course_project(type_id) → association_type(category)
- course_project(category) → association_type(category)
- payment_invoice(payment_id) → payment(id)
- payment_invoice(invoice_id) → invoice(id)
- payment_invoice(type_id) → association_type(category)
- payment_invoice(category) → association_type(category)
- subscription_company(subscription_id) → subscription(id)
- subscription_company(company_id) → company(id)
- subscription_company(type_id) → association_type(category)
- subscription_company(category) → association_type(category)
- ticket_company(ticket_id) → ticket(id)
- ticket_company(company_id) → company(id)
- ticket_company(type_id) → association_type(category)
- ticket_company(category) → association_type(category)
- marketing_event_list(marketing_event_id) → marketing_event(id)
- marketing_event_list(created_by_id) → contact(id)
- discount_line_item(discount_id) → discount(id)
- discount_line_item(line_item_id) → line_item(id)
- discount_line_item(type_id) → association_type(category)
- discount_line_item(category) → association_type(category)
- project_ticket(project_id) → project(id)
- project_ticket(ticket_id) → ticket(id)
- project_ticket(type_id) → association_type(category)
- project_ticket(category) → association_type(category)
- email_event_sent(id) → email_event(id)
- fee_payment(fee_id) → fee(id)
- fee_payment(payment_id) → payment(id)
- fee_payment(type_id) → association_type(category)
- fee_payment(category) → association_type(category)
- custom_event(type) → custom_event_definition(id)
- deal_pipeline_stage(pipeline_id) → deal_pipeline(pipeline_id)
- appointment_property_history(appointment_id) → appointment(id)
- subscription_order(subscription_id) → subscription(id)
- subscription_order(order_id) → order(id)
- subscription_order(type_id) → association_type(category)
- subscription_order(category) → association_type(category)
- contact_list_member(contact_list_id) → contact_list(id)
- contact_list_member(contact_id) → contact(id)
- company_company(from_company_id) → company(id)
- company_company(to_company_id) → company(id)
- company_company(type_id) → association_type(category)
- company_company(category) → association_type(category)
- project_engagement(project_id) → project(id)
- project_engagement(engagement_type) → engagement(id)
- project_engagement(engagement_id) → engagement(id)
- project_engagement(type_id) → association_type(category)
- project_engagement(category) → association_type(category)
- order_quote(order_id) → order(id)
- order_quote(quote_id) → quote(id)
- order_quote(type_id) → association_type(category)
- order_quote(category) → association_type(category)
- service_ticket(service_id) → service(id)
- service_ticket(ticket_id) → ticket(id)
- service_ticket(type_id) → association_type(category)
- service_ticket(category) → association_type(category)
- subscription_quote(subscription_id) → subscription(id)
- subscription_quote(quote_id) → quote(id)
- subscription_quote(type_id) → association_type(category)
- subscription_quote(category) → association_type(category)
- conversation_message_recipient(actor_id) → conversation_actor(id)
- conversation_message_recipient(message_id) → conversation_message_history(id)
- conversation_message_recipient(thread_id) → conversation_thread(id)
- invoice_ticket(invoice_id) → invoice(id)
- invoice_ticket(ticket_id) → ticket(id)
- invoice_ticket(type_id) → association_type(category)
- invoice_ticket(category) → association_type(category)
- ticket_pipeline_stage(pipeline_id) → ticket_pipeline(pipeline_id)
- payment_line_item(payment_id) → payment(id)
- payment_line_item(line_item_id) → line_item(id)
- payment_line_item(type_id) → association_type(category)
- payment_line_item(category) → association_type(category)
- engagement_company(engagement_id) → engagement(id)
- engagement_company(engagement_type) → engagement(id)
- engagement_company(company_id) → company(id)
- engagement_company(type_id) → association_type(category)
- engagement_company(category) → association_type(category)
- marketing_email_contact(contact_id) → contact(id)
- marketing_email_contact(marketing_email_id) → marketing_email(id)
- course_ticket(course_id) → course(id)
- course_ticket(ticket_id) → ticket(id)
- course_ticket(type_id) → association_type(category)
- course_ticket(category) → association_type(category)
- listing_deal(listing_id) → listing(id)
- listing_deal(deal_id) → deal(deal_id)
- listing_deal(type_id) → association_type(category)
- listing_deal(category) → association_type(category)
- payment_ticket(payment_id) → payment(id)
- payment_ticket(ticket_id) → ticket(id)
- payment_ticket(type_id) → association_type(category)
- payment_ticket(category) → association_type(category)
- ticket_contact(ticket_id) → ticket(id)
- ticket_contact(contact_id) → contact(id)
- ticket_contact(type_id) → association_type(category)
- ticket_contact(category) → association_type(category)
- order_company(order_id) → order(id)
- order_company(company_id) → company(id)
- order_company(type_id) → association_type(category)
- order_company(category) → association_type(category)
- discount_deal(discount_id) → discount(id)
- discount_deal(deal_id) → deal(deal_id)
- discount_deal(type_id) → association_type(category)
- discount_deal(category) → association_type(category)
- quote_company(quote_id) → quote(id)
- quote_company(company_id) → company(id)
- quote_company(type_id) → association_type(category)
- quote_company(category) → association_type(category)
- email_subscription_change(caused_by_event_id) → email_event(id)
- email_subscription_change(email_subscription_id) → email_subscription(id)
- order_engagement(order_id) → order(id)
- order_engagement(engagement_type) → engagement(id)
- order_engagement(engagement_id) → engagement(id)
- order_engagement(type_id) → association_type(category)
- order_engagement(category) → association_type(category)
- product_property_history(product_id) → product(id)
- cart_property_history(cart_id) → cart(id)
- service_pipeline_stage(pipeline_id) → service_pipeline(id)
- line_item_property_history(line_item_id) → line_item(id)
- marketing_email_contact_list(contact_list_id) → contact_list(id)
- marketing_email_contact_list(marketing_email_id) → marketing_email(id)