Table Type: Historical Data
This table contains the conversation participants.
Each participant is a user, team, external contact, external organization, or other entity that is part of a conversation, stored in the 'purpose' field.
Different participants join a conversation from time to time, and disconnect (or are terminated) until none are left.
The conversation will have multiple participants.
The participant will be associated with multiple sessions, and each session can have multiple segments.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| participant_id | string | Primary Key | The unique identifier of the participant within the conversation |
| db_last_updated | datetime | The last time this record was updated in the database | |
| db_when_created | datetime | The time this record was created in the database | |
| conversation_id | string | Primary Key | The ID of the conversation to which this participant belongs |
| flagged_reason | string | Should only contain 'General' at present | |
| purpose | string | The purpose of the participant. One of: acd, agent, api, botflow, campaign, customer, dialer, external, fax, group, inbound, ivr, manual, outbound, station, user, voicemail, voicesurveyflow or workflow | |
| external_contact_id | string | The ID of the external contact if this participant is an external contact, or NULL. | |
| external_organization_id | string | The ID of the external organization if this participant is an external organization, or NULL. | |
| participant_name | string | The name of the participant | |
| screen_recording | boolean | Whether the screen was being recorded for this participant | |
| team_id | string | The ID of the team if this participant is a team, or NULL. | |
| user_id | string | The ID of the user if this participant is a user, or NULL. |
Related Tables
- analytics_conversation
- external_contact
- external_organization
- team
- user
- analytics_participant_attribute
- analytics_session
- analytics_session_metric
- analytics_conversation_segment
- queue_email
- analytics_session_flow_outcome
