rendered paste bodymysql> desc npanxx;
+---------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+----------------+
| seq | int(20) | NO | PRI | NULL | auto_increment |
| rc | varchar(32) | NO | | | |
| region | varchar(10) | NO | | | |
| switch | varchar(24) | NO | | | |
| ocn | varchar(6) | NO | | | |
| ocndesc | varchar(128) | NO | | | |
| lata | varchar(6) | NO | | | |
| npanxx | varchar(10) | NO | MUL | | |
+---------+--------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)
mysql> desc cdr;
+-------------+--------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------------------+-------+
| calldate | datetime | NO | | 0000-00-00 00:00:00 | |
| clid | varchar(80) | NO | | | |
| src | varchar(80) | NO | | | |
| dst | varchar(80) | NO | MUL | | |
| 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 | | | |
| start | datetime | NO | | | |
| answer | datetime | NO | | | |
| end | datetime | NO | | | |
+-------------+--------------+------+-----+---------------------+-------+
19 rows in set (0.00 sec)