# Planhat schema ERD

Table and field reference for the Fivetran Planhat connector.

## Table & Field Reference

### workspace

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| owner_id | Unknown | FK |
| external_id | Unknown |  |
| name | Unknown |  |
| source_id | Unknown |  |
| usage | Json |  |
| custom_** |  |  |

### churn_reason

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| churn_id | Unknown | PK, FK |
| reason | Unknown |  |

### churn_product

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| churn_id | Unknown | PK, FK |
| product | Unknown |  |

### churn

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| license_id | Unknown | FK |
| arr | Unknown |  |
| churn_date | Instant |  |
| comment | Unknown |  |
| currency | Unknown |  |
| last_updated | Unknown |  |
| replacement | Unknown |  |
| snoozed | Unknown |  |
| source_id | Unknown |  |
| value | Unknown |  |
| custom_** |  |  |

### project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| arr | Unknown |  |
| currency | Unknown |  |
| end_date | Unknown |  |
| external_id | Unknown |  |
| mrr | Unknown |  |
| name | Unknown |  |
| nrr | Unknown |  |
| source_id | Unknown |  |
| start_date | Unknown |  |
| custom_** |  |  |

### objective

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| external_id | Unknown |  |
| health | Unknown |  |
| name | Unknown |  |
| source_id | Unknown |  |
| usage | Json |  |
| custom_** |  |  |

### company_csm_score_log

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| date | Unknown |  |
| score | Unknown |  |

### company_domain

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| domain | Unknown |  |

### company_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| company_id | Unknown | PK, FK |
| tags | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| co_owner | Unknown | FK |
| owner | Unknown | FK |
| address | Unknown |  |
| alerts | Json |  |
| arr | Unknown |  |
| arr_total | Unknown |  |
| auto_renew | Unknown |  |
| city | Unknown |  |
| collaborators | Json |  |
| country | Unknown |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| csm_score | Unknown |  |
| customer_from | Unknown |  |
| customer_to | Unknown |  |
| days_in_phase | Unknown |  |
| description | Unknown |  |
| documents | Json |  |
| external_id | Unknown |  |
| features | Json |  |
| followers | Json |  |
| h | Unknown |  |
| h_diff | Unknown |  |
| h_diff_date | Unknown |  |
| h_profile | Unknown |  |
| head_id | Unknown |  |
| last_performed_triggers | Json |  |
| last_renewal | Unknown |  |
| last_touch | Unknown |  |
| last_touch_by_type_catch_up | Unknown |  |
| last_touch_by_type_delivery_review | Unknown |  |
| last_touch_by_type_email | Unknown |  |
| last_touch_by_type_sales_handover | Unknown |  |
| last_touch_by_type_training | Unknown |  |
| last_touch_type | Unknown |  |
| last_updated | Unknown |  |
| licenses | Json |  |
| links | Json |  |
| mr | Unknown |  |
| mr_total | Unknown |  |
| mrr | Unknown |  |
| mrr_total | Unknown |  |
| name | Unknown |  |
| next_touch | Unknown |  |
| nrr_30 | Unknown |  |
| nrr_total | Unknown |  |
| org_arr | Unknown |  |
| org_arr_total | Unknown |  |
| org_health_total | Unknown |  |
| org_level | Unknown |  |
| org_mrr | Unknown |  |
| org_mrr_total | Unknown |  |
| org_path | Unknown |  |
| org_root_id | Unknown |  |
| org_unit | Unknown |  |
| phase | Unknown |  |
| phase_since | Unknown |  |
| phone_primary | Unknown |  |
| products | Json |  |
| renewal_arr | Unknown |  |
| renewal_date | Unknown |  |
| renewal_days_from_now | Unknown |  |
| renewal_mrr | Unknown |  |
| sales | Json |  |
| shareable_enabled | Unknown |  |
| shareable_eu_ids | Json |  |
| shareable_sunits | Unknown |  |
| shareable_teams_fields | Json |  |
| slug | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| sunits | Json |  |
| updated_at | Instant |  |
| usage | Json |  |
| web | Unknown |  |
| zip | Unknown |  |
| custom_** |  |  |

