Database voip running on localhost
DID
Table comments : did pool and assignments
Field Type Null Default
npa int(3) No 0
did int(7) No 0
assigned enum('Y', 'N', 'P') No N
user varchar(40) No
ast_config
Field Type Null Default
id bigint(20) No
cat_metric int(11) No 0
var_metric int(11) No 0
commented int(11) No 0
filename varchar(128) No
category varchar(128) No default
var_name varchar(128) No
var_val varchar(128) No
cdr
Field Type Null Default
uniqueid varchar(32) No
userfield varchar(255) No
accountcode varchar(20) No
src varchar(80) No
dst varchar(80) No
dcontext varchar(80) No
clid varchar(80) No
channel varchar(80) No
dstchannel varchar(80) No
lastapp varchar(80) No
lastdata varchar(80) No
calldate datetime No 0000-00-00 00:00:00
duration int(11) No 0
billsec int(11) No 0
disposition varchar(45) No
amaflags int(11) No 0
compcdr
Field Type Null Default
DID text No
day text No
date text No
time text No
placecalled text No
numbercalled text No
type text No
rate text No
minutes text No
amount text No
tax text No
group text No
npanxx
Table comments : npa data from Oct 03
Field Type Null Default
npanxx int(6) No 0
city text No
state text No
DID enum('Y', 'N', 'P') No N