# Assembled schema ERD

Table and field reference for the Fivetran Assembled connector.

## Table & Field Reference

### forecast_vs_actual

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| queue | String | FK |
| cases_answered_actual | Unknown |  |
| cases_answered_forecasted | Unknown |  |
| cases_opened_actual | Unknown |  |
| cases_opened_forecasted | Unknown |  |
| cases_reopened_actual | Unknown |  |
| cases_reopened_forecasted | Unknown |  |
| cases_solved_actual | Unknown |  |
| cases_solved_forecasted | Unknown |  |
| channel | String |  |
| contacts_abandoned_actual | Unknown |  |
| contacts_abandoned_forecasted | Unknown |  |
| contacts_received_actual | Unknown |  |
| contacts_received_forecasted | Unknown |  |
| end_time | Instant |  |
| first_response_time_actual | Unknown |  |
| first_response_time_forecasted | Unknown |  |
| handle_time_actual | Unknown |  |
| handle_time_forecasted | Unknown |  |
| messages_received_actual | Unknown |  |
| messages_received_forecasted | Unknown |  |
| occupancy_actual | Unknown |  |
| occupancy_forecasted | Unknown |  |
| productivity_actual | Unknown |  |
| productivity_forecasted | Unknown |  |
| reassigned_away_actual | Unknown |  |
| reassigned_away_forecasted | Unknown |  |
| service_level_actual | Unknown |  |
| service_level_forecasted | Unknown |  |
| service_level_met_actual | Unknown |  |
| service_level_met_forecasted | Unknown |  |
| service_level_missed_actual | Unknown |  |
| service_level_missed_forecasted | Unknown |  |
| staffing_net | Float |  |
| staffing_required_actual | Unknown |  |
| staffing_required_forecasted | Unknown |  |
| staffing_scheduled | Float |  |
| start_time | Instant |  |
| transferred_away_actual | Unknown |  |
| transferred_away_forecasted | Unknown |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activity_type_id | Unknown | FK |
| agent_id | Unknown | FK |
| event_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| end_time | Unknown |  |
| start_time | Unknown |  |
| updated_at | Unknown |  |

### activity_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| background_color | Unknown |  |
| channels | Json |  |
| font_color | Unknown |  |
| import_id | Unknown |  |
| name | Unknown |  |
| productive | Unknown |  |
| short_name | Unknown |  |
| timeoff | Unknown |  |
| value | Unknown |  |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### people_team

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

### people_queue

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| queue_id | Unknown | PK, FK |

### people_skill

| Column | Type | Keys |
| --- | --- | --- |
| people_id | Unknown | PK, FK |
| skill_id | Unknown | PK, FK |

### people

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| site | Unknown | FK |
| agent_role | Unknown |  |
| channels | Json |  |
| created_at | Unknown |  |
| deleted | Unknown |  |
| email | Unknown |  |
| end_date | Unknown |  |
| first_name | Unknown |  |
| imported_id | Unknown |  |
| last_name | Unknown |  |
| platforms | Json |  |
| productivity | String |  |
| role | Unknown |  |
| staffable | Boolean |  |
| start_date | Unknown |  |
| timezone | Unknown |  |

### site

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### queue

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### time_off_update

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| time_off_request_id | String | FK |
| comment | String |  |
| created_at | Instant |  |
| type | String |  |

### time_off_request

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| activity_type_id | String | FK |
| agent_id | String | FK |
| created_at | Instant |  |
| description | String |  |
| end_time | Instant |  |
| start_time | Instant |  |
| status | String |  |

### sources_used

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| assist_conversation_id | Unknown | PK, FK |
| message_id | String | PK, FK |
| platform | String |  |
| title | String |  |
| url | String |  |

### message

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| assist_conversation_id | Unknown | PK, FK |
| content_text | String |  |
| content_type | String |  |
| content_url | String |  |
| created_at | String |  |
| platform_id | String |  |
| role | String |  |
| sender_type | Unknown |  |
| user_platform_id | String |  |

### ai_experience_subscore

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| assist_conversation_id | Unknown | PK, FK |
| dimension | Unknown |  |
| label | Unknown |  |

### executed_workflow_detail

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assist_conversation_id | Unknown | PK, FK |
| execution_outcome | Unknown |  |
| last_step_run_step_id | Unknown |  |
| last_step_run_step_name | Unknown |  |
| last_step_run_step_type | Unknown |  |
| title | Unknown |  |