### conversation_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| is_owner | Unknown |  |

### conversation_end_user

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| end_user_id | Unknown | FK |

### conversation_time_bucket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| time_bucket | Unknown |  |

### conversation_document

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| conversation_id | Unknown | PK, FK |
| document | Unknown |  |

### conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| task_id | Unknown | FK |
| activity_tags | Json |  |
| archived | Unknown |  |
| assignee_name | Unknown |  |
| auto_tags | Json |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| day | Unknown |  |
| description | Unknown |  |
| email_template_ids | Json |  |
| followers | Json |  |
| has_attachment | Unknown |  |
| has_more | Unknown |  |
| history | Unknown |  |
| is_custom_type | Unknown |  |
| is_open | Unknown |  |
| is_seen | Unknown |  |
| number_of_part | Unknown |  |
| number_of_relevant_part | Unknown |  |
| out_date | Unknown |  |
| pinned | Unknown |  |
| sender | Unknown |  |
| snippet | Unknown |  |
| source | Unknown |  |
| starred | Unknown |  |
| subject | Unknown |  |
| tags | Json |  |
| type | Unknown |  |
| updated_at | Instant |  |
| waits_to_be_filtered | Unknown |  |
| custom_** |  |  |

### issue_company

| Column | Type | Keys |
| --- | --- | --- |
| company_id | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |

### issue_end_user

| Column | Type | Keys |
| --- | --- | --- |
| end_user_id | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |

### issue_conversation

| Column | Type | Keys |
| --- | --- | --- |
| conversation_id | Unknown | PK, FK |
| issue_id | Unknown | PK, FK |

### issue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived | Unknown |  |
| arr_combined | Unknown |  |
| company_matching_value | Json |  |
| created_at | Unknown |  |
| description | Unknown |  |
| mrr_combined | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### ticket_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| status | Unknown |  |
| time | Unknown |  |

### ticket_time_bucket

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| ticket_id | Unknown | PK, FK |
| time_bucket | Unknown |  |

### ticket_end_user

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

### ticket

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| activity_tags | Json |  |
| archived | Unknown |  |
| company_external_id | Unknown |  |
| create_date | Unknown |  |
| date | Unknown |  |
| days | Unknown |  |
| description | Unknown |  |
| domains | Json |  |
| email | Unknown |  |
| email_template_ids | Json |  |
| external_id | Unknown |  |
| in_date | Unknown |  |
| is_open | Unknown |  |
| pinned | Unknown |  |
| product | Unknown |  |
| sender | Json |  |
| severity | Unknown |  |
| snippet | Unknown |  |
| source | Unknown |  |
| source_id | Unknown |  |
| starred | Unknown |  |
| status | Unknown |  |
| sub_type | Unknown |  |
| subject | Unknown |  |
| tags | Json |  |
| time_spent | Unknown |  |
| title | Unknown |  |
| type | Unknown |  |
| update_date | Instant |  |
| url | Unknown |  |
| users | Json |  |
| waits_to_be_filtered | Unknown |  |
| custom_** |  |  |

### opportunity_stage_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| stage | Unknown |  |
| tos | Unknown |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| owner_id | Unknown | FK |
| arr | Unknown |  |
| close_date | Unknown |  |
| contract_length | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| deal_date | Unknown |  |
| external_id | Unknown |  |
| followers | Json |  |
| landing_date | Unknown |  |
| last_comment | Unknown |  |
| mrr | Unknown |  |
| nrr | Unknown |  |
| probability | Unknown |  |
| sales_stage | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### users_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | Unknown | PK, FK |
| description | Unknown |  |
| name | Unknown |  |

### users_poc

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| poc | Unknown |  |

### users_team

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

### users_google_api_synced_label

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| synced_label | Unknown |  |

