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