# Tymeshift schema ERD

Table and field reference for the Fivetran Tymeshift connector.

## Table & Field Reference

### report_data_metrics

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| report_data_fivetran_id | Unknown | PK, FK |
| key | Unknown |  |
| type | Unknown |  |
| value | Unknown |  |

### report_data

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| report_template_id | Unknown | FK |
| children | Json |  |
| end_date | Unknown |  |
| item_key | Unknown |  |
| item_value | Unknown |  |
| start_date | Unknown |  |

### agent_team

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| agent_id | Unknown | PK, FK |
| team_id | Unknown |  |

### agent

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deactivated | Unknown |  |
| default_group_id | Unknown |  |
| email | Unknown |  |
| group_id | Unknown |  |
| is_deleted | Unknown |  |
| location_id | Unknown |  |
| name | Unknown |  |
| photo | Unknown |  |
| role_id | Unknown |  |
| shift_template_id | Unknown |  |
| tymeshift_account_id | Unknown |  |
| user_id | Unknown |  |

### agent_activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| duration | Unknown |  |
| end_time | Unknown |  |
| event_type | Unknown |  |
| general_task_id | Unknown |  |
| is_paid | Unknown |  |
| lock_interval | Unknown |  |
| start_time | Unknown |  |
| ticket_id | Unknown |  |
| type | Unknown |  |
| user_id | Unknown |  |
| workstreams | Json |  |

### report_template

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Json |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| dimension_group_by | Json |  |
| dimension_interval | Unknown |  |
| file_structure | Unknown |  |
| filter_activity_type_id | Unknown |  |
| filter_group_id | Json |  |
| filter_interval | Json |  |
| filter_location_id | Json |  |
| filter_scopes | Json |  |
| filter_status | Json |  |
| filter_tags | Json |  |
| filter_team_id | Json |  |
| filter_ticket_customfield_option_key | Json |  |
| filter_ticket_id | Json |  |
| filter_ticket_via_type | Json |  |
| filter_timeoff_reason_id | Json |  |
| is_default | Unknown |  |
| metrics | Json |  |
| name | Unknown |  |
| timezone | Unknown |  |
| tymeshift_account_id | Unknown |  |
| type | Unknown |  |

### published_schedule_workstream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| published_schedule_id | Unknown | PK, FK |
| taskable_id | Unknown | FK |
| color | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| shift_id | Unknown |  |
| start_time | Unknown |  |
| taskable_type | Unknown |  |

### published_schedule_general_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| published_schedule_id | Unknown | PK, FK |
| taskable_id | Unknown | FK |
| created_at | Unknown |  |
| end_time | Unknown |  |
| shift_id | Unknown |  |
| start_time | Unknown |  |
| taskable_type | Unknown |  |

### published_schedule_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| published_schedule_id | Unknown | PK, FK |
| color | Unknown |  |
| created_at | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| shift_id | Unknown |  |
| start_time | Unknown |  |
| taskable_id | Unknown |  |
| taskable_type | Unknown |  |

### published_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| agent_id | Unknown | FK |
| end_time | Unknown |  |
| parent_id | Unknown |  |
| published | Unknown |  |
| schedule_id | Unknown |  |
| start_time | Unknown |  |
| tymeshift_account_id | Unknown |  |

### time_off

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| time_off | Json |  |

### contact_method_key

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workstream_id | Unknown | PK, FK |
| contact_method_key | Unknown |  |

### workstream_condition_all

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workstream_id | Unknown | PK, FK |
| field | Unknown |  |
| operator | Unknown |  |
| value | Unknown |  |

### workstream_condition_any

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workstream_id | Unknown | PK, FK |
| field | Unknown |  |
| operator | Unknown |  |
| value | Unknown |  |

### inbound_volume_adjustment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| workstream_id | Unknown | PK, FK |
| active | Unknown |  |
| change | Unknown |  |
| change_type | Unknown |  |
| end_time | Unknown |  |
| name | Unknown |  |
| start_time | Unknown |  |
| tymeshift_account_id | Unknown |  |