### users_google_calendar_api_synced_calendar

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| synced_calendar | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_access | Unknown |  |
| apply_permission | Unknown |  |
| arr | Unknown |  |
| arr_avg | Unknown |  |
| calendar_date_scope | Unknown |  |
| comments_sort | Unknown |  |
| compressed_view | Unknown |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| daily_digest | Unknown |  |
| default_meeting_length | Unknown |  |
| email | Unknown |  |
| email_signature_content | Unknown |  |
| email_signature_enabled | Unknown |  |
| first_name | Unknown |  |
| follower_update | Unknown |  |
| followers | Json |  |
| google_api_access_enabled | Unknown |  |
| google_api_sync_enabled | Unknown |  |
| google_api_sync_initial | Unknown |  |
| google_api_user_id | Unknown |  |
| google_calendar_api_access_enabled | Unknown |  |
| google_calendar_api_calendar_to_save | Json |  |
| google_calendar_api_sync_enabled | Unknown |  |
| google_calendar_api_sync_initial | Unknown |  |
| google_calendar_api_user_id | Unknown |  |
| health_avg | Unknown |  |
| health_avg_round | Unknown |  |
| health_count | Unknown |  |
| image_path | Unknown |  |
| image_spaces_key | Unknown |  |
| in_app_notification | Unknown |  |
| inactive | Unknown |  |
| intercom_admin_id | Unknown |  |
| invoices_sort | Unknown |  |
| is_exposed_as_sender_option | Unknown |  |
| is_hidden | Unknown |  |
| labels | Json |  |
| last_active_30 | Unknown |  |
| last_active_7 | Unknown |  |
| last_active_90 | Unknown |  |
| last_daily_digest | Unknown |  |
| last_name | Unknown |  |
| last_touch_30 | Unknown |  |
| last_touch_7 | Unknown |  |
| last_touch_90 | Unknown |  |
| last_visited_views | Json |  |
| last_visited_workspaces | Json |  |
| managers | Json |  |
| mrr | Unknown |  |
| mrr_avg | Unknown |  |
| ms_api_access_enabled | Unknown |  |
| ms_api_sync_enabled | Unknown |  |
| ms_api_sync_initial | Unknown |  |
| ms_api_synced_labels | Json |  |
| ms_calendar_api_access_enabled | Unknown |  |
| ms_calendar_api_calendar_to_save | Json |  |
| ms_calendar_api_sync_enabled | Unknown |  |
| ms_calendar_api_sync_initial | Unknown |  |
| ms_calendar_api_synced_calendars | Json |  |
| nick_name | Unknown |  |
| notifications_enabled | Unknown |  |
| nps_avg | Unknown |  |
| nps_count | Unknown |  |
| nr_open_task | Unknown |  |
| nr_overdue_task | Unknown |  |
| nr_tasks_due_14_day | Unknown |  |
| nr_tasks_due_30_day | Unknown |  |
| nr_tasks_due_7_day | Unknown |  |
| nr_tasks_due_90_day | Unknown |  |
| paying_customer_count | Unknown |  |
| permission | Json |  |
| play_log_disabled | Unknown |  |
| playlist_section | Unknown |  |
| preview_modal_width | Unknown |  |
| radar_one_line | Unknown |  |
| recent_open_shared_view | Unknown |  |
| removed | Unknown |  |
| rev_report_period_type | Unknown |  |
| revenue_share | Unknown |  |
| slack_id | Unknown |  |
| split_layout_disabled | Unknown |  |
| task_actions_pref_view_mode | Unknown |  |
| task_filter | Unknown |  |
| top_bar_pins | Json |  |
| two_factor_auth_enabled | Unknown |  |
| type | Unknown |  |
| tz_offset | Unknown |  |
| undefined | Unknown |  |
| updated_at | Instant |  |
| usage_metrics_from_b_q | Unknown |  |
| work_spaces_prefs | Json |  |
| ws_saved_pages | Json |  |
| custom_** |  |  |
| table_group_collapsed_** |  |  |

