Tables in the PBX Database
This topic describes details of tables stored in the database of Yeastar P-Series PBX System.
agent_misscall_unread table
| Field | Description |
|---|---|
| id | System internal flag. |
| unique_id | System internal flag. |
| agent_id | System internal flag. |
| queue_num | Queue number. |
| agent_num | Agent extension number. |
| is_read | Whether the missed call record has been read. |
call_note table
| Field | Description |
|---|---|
| id | System internal flag. |
| group_id | System internal flag. |
| agent_id | System internal flag. |
| create_time | System internal flag. |
| registration_time | System internal flag. |
| agent_name | Agent name. |
| remark | Remark. |
call_note_disposition_code table
| Field | Description |
|---|---|
| disposition_code_id | System internal flag. |
| call_note_id | System internal flag. |
cdr table
| Field | Description |
|---|---|
| id | System internal flag. |
| datetime | Date and time. |
| timestamp | System internal flag. |
| uid | System internal flag. |
| clid | System internal flag. |
| src | Caller number. |
| srcname | Caller name. |
| srcaddr | System internal flag. |
| dst | Callee number. |
| dstname | Callee name. |
| dcontext | System internal flag. |
| channel | System internal flag. |
| dstchannel | System internal flag. |
| srctrunk | Source trunk. |
| dsttrunk | Destination trunk. |
| lastapp | System internal flag. |
| lastdata | System internal flag. |
| duration | Total duration of the call. |
| ringduration | Ringing duration of the call. |
| talkduration | Talk duration of the call. |
| disposition | Call status. |
| amaflags | System internal flag. |
| calltype | Communication type. |
| accountcode | PIN code. |
| uniqueid | System internal flag. |
| didnumber | DID number. |
| dodnumber | DOD number. |
| recordfile | Recording file name. |
| recordpath | Recordings path (with file name). |
| srcchanurl | Caller's SIP URI. |
| dstchanurl | Callee's SIP URI. |
| reasonpartya | System internal flag. |
| reasonpartyb | System internal flag. |
| reasonpartyc | System internal flag. |
| reasonpartyd | System internal flag. |
| reasonpartye | System internal flag. |
| reasonpartyf | System internal flag. |
| displayonweb | System internal flag. |
| src_del_cdr | System internal flag. |
| dst_del_cdr | System internal flag. |
| src_del_recording | System internal flag. |
| dst_del_recording | System internal flag. |
| srcnameprefix | System internal flag. |
| dstnameprefix | System internal flag. |
| misscall_isread | System internal flag. |
| in2outbound | System internal flag. |
| concurrentcalls | System internal flag. |
| videocall | System internal flag. |
| rascall | System internal flag. |
| tryvideocall | System internal flag. |
| amount | Call cost. |
| rate_id | System internal flag. |
| displayonext | System internal flag |
| dstexten | System internal flag. |
| callflow | System internal flag. |
| callflownumber | System internal flag. |
| holdduration | The time during which the call is placed on hold. |
| press_timeout | The number of times that no key was pressed before the timeout. |
| press_invalid | The number of times invalid keys were pressed. |
| press | The key pressed. |
| groupid | System internal flag. |
| reasonpartyg | System internal flag. |
| reasonpartyh | System internal flag. |
| reasonpartyi | System internal flag. |
| process_ext | Extension of the operator who changed the processing result. |
| process_time | The time when the operator changed the processing result. |
| ivrdst | System internal flag. |
| linkedid | System internal flag. |
| attended_requestor | System internal flag. |
| is_auto_fill_0 | System internal flag. |
| contactname | System internal flag. |
| contacttype | System internal flag. |
| campaign_id | System internal flag. |
| target_id | System internal flag. |
| task_id | System internal flag. |
| target_source | System internal flag. |
| number_encryption_object | System internal flag. |
| cdrid | System internal flag. |
| enb_call_note | System internal flag. |
| record_custom_code | System internal flag. |
| auto_sync_process_result | Auto-sync status for processing results of repeated calls. |
| shakenattestation | System internal flag. |
cdr_basic table
| Field | Description |
|---|---|
| id | System internal flag. |
| tenant_id | System internal flag. |
| uid | System internal flag. |
| timestamp | System internal flag. |
| datetime | Date and time. |
| src | Caller number. |
| srcname | Caller name. |
| dst | Callee number. |
| dstname | Callee name. |
| second_dst | Callee number of second call leg. |
| second_dstname | Callee name of second call leg. |
| last_dst | Callee number of last call leg. |
| last_dstname | Callee name of last call leg. |
| disposition | Call status. |
| call_duration | Call duration. |
| routing_duration | The time between the call stared and the call answered. |
| ivr_duration | Talk duration spent in IVR. |
| callflow_duration | Talk duration spent in call flow. |
| wait_duration | The time between the call started and the call answered. |
| handling_duration | The time between the call answered and the call ended, including any hold time and wrap-up time. |
| talk_duration | The time between the call answered and the call ended. |
| hold_duration | The time during which the call is placed on hold. |
| wrap_duration | The time that agent spent in post-call processing. |
| call_type | Communication type. |
| call_note | System internal flag. |
| queues | System internal flag. |
| ringgroups | System internal flag. |
| ivrs | System internal flag. |
| callflows | System internal flag. |
| campaigns | System internal flag. |
| disconnect_by | The party that terminated the call. |
| segments | The number of call legs. |
| has_recording | Whether there is an associated call recording. |
| srcnameprefix | System internal flag. |
| dstnameprefix | System internal flag. |
| second_calltype | Call type of the second call leg. |
| second_dstnameprefix | System internal flag. |
| last_calltype | Call type of the last call leg. |
| last_dstnameprefix | System internal flag. |
| last_callflow | Call feature name of the last call leg. |
| last_callflownumber | Call feature number of the last call leg. |
| enb_timeline | Whether timeline is enabled. |
| first_contact_name | Contact name of the first call leg. |
| first_contact_type | Contact type of the first call leg. |
| wrapup_ts | System internal flag. |
cdr_cleaned table
| Field | Description |
|---|---|
| id | System internal flag. |
| tenant_id | System internal flag. |
| uid | System internal flag. |
| cdrid | System internal flag. |
| another_uid | System internal flag. |
| group_cdrid | System internal flag. |
| rate_id | System internal flag. |
| is_group | System internal flag. |
| group_id | System internal flag. |
| flag | System internal flag. |
| timestamp | System internal flag. |
| start_ts | System internal flag. |
| datetime | Date and time. |
| src | Caller number. |
| dst | Callee number. |
| dstexten | System internal flag. |
| srctrunk | Source trunk. |
| dsttrunk | Destination trunk. |
| didnumber | DID number. |
| dodnumber | DOD number. |
| call_flow | Call feature name. |
| call_flow_number | Call feature number. |
| call_type | Communication type. |
| disposition | Call status. |
| answered | Whether the call was answered. |
| missed | Whether the call was missed. |
| abandoned | Whether the call was abandoned by caller. |
| no_answer | Whether the call was not answered. |
| busy | Whether the call was busy. |
| failed | Whether the call failed. |
| vm | Whether the call was routed to the voicemail. |
| duration | Total duration of the call. |
| talk_duration | The time between the call answered and the call ended. |
| ring_duration | The time between the call started and the call answered. |
| answered_ring_duration | The time between the call started and the call answered for answered calls. |
| hold_duration | The time during which the call is placed on hold. |
| wrapup_duration | The time that agent spent in post-call processing. |
| press_key | Key pressed. |
| concurrent | Maximum number of concurrent calls. |
| amount | Call cost. |
| satisfaction | Satisfaction survey score. |
| transfer_dest | Destination to which the call was transferred. |
| is_qcb | Whether this is a queue callback call. |
| qcb_status | Callback status. |
| qcb_failed_reason | Reason why the queue callback failed. |
| opr_duration | IVR operation time. |
| member_answerd_count | Number of queue calls answered by agents. |
| member_hold_duration | The time during which agent held queue calls. |
| qcb_time | The time that agents made a callback. |
| qcb_number | The number that requested the callback. |
| srcname | Caller name. |
| dstname | Callee name. |
| dstnameprefix | System internal flag. |
| member_answered_number | Extension number of the internal user who answered the call. |
| is_display | System internal flag. |
| member_answered_name | Name of the member who answered the call. |
| member_answered_count | Number of calls answered by members. |
| source_src |
Caller number of the first call leg. |
| source_srcname | Caller name of the first call leg. |
| member_answer_ringduration | The time between call started and call answered for answered calls. |
| member_polling_attemps | Number of attempts to reach agents. |
| join_announcement_duration | Duration of join announcement. |
cdr_clip table
| Field | Description |
|---|---|
| id | System internal flag. |
| tenant_id | System internal flag. |
| uid | System internal flag. |
| clid | System internal flag. |
| uniqueid | System internal flag. |
| linkedid | System internal flag. |
| cdrid | System internal flag. |
| datetime | Date and time. |
| timestamp | System internal flag. |
| src | Caller number. |
| srcname | Caller name. |
| srcnameprefix | System internal flag. |
| dst | Callee number. |
| dstname | Callee name. |
| dstnameprefix | System internal flag. |
| channel | System internal flag. |
| dstchannel | System internal flag. |
| srctrunk | Source trunk. |
| dsttrunk | Destination trunk. |
| duration | Total duration of the call. |
| ringduration | Ringing duration of the call. |
| talkduration | Talk duration of the call. |
| holdduration | The time during which the call is placed on hold. |
| wrapduration | The time that agent spent in post-call processing. |
| disposition | Call status. |
| calltype | Communication type. |
| didnumber | DID number. |
| dodnumber | DOD number. |
| recordfile | Recording file name. |
| recordpath | Recordings path (with file name). |
| amount | Call cost. |
| rate_id | System internal flag. |
| accountcode | PIN code. |
| callflow | System internal flag. |
| callflownumber | System internal flag. |
| groupid | System internal flag. |
| enb_call_note | System internal flag. |
| scenario | System internal flag. |
| scenario_primary_id | System internal flag. |
| scenario_secondary_id | System internal flag. |
| displayonweb | System internal flag. |
| displayonext | System internal flag |
| concurrencys | Current concurrent calls. |
| number_encryption_object | System internal flag. |
| srcaddr | System internal flag. |
| srcchanurl | System internal flag. |
| dstchanurl | System internal flag. |
| videocall | System internal flag. |
| rascall | System internal flag. |
| tryvideocall | System internal flag. |
| src_del_cdr | System internal flag. |
| dst_del_cdr | System internal flag. |
| src_del_recording | System internal flag. |
| dst_del_recording | System internal flag. |
| finish_call | System internal flag. |
| transactionid | System internal flag. |
| dcontext | System internal flag. |
| shakenattestation | System internal flag. |
| shakenrejectreason | System internal flag. |
| start_ts | System internal flag. |
| join_announcement_duration | Duration of join announcement. |
cdr_extend table
| Field | Description |
|---|---|
| id | System internal flag. |
| tenant_id | System internal flag. |
| uid | System internal flag. |
| cdrid | System internal flag. |
| another_uid | System internal flag. |
| timestamp | System internal flag. |
| is_auto_fill_0 | System internal flag. |
| contactname | System internal flag. |
| contacttype | System internal flag. |
| record_custom_code | System internal flag. |
| dstexten | System internal flag. |
cdr_process table
| Field | Description |
|---|---|
| id | System internal flag. |
| uid | System internal flag. |
| tenant_id | System internal flag. |
| cdrid | System internal flag. |
| linkedid | System internal flag. |
| timestamp | System internal flag. |
| queue | Queue number. |
| process_result | Processing result of a queue call. |
| process_ext | Extension of the operator who changed the processing result. |
| process_time | The time when the operator changed the processing result. |
| auto_sync_process_result | Auto-sync status for processing results of repeated calls. |
cdr_timeline table
| Field | Description |
|---|---|
| id | System internal flag. |
| tenant_id | System internal flag. |
| uid | System internal flag. |
| cdrid | System internal flag. |
| event_time | Date and time. |
| timestamp | System internal flag. |
| event_type | Call event type. |
| event_name | Call event name. |
| event_content | Call event detail. |
dyncrm_phone_call table
| Field | Description |
|---|---|
| id | System internal flag. |
| cdrid | System internal flag. |
| crm_id | System internal flag. |
| act_id | System internal flag. |
| create_time | System internal flag. |
personal_misscall_count table
| Field | Description |
|---|---|
| id | System internal flag. |
| ext_num | Extension number. |
| unread_count | Number of unread missed calls. |
queue_log table
| Field | Description |
|---|---|
| id | System internal flag. |
| callid | System internal flag. |
| queueid | System internal flag. |
| time | System internal flag. |
| timestamp | System internal flag. |
| queuename | System internal flag. |
| agent | System internal flag. |
| event | System internal flag. |
| data1 | System internal flag. |
| data2 | System internal flag. |
| data3 | System internal flag. |
| data4 | System internal flag. |
| data5 | System internal flag. |
| data6 | System internal flag. |
queue_miss_call table
| Field | Description |
|---|---|
| id | System internal flag. |
| uniqueid | System internal flag. |
| caller_id | System internal flag. |
| linked_id | System internal flag. |
| cdr_id | System internal flag. |
| new_cdrid | System internal flag. |
| new_id | System internal flag. |
| timestamp | System internal flag. |
| src | Caller number. |
| ext_num | Extension number. |
| dod_number | DOD number. |
| call_flow_number | Call feature number. |
| number_encryption_object | System internal flag. |
| talk_duration | The time between the call answered and the call ended. |
| call_type | Communication type. |
| disposition | Call status. |
| dcontext | System internal flag. |
| clid | System internal flag. |
| reason_partya | System internal flag. |
| ring_duration | The time between the call started and the call answered. |
| is_read | Whether the missed call record has been read. |
| process_ext | Extension of the operator who changed the processing result. |
| process_time | The time when the operator changed the processing result. |
| process_result | Processing result of a queue call. |
| auto_sync_process_result | Auto-sync status for processing results of repeated calls. |
transcription_meta table
| Field | Description |
|---|---|
| id | System internal flag. |
| call_id | System internal flag. |
| ext_id | System internal flag. |
| created_at | System internal flag. |
| used | Whether the transcription has been used. |
| language | Transcription language. |
transcription_record table
| Field | Description |
|---|---|
| id | System internal flag. |
| call_id | System internal flag. |
| timestamp | System internal flag. |
| created_at | System internal flag. |
| duration | System internal flag. |
| type | System internal flag. |
| source_number | Source number of the transcription. |
| content | Transcription content. |
transcription_summary table
| Field | Description |
|---|---|
| id | System internal flag. |
| call_id | System internal flag. |
| ext_id | System internal flag. |
| created_at | System internal flag. |
| updated_at | System internal flag. |
| summary | AI-generated call summary. |
transcription_visibility table
| Field | Description |
|---|---|
| id | System internal flag. |
| transcription_record_id | System internal flag. |
| visible_ext_id | System internal flag. |
| visible | System internal flag. |
| call_id | System internal flag. |
trunk_concurrent table
| Field | Description |
|---|---|
| id | System internal flag. |
| timestamp | System internal flag. |
| datetime | Date and time. |
| trunk | Trunk name. |
| call_type | Communication type. |
| concurrent | The maximum number of concurrent calls. |