6SwiA8Ri

1
2
3-- ----------------------------
4-- Table structure for v_xml_cdr
5-- ----------------------------
6DROP TABLE IF EXISTS "public"."v_xml_cdr";
7CREATE TABLE "public"."v_xml_cdr" (
8  "xml_cdr_uuid" uuid NOT NULL,
9  "domain_uuid" uuid,
10  "extension_uuid" uuid,
11  "domain_name" text COLLATE "pg_catalog"."default",
12  "accountcode" text COLLATE "pg_catalog"."default",
13  "direction" text COLLATE "pg_catalog"."default",
14  "default_language" text COLLATE "pg_catalog"."default",
15  "context" text COLLATE "pg_catalog"."default",
16  "xml" text COLLATE "pg_catalog"."default",
17  "json" json,
18  "caller_id_name" text COLLATE "pg_catalog"."default",
19  "caller_id_number" text COLLATE "pg_catalog"."default",
20  "destination_number" text COLLATE "pg_catalog"."default",
21  "start_epoch" numeric,
22  "start_stamp" timestamp(6),
23  "answer_stamp" timestamp(6),
24  "answer_epoch" numeric,
25  "end_epoch" numeric,
26  "end_stamp" text COLLATE "pg_catalog"."default",
27  "duration" numeric,
28  "mduration" numeric,
29  "billsec" numeric,
30  "billmsec" numeric,
31  "bridge_uuid" text COLLATE "pg_catalog"."default",
32  "read_codec" text COLLATE "pg_catalog"."default",
33  "read_rate" text COLLATE "pg_catalog"."default",
34  "write_codec" text COLLATE "pg_catalog"."default",
35  "write_rate" text COLLATE "pg_catalog"."default",
36  "remote_media_ip" text COLLATE "pg_catalog"."default",
37  "network_addr" text COLLATE "pg_catalog"."default",
38  "recording_file" text COLLATE "pg_catalog"."default",
39  "leg" char(1) COLLATE "pg_catalog"."default",
40  "pdd_ms" numeric,
41  "rtp_audio_in_mos" numeric,
42  "last_app" text COLLATE "pg_catalog"."default",
43  "last_arg" text COLLATE "pg_catalog"."default",
44  "cc_side" text COLLATE "pg_catalog"."default",
45  "cc_member_uuid" uuid,
46  "cc_queue_joined_epoch" text COLLATE "pg_catalog"."default",
47  "cc_queue" text COLLATE "pg_catalog"."default",
48  "cc_member_session_uuid" uuid,
49  "cc_agent" text COLLATE "pg_catalog"."default",
50  "cc_agent_type" text COLLATE "pg_catalog"."default",
51  "waitsec" numeric,
52  "conference_name" text COLLATE "pg_catalog"."default",
53  "conference_uuid" uuid,
54  "conference_member_id" text COLLATE "pg_catalog"."default",
55  "digits_dialed" text COLLATE "pg_catalog"."default",
56  "pin_number" text COLLATE "pg_catalog"."default",
57  "hangup_cause" text COLLATE "pg_catalog"."default",
58  "hangup_cause_q850" numeric,
59  "sip_hangup_disposition" text COLLATE "pg_catalog"."default",
60  "source_number" text COLLATE "pg_catalog"."default",
61  "caller_destination" text COLLATE "pg_catalog"."default",
62  "record_path" text COLLATE "pg_catalog"."default",
63  "record_name" text COLLATE "pg_catalog"."default",
64  "cc_agent_uuid" uuid,
65  "cc_agent_bridged" text COLLATE "pg_catalog"."default",
66  "cc_queue_answered_epoch" numeric,
67  "cc_queue_terminated_epoch" numeric,
68  "cc_queue_canceled_epoch" numeric,
69  "cc_cancel_reason" text COLLATE "pg_catalog"."default",
70  "cc_cause" text COLLATE "pg_catalog"."default",
71  "missed_call" bool
72)
73;
74ALTER TABLE "public"."v_xml_cdr" OWNER TO "fusionpbx";
75
76-- ----------------------------
77-- Indexes structure for table v_xml_cdr
78-- ----------------------------
79CREATE INDEX "index_billsec" ON "public"."v_xml_cdr" USING btree (
80  "billsec" "pg_catalog"."numeric_ops" ASC NULLS LAST
81);
82CREATE INDEX "index_caller_id_name" ON "public"."v_xml_cdr" USING btree (
83  "caller_id_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
84);
85CREATE INDEX "index_destination_number" ON "public"."v_xml_cdr" USING btree (
86  "destination_number" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
87);
88CREATE INDEX "index_duration" ON "public"."v_xml_cdr" USING btree (
89  "duration" "pg_catalog"."numeric_ops" ASC NULLS LAST
90);
91CREATE INDEX "index_hangup_cause" ON "public"."v_xml_cdr" USING btree (
92  "hangup_cause" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
93);
94CREATE INDEX "index_start_stamp" ON "public"."v_xml_cdr" USING btree (
95  "start_stamp" "pg_catalog"."timestamp_ops" ASC NULLS LAST
96);
97
98-- ----------------------------
99-- Primary Key structure for table v_xml_cdr
100-- ----------------------------
101ALTER TABLE "public"."v_xml_cdr" ADD CONSTRAINT "v_xml_cdr_pkey" PRIMARY KEY ("xml_cdr_uuid");
102