### nps

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| campaign_id | Unknown | FK |
| company_id | Unknown | FK |
| comment | Unknown |  |
| date | Instant |  |
| date_answered | Unknown |  |
| date_reminder_sent | Unknown |  |
| date_sent | Unknown |  |
| email | Unknown |  |
| nps | Unknown |  |
| nps_id | Unknown |  |
| score | Unknown |  |
| score_type | Unknown |  |
| sent | Unknown |  |
| source | Unknown |  |
| source_id | Unknown |  |
| custom_** |  |  |

### license

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| arr | Unknown |  |
| auto_renew | Unknown |  |
| auto_renewed | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| external_id | Unknown |  |
| fc_new_arr | Unknown |  |
| fc_new_arr_optimistic | Unknown |  |
| fc_new_arr_pessimistic | Unknown |  |
| fc_new_mrr | Unknown |  |
| fc_new_mrr_pessimistic | Unknown |  |
| fixed_period | Unknown |  |
| from_date | Unknown |  |
| invoice_cycle | Unknown |  |
| invoice_cycle_interval | Unknown |  |
| invoice_muted | Unknown |  |
| is_overdue | Unknown |  |
| issue | Unknown |  |
| length | Unknown |  |
| mrr | Unknown |  |
| notice_period | Unknown |  |
| notice_unit | Unknown |  |
| parent | Unknown |  |
| product | Unknown |  |
| renewal_arr | Unknown |  |
| renewal_date | Unknown |  |
| renewal_days_from_now | Unknown |  |
| renewal_mrr | Unknown |  |
| renewal_period | Unknown |  |
| renewal_status | Unknown |  |
| renewal_unit | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| to_date | Unknown |  |
| to_date_included | Unknown |  |
| updated_at | Instant |  |
| value | Unknown |  |
| custom_** |  |  |

### sale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| currency | Unknown |  |
| external_id | Unknown |  |
| product | Unknown |  |
| sales_date | Unknown |  |
| source_id | Unknown |  |
| value | Unknown |  |
| custom_** |  |  |

### task_end_user

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

### task_user

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

### task_activity_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| task_id | Unknown | PK, FK |
| activity_tag | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| owner_id | Unknown | FK |
| action | Unknown |  |
| checklist | Json |  |
| created_at | Unknown |  |
| date_done | Unknown |  |
| description | Unknown |  |
| done_by | Unknown |  |
| end_time | Unknown |  |
| followers | Json |  |
| i_cal_u_id | Unknown |  |
| is_archived | Unknown |  |
| location | Unknown |  |
| main_type | Unknown |  |
| no_specific_time | Unknown |  |
| over_due_notified | Unknown |  |
| repeat | Unknown |  |
| repeat_day | Unknown |  |
| shared | Unknown |  |
| snippet | Unknown |  |
| source | Unknown |  |
| source_id | Unknown |  |
| source_parent_id | Unknown |  |
| source_url | Unknown |  |
| start_time | Unknown |  |
| status | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### end_user_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| end_user_id | Unknown | PK, FK |
| tags | Unknown |  |

### end_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| beat_trend | Unknown |  |
| beats | Unknown |  |
| beats_total | Unknown |  |
| company_external_id | Unknown |  |
| convs_14 | Unknown |  |
| convs_total | Unknown |  |
| create_date | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| email | Unknown |  |
| email_md_5 | Unknown |  |
| experience | Unknown |  |
| external_id | Unknown |  |
| featured | Unknown |  |
| first_name | Unknown |  |
| last_active | Unknown |  |
| last_name | Unknown |  |
| last_touch | Unknown |  |
| last_touch_by_type_design_call | Unknown |  |
| last_touch_by_type_email | Unknown |  |
| last_touch_by_type_kick_off | Unknown |  |
| last_touch_by_type_note | Unknown |  |
| last_touch_by_type_technical_call | Unknown |  |
| last_touch_by_type_technical_life_lesson | Unknown |  |
| last_touch_type | Unknown |  |
| last_updated | Unknown |  |
| name | Unknown |  |
| nps_sent | Unknown |  |
| nps_unsubscribed | Unknown |  |
| other_emails | Json |  |
| phone | Unknown |  |
| position | Unknown |  |
| related_end_users | Json |  |
| relevance | Unknown |  |
| relevance_rate | Unknown |  |
| shared_notifications_prefs_disabled | Json |  |
| shared_notifications_prefs_disabled_event | Json |  |
| shared_notifications_prefs_enabled | Json |  |
| source_id | Unknown |  |
| updated_at | Instant |  |
| custom_** |  |  |