### assist_conversation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| user_id | String | FK |
| ai_experience_score_rationale | Unknown |  |
| ai_experience_score_score | Unknown |  |
| brand_id | Unknown |  |
| brand_name | Unknown |  |
| call_summary | Unknown |  |
| category_full_name | Unknown |  |
| category_id | Unknown |  |
| category_name | Unknown |  |
| compared_agent_message_content | String |  |
| compared_agent_message_platform | String |  |
| compared_agent_message_platform_id | String |  |
| conversation_type | String |  |
| copilot_action_type | String |  |
| created_at | Instant |  |
| evaluation_custom_feedback | Json |  |
| handoff_type | Unknown |  |
| platform | String |  |
| platform_id | String |  |
| profile_id | Unknown |  |
| profile_name | Unknown |  |
| routing_destination_id | String |  |
| routing_destination_name | String |  |
| semantic_similarity | Unknown |  |
| status | String |  |
| transfer_detail_id | Unknown |  |
| transferred_case_platform | String |  |
| transferred_case_platform_id | String |  |
| trigram_similarity | Unknown |  |
| updated_at | Instant |  |

### skill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| parent_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### requirement_type_activity_type

| Column | Type | Keys |
| --- | --- | --- |
| activity_type_id | Unknown | PK, FK |
| requirement_type_id | Unknown | PK, FK |

### requirement_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| queue | Unknown | FK |
| channel | Unknown |  |
| name | Unknown |  |

### assist_response_handoff

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| assist_conversation_id | Unknown | FK |
| end_sentiment | String |  |
| issue | String |  |
| start_sentiment | String |  |
| summary | String |  |
| title | String |  |
| transcript | String |  |
| workflow_smart_field_issue_category | Unknown |  |
| workflow_smart_field_priority | Unknown |  |
| workflow_smart_field_team | Unknown |  |

### agent_state

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown | FK |
| agent_platform_id | Unknown |  |
| end_time | Unknown |  |
| modified_at | Unknown |  |
| platform | Unknown |  |
| start_time | Unknown |  |
| state | Unknown |  |
| ticket_id | Unknown |  |
| ticket_status | Unknown |  |

### forecast

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| queue_id | String | FK |
| channel | String |  |
| end_time | Instant |  |
| start_time | Instant |  |
| value | String |  |

### forecast_total

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| queue_id | Unknown | FK |
| channel | Unknown |  |
| end_time | Unknown |  |
| start_time | Unknown |  |
| value | Unknown |  |
| value_type | Unknown |  |

### event_change

| Column | Type | Keys |
| --- | --- | --- |
| id | String | PK |
| event_agent_id | String | FK |
| modified_by_agent_id | String | FK |
| description | String |  |
| event_change_type | String |  |
| event_id | String |  |
| modified_at | Instant |  |
| new_end_time | Instant |  |
| new_event_channel | Unknown |  |
| new_event_type | String |  |
| new_google_calendar_event_id | String |  |
| new_start_time | Instant |  |
| new_template_id | String |  |
| old_end_time | Instant |  |
| old_event_channel | Unknown |  |
| old_event_type | String |  |
| old_google_calendar_event_id | String |  |
| old_start_time | Instant |  |
| old_template_id | String |  |

### requirement

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| requirement_type_id | Unknown | FK |
| end_time | Unknown |  |
| required | Unknown |  |
| scheduled | Unknown |  |
| start_time | Unknown |  |

### agent_ticket_stats_hourly_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### agent_ticket_stats_daily_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### hourly_report_metric

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### agent_state_handle_times_daily_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### daily_report_metric

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### agent_state_handle_times_hourly_report

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| agent_id | Unknown |  |
| channel | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| report_type | Unknown |  |
| start_time | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

## Relationships

- forecast_vs_actual(queue) → queue(id)
- activity(event_id) → event_change(event_id)
- activity(agent_id) → people(agent_id)
- activity(activity_type_id) → activity_type(id)
- team(parent_id) → team(id)
- people_team(team_id) → team(id)
- people_team(people_id) → people(id)
- people_queue(queue_id) → queue(id)
- people_queue(people_id) → people(id)
- people_skill(skill_id) → skill(id)
- people_skill(people_id) → people(id)
- people(agent_id) → people(id)
- people(site) → site(id)
- site(parent_id) → site(id)
- queue(parent_id) → queue(id)
- time_off_update(time_off_request_id) → time_off_request(id)
- time_off_request(agent_id) → people(id)
- time_off_request(activity_type_id) → activity_type(id)
- sources_used(message_id) → message(id)
- sources_used(assist_conversation_id) → message(assist_conversation_id)
- message(assist_conversation_id) → assist_conversation(id)
- ai_experience_subscore(assist_conversation_id) → assist_conversation(id)
- executed_workflow_detail(assist_conversation_id) → assist_conversation(id)
- assist_conversation(user_id) → people(id)
- skill(parent_id) → skill(id)
- requirement_type_activity_type(activity_type_id) → activity_type(id)
- requirement_type_activity_type(requirement_type_id) → requirement_type(id)
- requirement_type(queue) → queue(id)
- assist_response_handoff(assist_conversation_id) → assist_conversation(id)
- agent_state(agent_id) → people(agent_id)
- forecast(queue_id) → queue(id)
- forecast_total(queue_id) → queue(id)
- event_change(event_agent_id) → people(id)
- event_change(modified_by_agent_id) → people(id)
- requirement(requirement_type_id) → requirement_type(id)