Sylvain Boily
Active Member
- Joined
- Apr 30, 2016
- Messages
- 259
- Reaction score
- 144
@wardmundy can you give me all informations you think it's important to have in our CDR? Maybe it will be interesting to add it in XiVO.
cdr
Column Type Null Default Comments
calldate datetime No 0000-00-00 00:00:00
clid varchar(80) No
src varchar(80) No
dst varchar(80) No
dcontext varchar(80) No
channel varchar(80) No
dstchannel varchar(80) No
lastapp varchar(80) No
lastdata varchar(80) No
duration int(11) No 0
billsec int(11) No 0
disposition varchar(45) No
amaflags int(11) No 0
accountcode varchar(20) No
uniqueid varchar(32) No
userfield varchar(255) No
did varchar(50) No
recordingfile varchar(255) No
cnum varchar(40) No
cnam varchar(40) No
outbound_cnum varchar(40) No
outbound_cnam varchar(40) No
dst_cnam varchar(40) No
Indexes: Documentation
Keyname Type Unique Packed Column Cardinality Collation Null Comment
calldate BTREE No No calldate 0 A
dst BTREE No No dst 0 A
accountcode BTREE No No accountcode 0 A
uniqueid BTREE No No uniqueid 0 A
did BTREE No No did 0 A
Space usage:
Type Usage
Data 2,224 B
Index 6,144 B
Total 8,368 B
Row Statistics:
Statements Value
Format dynamic
Rows 13
Row length ø 171
Row size ø 644 B
Creation Jul 06, 2015 at 09:48 AM
Last update Jul 07, 2015 at 12:30 PM
cel
Column Type Null Default Comments
id int(11) No
eventtype varchar(30) No
eventtime datetime No
cid_name varchar(80) No
cid_num varchar(80) No
cid_ani varchar(80) No
cid_rdnis varchar(80) No
cid_dnid varchar(80) No
exten varchar(80) No
context varchar(80) No
channame varchar(80) No
src varchar(80) No
dst varchar(80) No
channel varchar(80) No
dstchannel varchar(80) No
appname varchar(80) No
appdata varchar(80) No
amaflags int(11) No
accountcode varchar(20) No
uniqueid varchar(32) No
linkedid varchar(32) No
peer varchar(80) No
userdeftype varchar(255) No
eventextra varchar(255) No
userfield varchar(255) No
Indexes: Documentation
Keyname Type Unique Packed Column Cardinality Collation Null Comment
PRIMARY BTREE Yes No id 0 A
uniqueid_index BTREE No No uniqueid 0 A
linkedid_index BTREE No No linkedid 0 A
Space usage:
Type Usage
Data 0 B
Index 1,024 B
Total 1,024 B
Row Statistics:
Statements Value
Format dynamic
Rows 0
Next Autoindex 1
Creation Jul 06, 2015 at 09:48 AM
Last update Jul 06, 2015 at 09:48 AM
Link up your team and customers Phone System Live Chat Video Conferencing
Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.
Check your inbox!
We’ve sent you an email. Click on the button in the email body to verify your email address – (if you can not find it, check your spam folder).
Upon verification you will be directed to the 3CX setup wizard.