### campaign

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| external_id | Unknown |  |
| name | Unknown |  |
| purpose | Unknown |  |
| source_id | Unknown |  |
| custom_** |  |  |

### invoice_line_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| license_id | Unknown | FK |
| amount | Unknown |  |
| date_from | Unknown |  |
| date_to | Unknown |  |
| product | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| address_country | Unknown |  |
| amount_due | Unknown |  |
| amount_paid | Unknown |  |
| amount_total | Unknown |  |
| currency | Unknown |  |
| cycle | Unknown |  |
| date | Instant |  |
| due_date | Unknown |  |
| emails | Json |  |
| ext_id | Unknown |  |
| last_updated | Unknown |  |
| number | Unknown |  |
| paid_date | Unknown |  |
| product | Unknown |  |
| source_id | Unknown |  |
| status | Unknown |  |
| custom_** |  |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| external_id | Unknown |  |
| name | Unknown |  |
| source_id | Unknown |  |
| custom_** |  |  |

## Relationships

- workspace(owner_id) → users(id)
- workspace(company_id) → company(id)
- churn_reason(churn_id) → churn(id)
- churn_product(churn_id) → churn(id)
- churn(license_id) → license(id)
- churn(company_id) → company(id)
- project(company_id) → company(id)
- objective(company_id) → company(id)
- company_csm_score_log(company_id) → company(id)
- company_domain(company_id) → company(id)
- company_tag(company_id) → company(id)
- company(owner) → users(id)
- company(co_owner) → users(id)
- conversation_user(user_id) → users(id)
- conversation_user(conversation_id) → conversation(id)
- conversation_end_user(end_user_id) → end_user(id)
- conversation_end_user(conversation_id) → conversation(id)
- conversation_time_bucket(conversation_id) → conversation(id)
- conversation_document(conversation_id) → conversation(id)
- conversation(task_id) → task(id)
- conversation(company_id) → company(id)
- issue_company(company_id) → company(id)
- issue_company(issue_id) → issue(id)
- issue_end_user(end_user_id) → end_user(id)
- issue_end_user(issue_id) → issue(id)
- issue_conversation(conversation_id) → conversation(id)
- issue_conversation(issue_id) → issue(id)
- ticket_history(ticket_id) → ticket(id)
- ticket_time_bucket(ticket_id) → ticket(id)
- ticket_end_user(end_user_id) → end_user(id)
- ticket_end_user(ticket_id) → ticket(id)
- ticket(company_id) → company(id)
- opportunity_stage_history(opportunity_id) → opportunity(id)
- opportunity(owner_id) → users(id)
- opportunity(company_id) → company(id)
- users_role(user_id) → users(id)
- users_poc(user_id) → users(id)
- users_team(user_id) → users(id)
- users_google_api_synced_label(user_id) → users(id)
- users_google_calendar_api_synced_calendar(user_id) → users(id)
- nps(campaign_id) → campaign(id)
- nps(company_id) → company(id)
- license(company_id) → company(id)
- sale(company_id) → company(id)
- task_end_user(end_user_id) → end_user(id)
- task_end_user(task_id) → task(id)
- task_user(user_id) → users(id)
- task_user(task_id) → task(id)
- task_activity_tag(task_id) → task(id)
- task(owner_id) → users(id)
- task(company_id) → company(id)
- end_user_tag(end_user_id) → end_user(id)
- end_user(company_id) → company(id)
- campaign(company_id) → company(id)
- invoice_line_item(license_id) → license(id)
- invoice_line_item(invoice_id) → invoice(id)
- invoice(company_id) → company(id)
- asset(company_id) → company(id)