mysql> desc vicidial_log;
+---------------+---------------------------------------------------------------------+------+-----+---------+-------+
| Field         | Type                                                                | Null | Key | Default | Extra |
+---------------+---------------------------------------------------------------------+------+-----+---------+-------+
| uniqueid      | varchar(20)                                                         | NO   | PRI | NULL    |       |
| lead_id       | int(9) unsigned                                                     | NO   | MUL | NULL    |       |
| list_id       | bigint(14) unsigned                                                 | YES  |     | NULL    |       |
| campaign_id   | varchar(8)                                                          | YES  |     | NULL    |       |
| call_date     | datetime                                                            | YES  | MUL | NULL    |       |
| start_epoch   | int(10) unsigned                                                    | YES  |     | NULL    |       |
| end_epoch     | int(10) unsigned                                                    | YES  |     | NULL    |       |
| length_in_sec | int(10)                                                             | YES  |     | NULL    |       |
| status        | varchar(6)                                                          | YES  |     | NULL    |       |
| phone_code    | varchar(10)                                                         | YES  |     | NULL    |       |
| phone_number  | varchar(18)                                                         | YES  |     | NULL    |       |
| user          | varchar(20)                                                         | YES  |     | NULL    |       |
| comments      | varchar(255)                                                        | YES  |     | NULL    |       |
| processed     | enum('Y','N')                                                       | YES  |     | NULL    |       |
| user_group    | varchar(20)                                                         | YES  |     | NULL    |       |
| term_reason   | enum('CALLER','AGENT','QUEUETIMEOUT','ABANDON','AFTERHOURS','NONE') | YES  |     | NONE    |       |
| alt_dial      | varchar(6)                                                          | YES  |     | NONE    |       |
+---------------+---------------------------------------------------------------------+------+-----+---------+-------+