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