Описание
В таблице хранится информация об активных распределениях абонентов из входящей очереди либо дайлера КЦ.
Структура
|
column_name |
data_type |
|
description |
|---|---|---|---|
|
id |
bigint |
number |
|
|
queue_id |
integer |
number |
|
|
member_id |
bigint |
number |
|
|
weight |
integer |
number |
|
|
resource_id |
integer |
number |
|
|
node_id |
character varying |
string |
|
|
result |
character varying |
string |
|
|
agent_id |
integer |
number |
|
|
bucket_id |
bigint |
number |
|
|
display |
character varying |
string |
|
|
description |
character varying |
string |
|
|
list_communication_id |
bigint |
number |
|
|
joined_at |
timestamp with time zone |
time |
|
|
leaving_at |
timestamp with time zone |
time |
|
|
agent_call_id |
character varying |
string |
|
|
member_call_id |
character varying |
string |
|
|
offering_at |
timestamp with time zone |
time |
|
|
reporting_at |
timestamp with time zone |
time |
|
|
state |
character varying |
string |
Перечисление |
|
bridged_at |
timestamp with time zone |
time |
|
|
channel |
character varying |
string |
|
|
timeout |
timestamp with time zone |
time |
|
|
last_state_change |
timestamp with time zone |
time |
|
|
communication_idx |
integer |
number |
|
|
resource_group_id |
integer |
number |
|
|
destination |
jsonb |
string |
|
|
seq |
integer |
number |
|
|
answered_at |
|
time |
|
|
team_id |
|
number |
Id команды |
|
sticky_agent_id |
|
number |
Id оператора с которым "липкость" |
|
domain_id |
|
number |
|
|
transferred_at |
|
time |
|
|
transferred_agent_id |
|
number |
|
|
transferred_attempt_id |
|
number |
|
|
parent_id |
|
number |
|
|
waiting_other_numbers |
|
number |
|
Перечисление "state"
|
name |
description |
|---|---|
|
idle |
|
|
waiting |
|
|
waiting_agent |
|
|
distribute |
|
|
offering |
|
|
active |
|
|
bridged |
|
|
wrap_time |
|
|
leaving |
|
Пример данных
Unknown Attachment