Assembled

Explore the interactive ERD

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	PKFK
`team_id`	Unknown	PKFK

people_queue

Column	Type	Keys
`people_id`	Unknown	PKFK
`queue_id`	Unknown	PKFK

people_skill

Column	Type	Keys
`people_id`	Unknown	PKFK
`skill_id`	Unknown	PKFK

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	PKFK
`message_id`	String	PKFK
`platform`	String
`title`	String
`url`	String

message

Column	Type	Keys
`id`	String	PK
`assist_conversation_id`	Unknown	PKFK
`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	PKFK
`dimension`	Unknown
`label`	Unknown

executed_workflow_detail

Column	Type	Keys
`id`	Unknown	PK
`assist_conversation_id`	Unknown	PKFK
`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	PKFK
`requirement_type_id`	Unknown	PKFK

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