### availability_hour

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| workstream_id | Unknown | PK, FK |
| day_of_the_week | Unknown |  |
| end_time | Unknown |  |
| is_active | Unknown |  |
| start_time | Unknown |  |

### workstream_agent

| Column | Type | Keys |
| --- | --- | --- |
| agent_id | Unknown | PK, FK |
| workstream_id | Unknown | PK, FK |

### workstream

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| actual_algorithm | Unknown |  |
| color | Unknown |  |
| condition_id | Unknown |  |
| condition_tymeshift_account_id | Unknown |  |
| contact_method_group | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| exclude_inbound_volume_outliers | Unknown |  |
| forecast_algorithm | Unknown |  |
| full_time_equivalent_availability | Unknown |  |
| full_time_equivalent_availability_timezone | Unknown |  |
| full_time_equivalent_average_handle_time | Unknown |  |
| full_time_equivalent_average_handle_time_type | Unknown |  |
| full_time_equivalent_channel | Unknown |  |
| full_time_equivalent_concurrency | Unknown |  |
| full_time_equivalent_id | Unknown |  |
| full_time_equivalent_max_occupancy_rate | Unknown |  |
| full_time_equivalent_minimum_staffing | Unknown |  |
| full_time_equivalent_shrinkage | Unknown |  |
| full_time_equivalent_target_service_level | Unknown |  |
| full_time_equivalent_target_time | Unknown |  |
| full_time_equivalent_tymeshift_account_id | Unknown |  |
| full_time_equivalent_workstream_id | Unknown |  |
| ignore_data_prior_to_date | Unknown |  |
| imported_historical_volume | Unknown |  |
| inbound_volume_outlier | Json |  |
| is_deleted | Unknown |  |
| name | Unknown |  |
| orders | Unknown |  |
| priority | Unknown |  |
| tymeshift_account_id | Unknown |  |
| use_all_zendesk_data | Unknown |  |
| visible | Unknown |  |

### task_permitted_team

| Column | Type | Keys |
| --- | --- | --- |
| permitted_team_id | Unknown | PK |
| general_task_id | Unknown | PK, FK |

### task_permitted_team_without_scoping

| Column | Type | Keys |
| --- | --- | --- |
| permitted_team_id_without_scoping | Unknown | PK |
| general_task_id | Unknown | PK, FK |

### general_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| deleted_at | Unknown |  |
| exclude_occupancy | Unknown |  |
| is_deleted | Unknown |  |
| is_paid | Unknown |  |
| job_id | Unknown |  |
| name | Unknown |  |
| permitted_team_preset | Unknown |  |
| productive_time | Unknown |  |
| talk_status | Unknown |  |

## Relationships

- report_data_metrics(report_data_fivetran_id) → report_data(_fivetran_id)
- report_data(report_template_id) → report_template(id)
- agent_team(agent_id) → agent(id)
- agent_activity(agent_id) → agent(id)
- published_schedule_workstream(taskable_id) → workstream(id)
- published_schedule_workstream(published_schedule_id) → published_schedule(id)
- published_schedule_general_task(taskable_id) → general_task(id)
- published_schedule_general_task(published_schedule_id) → published_schedule(id)
- published_schedule_task(published_schedule_id) → published_schedule(id)
- published_schedule(agent_id) → agent(id)
- time_off(id) → agent(id)
- contact_method_key(workstream_id) → workstream(id)
- workstream_condition_all(workstream_id) → workstream(id)
- workstream_condition_any(workstream_id) → workstream(id)
- inbound_volume_adjustment(workstream_id) → workstream(id)
- availability_hour(workstream_id) → workstream(id)
- workstream_agent(agent_id) → agent(id)
- workstream_agent(workstream_id) → workstream(id)
- task_permitted_team(general_task_id) → general_task(id)
- task_permitted_team_without_scoping(general_task_id) → general_task(id)