# Clari schema ERD

Table and field reference for the Fivetran Clari connector.

## Table & Field Reference

### opportunity_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| alias | Unknown |  |
| image_url | Unknown |  |
| trend | Unknown |  |

### opportunity_trend_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| opportunity_id | Unknown | PK, FK |
| date | Unknown |  |
| new_value | Unknown |  |
| old_value | Unknown |  |

### opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| crm_score | Unknown |  |
| crm_score_message | Unknown |  |

### item

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| actor_id | Unknown |  |
| actor_type | Unknown |  |
| correlation_id | Unknown |  |
| event | Unknown |  |
| event_parameters | Unknown |  |
| event_timestamp_epoch_second | Unknown |  |
| event_timestamp_nano | Unknown |  |
| impersonating_actor_id | Unknown |  |
| ip_address | Unknown |  |
| session_id | Unknown |  |
| session_type | Unknown |  |

### actor

| Column | Type | Keys |
| --- | --- | --- |
| actor_id | Unknown | PK, FK |
| actor_type | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |

### administrative

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| available_concurrent_limit | Unknown |  |
| available_monthly_quota | Unknown |  |
| concurrent_limit | Unknown |  |
| monthly_quota | Unknown |  |
| running_job_ids | Json |  |
| submitted_job_ids | Json |  |

### time_frame

| Column | Type | Keys |
| --- | --- | --- |
| forecast_id | String | PK |
| forecast_type | Unknown | PK |
| time_frame_id | Unknown | PK |
| end_date | Unknown |  |
| start_date | Unknown |  |

### forecast_entry

| Column | Type | Keys |
| --- | --- | --- |
| forecast_id | String | PK |
| forecast_type | Unknown | PK |
| field_id | Unknown | PK, FK |
| time_frame_id | Unknown | PK, FK |
| time_period_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| adjusted_by | Unknown |  |
| adjusted_on | Unknown |  |
| adjustment_value | Unknown |  |
| aggregation_total | Unknown |  |
| currency_code | Unknown |  |
| currency_symbol | Unknown |  |
| forecast_value | Unknown |  |
| is_updated | Unknown |  |
| quota_value | Unknown |  |
| updated_by | Unknown |  |
| updated_on | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| forecast_id | String | PK |
| forecast_type | Unknown | PK |
| user_id | Unknown | PK |
| crm_id | Unknown |  |
| email | Unknown |  |
| hierarchy_id | Unknown |  |
| hierarchy_name | Unknown |  |
| name | Unknown |  |
| parent_hierarchy_id | Unknown |  |
| parent_hierarchy_name | Unknown |  |
| scope_id | Unknown |  |

### field

| Column | Type | Keys |
| --- | --- | --- |
| field_id | Unknown | PK |
| forecast_id | String | PK |
| forecast_type | Unknown | PK |
| field_name | Unknown |  |
| field_type | Unknown |  |

### time_period

| Column | Type | Keys |
| --- | --- | --- |
| forecast_id | String | PK |
| forecast_type | Unknown | PK |
| time_period_id | Unknown | PK |
| end_date | Unknown |  |
| label | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |
| year | Unknown |  |

### activity_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| name | Unknown |  |
| owner_id | Unknown |  |

### activity_opportunity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_id | Unknown | PK, FK |
| name | Unknown |  |
| owner_id | Unknown |  |

### activity_participant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| activity_id | Unknown | PK, FK |
| email | Unknown |  |
| is_internal | Unknown |  |
| name | Unknown |  |
| sfdc_user_id | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| date | Unknown |  |
| organiser_id | Unknown |  |
| owner_id | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |

## Relationships

- opportunity_field(opportunity_id) → opportunity(id)
- opportunity_trend_history(opportunity_id) → opportunity(id)
- opportunity(id) → activity_opportunity(id)
- actor(actor_id) → item(actor_id)
- forecast_entry(time_period_id) → time_period(time_period_id)
- forecast_entry(user_id) → users(user_id)
- forecast_entry(field_id) → field(field_id)
- forecast_entry(time_frame_id) → time_frame(time_frame_id)
- activity_account(activity_id) → activity(id)
- activity_opportunity(activity_id) → activity(id)
- activity_participant(activity_id) → activity(id)