Database structure
cdr
- ID - unique primary key
- id_sensor - match id_sensor in voipmonitor.conf or NULL if not set
- calldate - start of the call (counted from first INVITE
- callend - end of the call (counted from the last seen packet)
- duration - callend - calldate in seconds
- connect_duration - callend - time of 200 OK
- progress_time - lenght of ringing
- first_rtp_time - number of seconds since beginning of the call to first rtp packet
- caller - number part of the caller from "From" sip header
- caller_domain - domain part from "From" sip header
- caller_reverse - reversed caller column used to do index searching %search
- callername - number part of the caller from "From" sip header
- callername_reverse - reversed callername used for index searching %search
- called - number part of the called from "To" sip header
- called_domain - domain part from "To" sip header
- called_reverse - reversed called column
- sipcallerip - source IP address from the first INVITE. Use INET_NTOA() to get string
- sipcalledip - destination IP address from the last INVITE.
- whohanged - indication who sent the BYE first
- bye - indication if the call was successfully terminated with BYE - ACK
- lastSIPresponse_id - last SIP response reference to table cdr_sip_response
- lastSIPresponseNum - last SIP response number
- sighup - indication if the call was written during HUP signal sent to sniffer (incomplete CDR)
- dscp - dscp bits
columns starting with a_ represents information for caller RTP stream (RTP sent from caller). Columns starting with b_ represents informatino for called RTP stream (RTP sent from called)
- ab_index - index of RTP stream. used to get correct graph file
- ab_payload - number representing codec type
- ab_saddr - source IP address of the RTP stream
- ab_received - number of received RTP packets
- ab_lost - number of lost RTP packets detected by holes in sequence numbers according to rfc3550
- ab_ua_id - useragent reference to table cdr_ua
- ab_avgjitter_mult10 - average jitter calculated according to rfc3550
- ab_maxjitter - maximum jitter
- ab_sl1 - absl10 -
- b_d50-300
- a_mos_f1_mult10
- a_mos_f2_mult10
- a_mos_adapt_mult10
- a_rtcp_loss
- a_rtcp_maxfr
- a_rtcp_avgfr_mult10
- a_rtcp_maxjitter
- a_rtcp_avgjitter_mult10
- payload
- jitter_mult10
- mos_min_mult10
- a_mos_min_mult10
- packet_loss_perc_mult1000
- a_packet_loss_perc_mult1000
- delay_sum
- a_delay_sum
- delay_avg_mult100
- a_delay_avg_mult100
- delay_cnt
- a_delay_cnt
- rtcp_avgfr_mult10
- rtcp_avgjitter_mult10
- lost