-- msqldump dump table sb_traf.nrm_20000801 Mon Mar 23 09:39:19 2020 -- MonetDB v11.31.13 (Aug2000-SP2), 'mapi:monetdb://monet:54321/cli_xx' DROP TABLE IF EXISTS sb_traf.nrm_20000801; CREATE TABLE "sb_traf"."nrm_20000801" ( "nrm_fil_row" INTEGER, "nrm_host" VARCHAR(20), "nrm_fil_id" BIGINT, "nrm_cdr_id" VARCHAR(500), "nrm_tim_date" DATE, "nrm_tim_datehour" TIMESTAMP(0), "nrm_hou_hour" TIME, "nrm_tim_yearmonth" INTEGER, "nrm_tim_year" INTEGER, "nrm_tim_month" INTEGER, "nrm_tim_day" INTEGER, "nrm_tim_week" INTEGER, "nrm_tim_month_label" VARCHAR(10), "nrm_tim_day_of_week_label" VARCHAR(10), "nrm_connect_time" TIMESTAMP(0), "nrm_disconnect_time" TIMESTAMP(0), "nrm_call_status" VARCHAR(30), "nrm_dialed_number" VARCHAR(100), "nrm_b_cus_number" VARCHAR(100), "nrm_b_ven_number" VARCHAR(200), "nrm_a_cus_number" VARCHAR(100), "nrm_a_ven_number" VARCHAR(100), "nrm_cou_id" INTEGER, "nrm_brn_id" INTEGER, "nrm_brn_cou_name" VARCHAR(100), "nrm_brn_name" VARCHAR(100), "nrm_brn_brc_code" VARCHAR(20), "nrm_cus_id" INTEGER, "nrm_cus_acct_id" VARCHAR(50), "nrm_cup_id" INTEGER, "nrm_cup_par_id" INTEGER, "nrm_cus_name" VARCHAR(100), "nrm_cup_name" VARCHAR(100), "nrm_cup_par_name" VARCHAR(100), "nrm_cus_type" VARCHAR(20), "nrm_cup_acctmngr_id" INTEGER, "nrm_cup_acctmngr_name" VARCHAR(100), "nrm_ven_id" INTEGER, "nrm_ven_acct_id" VARCHAR(50), "nrm_vep_id" INTEGER, "nrm_vep_par_id" INTEGER, "nrm_ven_name" VARCHAR(100), "nrm_vep_name" VARCHAR(100), "nrm_vep_par_name" VARCHAR(100), "nrm_ven_type" VARCHAR(20), "nrm_vep_acctmngr_id" INTEGER, "nrm_vep_acctmngr_name" VARCHAR(100), "nrm_dic_id" INTEGER, "nrm_dic_name" VARCHAR(100), "nrm_dnc_id" INTEGER, "nrm_dnc_name" VARCHAR(100), "nrm_dnv_id" INTEGER, "nrm_dnv_name" VARCHAR(100), "nrm_attempt" TINYINT, "nrm_totalcall" TINYINT, "nrm_effcall" TINYINT, "nrm_nefcall" TINYINT, "nrm_totalcall_abr" TINYINT, "nrm_effcall_abr" TINYINT, "nrm_nefcall_abr" TINYINT, "nrm_sec" DOUBLE, "nrm_realmin" DOUBLE, "nrm_pdd" DOUBLE, "nrm_rse_rate_id" INTEGER, "nrm_rse_brn_id" INTEGER, "nrm_rse_brn_name" VARCHAR(250), "nrm_rse_bill_inc" VARCHAR(20), "nrm_rse_code" VARCHAR(20), "nrm_rse_currency" VARCHAR(3), "nrm_rse_exc_rate" DOUBLE, "nrm_rse_rate" DOUBLE, "nrm_rse_min" DOUBLE, "nrm_rse_amount" DOUBLE, "nrm_rse_amount_usd" DOUBLE, "nrm_rby_rate_id" BIGINT, "nrm_rby_brn_id" BIGINT, "nrm_rby_brn_name" VARCHAR(250), "nrm_rby_bill_inc" VARCHAR(20), "nrm_rby_code" VARCHAR(20), "nrm_rby_currency" VARCHAR(3), "nrm_rby_exc_rate" DOUBLE, "nrm_rby_rate" DOUBLE, "nrm_rby_min" DOUBLE, "nrm_rby_amount" DOUBLE, "nrm_rby_amount_usd" DOUBLE, "nrm_mg_amount_usd" DOUBLE, "nrm_r_actual_dst_ip_address" VARCHAR(35), "nrm_r_alerting_time_orig" TIMESTAMP(0), "nrm_r_alerting_time_term" TIMESTAMP(0), "nrm_r_area_id" VARCHAR(50), "nrm_r_area_name" VARCHAR(100), "nrm_r_area_prefix" VARCHAR(30), "nrm_r_auth_record_id" INTEGER, "nrm_r_billing_procedure_rate_id" VARCHAR(50), "nrm_r_billing_procedure_rate_name" VARCHAR(50), "nrm_r_billing_procedure_route_id" VARCHAR(50), "nrm_r_billing_procedure_route_name" VARCHAR(50), "nrm_r_call_id_incoming_leg" VARCHAR(100), "nrm_r_call_id_outgoing_leg" VARCHAR(100), "nrm_r_call_processing_state" VARCHAR(50), "nrm_r_call_processing_state_name" VARCHAR(20), "nrm_r_call_time_adjustment_avg" INTEGER, "nrm_r_call_time_adjustment_sec" INTEGER, "nrm_r_calling_party_category_id" VARCHAR(50), "nrm_r_calling_party_category_name" VARCHAR(100), "nrm_r_cdr_date" TIMESTAMP(0), "nrm_r_mera_cdr_id" BIGINT, "nrm_r_cn" VARCHAR(50), "nrm_r_conference_id" VARCHAR(50), "nrm_r_connect_time_orig" TIMESTAMP(0), "nrm_r_connect_time_term" TIMESTAMP(0), "nrm_r_customer_id" VARCHAR(50), "nrm_r_customer_name" VARCHAR(100), "nrm_r_customer_account_currency_id" VARCHAR(50), "nrm_r_customer_account_currency_name" VARCHAR(5), "nrm_r_customer_account_id" VARCHAR(50), "nrm_r_customer_account_name" VARCHAR(100), "nrm_r_customer_bill_time" INTEGER, "nrm_r_customer_currency_exchange_rate" INTEGER, "nrm_r_customer_payables_customer_currency" DOUBLE, "nrm_r_customer_payables_domestic_currency" DOUBLE, "nrm_r_customer_rate" DOUBLE, "nrm_r_disconnect_code_id" VARCHAR(50), "nrm_r_disconnect_code" VARCHAR(50), "nrm_r_disconnect_code_orig_id" VARCHAR(50), "nrm_r_disconnect_code_orig_name" VARCHAR(50), "nrm_r_disconnect_code_term_id" VARCHAR(50), "nrm_r_disconnect_code_term_name" VARCHAR(50), "nrm_r_disconnect_initiator" VARCHAR(15), "nrm_r_disconnect_time_orig" TIMESTAMP(0), "nrm_r_disconnect_time_term" TIMESTAMP(0), "nrm_r_dst_faststart_present" INTEGER, "nrm_r_dst_ip_address" VARCHAR(35), "nrm_r_dst_number_in" VARCHAR(35), "nrm_r_dst_protocol" VARCHAR(10), "nrm_r_dst_signaling_bytes_in" INTEGER, "nrm_r_dst_signaling_bytes_out" INTEGER, "nrm_r_dst_tunneling_present" INTEGER, "nrm_r_in_call_time_sec" INTEGER, "nrm_r_in_call_time_term_sec" INTEGER, "nrm_r_invoice_id" VARCHAR(30), "nrm_r_lar_fault_reason" VARCHAR(43), "nrm_r_lnp_server_id" VARCHAR(50), "nrm_r_lnp_server_name" VARCHAR(50), "nrm_r_looping_cycles" INTEGER, "nrm_r_lrn" VARCHAR(100), "nrm_r_max_rate" DOUBLE, "nrm_r_number_from_diversion_header" VARCHAR(100), "nrm_r_origination_endpoint_id" VARCHAR(50), "nrm_r_origination_endpoint_name" VARCHAR(100), "nrm_r_pdd_orig" INTEGER, "nrm_r_pdd_term" INTEGER, "nrm_r_proxy" VARCHAR(15), "nrm_r_qos" VARCHAR(15), "nrm_r_rate_connection_charge" DOUBLE, "nrm_r_rate_id" INTEGER, "nrm_r_rate_plan_id" VARCHAR(50), "nrm_r_rate_plan_name" VARCHAR(50), "nrm_r_rate_plan_billing_scheme" VARCHAR(100), "nrm_r_rate_plan_currency_id" VARCHAR(50), "nrm_r_rate_plan_currency_name" VARCHAR(5), "nrm_r_rate_plan_currency_exchange_rate" DOUBLE, "nrm_r_rate_prefix" VARCHAR(30), "nrm_r_rate_prefix_description" VARCHAR(100), "nrm_r_route_connection_charge_domestic_currency" VARCHAR(100), "nrm_r_route_connection_charge_vendor_currency" VARCHAR(100), "nrm_r_route_id" INTEGER, "nrm_r_route_prefix" VARCHAR(35), "nrm_r_route_prefix_description" VARCHAR(100), "nrm_r_routing_plan_customer_auth_id" VARCHAR(50), "nrm_r_routing_plan_customer_auth" VARCHAR(35), "nrm_r_routing_plan_route_id" VARCHAR(50), "nrm_r_routing_plan_route_name" VARCHAR(35), "nrm_r_routing_policy_id" VARCHAR(50), "nrm_r_routing_policy_name" VARCHAR(50), "nrm_r_routing_retries" INTEGER, "nrm_r_setup_time_orig" TIMESTAMP(0), "nrm_r_setup_time_term" TIMESTAMP(0), "nrm_r_signaling_node" VARCHAR(20), "nrm_r_src_email" VARCHAR(100), "nrm_r_src_faststart_present" INTEGER, "nrm_r_src_gk_ip_address" VARCHAR(100), "nrm_r_src_ip_address" VARCHAR(35), "nrm_r_src_name" VARCHAR(100), "nrm_r_src_nat_ip_address" VARCHAR(100), "nrm_r_src_number_in" VARCHAR(35), "nrm_r_src_number_out" VARCHAR(35), "nrm_r_src_number_used_for_routing" VARCHAR(35), "nrm_r_src_protocol" VARCHAR(5), "nrm_r_src_signaling_bytes_in" INTEGER, "nrm_r_src_signaling_bytes_out" INTEGER, "nrm_r_src_tunneling_present" INTEGER, "nrm_r_src_url" VARCHAR(100), "nrm_r_tech_prefix" VARCHAR(35), "nrm_r_termination_endpoint_id" VARCHAR(50), "nrm_r_termination_endpoint_name" VARCHAR(100), "nrm_r_uri_from_diversion_header" VARCHAR(100), "nrm_r_vendor_id" VARCHAR(50), "nrm_r_vendor_name" VARCHAR(100), "nrm_r_vendor_account_id" VARCHAR(50), "nrm_r_vendor_account_name" VARCHAR(100), "nrm_r_vendor_bill_time" INTEGER, "nrm_r_vendor_billing_scheme" VARCHAR(100), "nrm_r_vendor_currency_id" VARCHAR(50), "nrm_r_vendor_currency_name" VARCHAR(5), "nrm_r_vendor_currency_exchange_rate" INTEGER, "nrm_r_vendor_rate_domestic_currency" DOUBLE, "nrm_r_vendor_rate_vendor_currency" DOUBLE, "nrm_r_vendor_receivables_domestic_currency" DOUBLE, "nrm_r_vendor_receivables_vendor_currency" DOUBLE, "nrm_r_zone_orig_equipment_id" VARCHAR(50), "nrm_r_zone_orig_equipment_name" VARCHAR(10), "nrm_r_zone_term_equipment_id" VARCHAR(50), "nrm_r_zone_term_equipment_name" VARCHAR(10), "nrm_r_dst_number_out" VARCHAR(35), "nrm_r_dst_number_used_for_routing" VARCHAR(35) ); COPY 6170408 RECORDS INTO "sb_traf"."nrm_20000801" FROM stdin USING DELIMITERS '\t','\n','"'; 1 "MIA" 7 "MIA|115331571990001804" 2000-08-01 "2000-08-01 17:00:00" 17:00:00 200008 2000 8 1 30 "Aug" "Wed" "2000-08-01 17:00:00" "2000-08-01 17:00:00" "FAILED" "13193924697" "13193924697" "" "3193927890" "" 0 11 "N/A" "USA" "" 237 "5005" 237 1 "XXXXXXXXXXXXX" "XXXXXXXXXXXXX [5005]" "N/A" "VOICE" 0 "N/A" 1 "0" 1 1 "N/A" "N/A [0]" "N/A" "VOICE" 0 "N/A" 0 "" 27 "USA" 3298 "N/A" 1 0 0 0 1 0 0 0 0 0 78004686 27 "USA" "" "1" "N/A" 0 0 0 0 0 0 3298 "N/A" "" "0" "" 0 0 0 0 0 0 "" "2000-08-01 17:00:00" "2000-08-01 17:00:00" "3570" "USA" "1" 10564 "" "" "" "" "7003167789347130281-1533157199-1323486872" "" "8" "drop call" 0 0 "" "" "2000-08-01 17:00:00" 115331571990001804 "" "da62ac9695cd11e8b3ce00219b8b46bf" "2000-01-01 00:00:00" "2000-01-01 00:00:00" "01.2326" "XXXXXXXXXXXXX" "" "N/A" "5005" "XXXXXXXXXXXXX-IN" 0 0 0 0 0 "TM | 19 | No appropriate routes" "TM | 19 | No appropriate routes" "" "N/A" "" "N/A" "0" "2000-08-01 17:00:00" "2000-08-01 17:00:00" 0 "" "13193924697" "" 0 0 0 0 0 "" "" "56" "LNR Route proloneä" 0 "" 0 "" "7135" "XXXXXXXXXXXXX-IN" 0 0 "" "" 0 78004686 "2278" "PROMO-XXXXXXXXXXXXX" "" "" "N/A" 0 "1" "USA" "" "" 0 "0" "N/A" "01" "Default Routing Group" "" "N/A" "" "" 0 "2000-08-01 16:59:59" "2000-01-01 00:00:00" "signaling-2" "" 0 "" "192.168.143.193:5060" "" "" "3193927890" "" "3193927890" "1" 0 0 0 "sip:qqqqqqq@;user=phone" "" "" "" "" "N/A" "N/A" "0" "" 0 "" "" "" 0 0 0 0 0 "84" "BGP" "" "" "" "13193924697" 3 "MIA" 7 "MIA|115331572000001402" 2000-08-01 "2000-08-01 17:00:00" 17:00:00 200008 2000 8 1 30 "Aug" "Wed" "2000-08-01 17:00:00" "2000-08-01 17:00:00" "FAILED" "918605916918" "918605916918" "918605916918" "971507852471" "971507852471" 0 7 "N/A" "India-Mobile" "" 266 "6054" 266 1 "YYYYYYYYYYYYYYYYYYY" "YYYYYYYYYYYYYYYYYYY [6054]" "N/A" "VOICE" 0 "N/A" 457 "0" 457 1 "WWWWWWWWWWWWWWWWW" "WWWWWWWWWWWWWWWWW [9390]" "N/A" "VOICE" 0 "N/A" 0 "" 1 "N/A" 57735 "CHINA-IDEA-MOBILE" 1 1 0 1 1 0 0 0 0 0 0 1 "N/A" "" "" "N/A" 0 0 0 0 0 267892454 57735 "CHINA-IDEA-MOBILE" "" "0" "" 0 0 0 0 0 0 "192.168.112.12:5060" "2000-08-01 17:00:00" "2000-08-01 16:59:53" "2915" "India-Mobile" "918605" 19574 "" "" "" "" "hif_OcliMRIny0-hKv6aoCo" "d5f88e0095cd11e8b3ce00219b8b46bf@" "4" "failed attempt" 0 0 "" "" "2000-08-01 17:00:00" 115331572000001402 "" "d5f1c98a95cd11e8b3ce00219b8b46bf" "2000-01-01 00:00:00" "2000-01-01 00:00:00" "01.2395" "QQQQQQQQQQ" "" "N/A" "6054" "QQQQQQQQQ-IN" 0 0 0 0 0 "SIP | 487 | Request Terminated" "SIP | 487 | Request Terminated" "" "N/A" "" "N/A" "1" "2000-08-01 17:00:00" "2000-08-01 17:00:00" 0 "192.168.112.12:5060" "918605916918" "1" 1353 1479 0 0 0 "" "6" "" "" 0 "" 0 "" "8524" "QQQQQQQQQQQQIN" 0 1393 "" "" 0 0 "2335" "PROMO-QQQQQQQQ" "" "" "N/A" 0 "" "N/A" "" "" 267892454 "0" "CHINA-IDEA-MOBILE" "01" "Default Routing Group" "01" "Default Routing Group" "" "" 1 "2000-08-01 16:59:52" "2000-08-01 16:59:52" "signaling-2" "" 0 "" "192.168.:5060" "" "" "971507852471" "971507852471" "971507852471" "1" 1469 2000 0 "sip:971507852471" "" "16820" "MMMMMMMMMMMMM" "" "01.2547" "BBBBBBBBBBBBBBBBBBBB" "0" "" 0 "" "" "" 0 0 0 0 0 "84" "BGP" "84" "BGP" "918605916918" "918605916918"