vicidial.org

Posted: **Thu Aug 09, 2007 6:36 am**

Hi
Is there anywhere a list available which explains what each vicidial database table is used for?

Thanks

Posted: **Thu Aug 09, 2007 8:07 am**

Not really, but there are a lot of tables, the best thing to look at either the Manager manual available at eflo.net, or the help screen that is in admin.php, they explain most of the fields in most of the tables.

Posted: **Thu Aug 09, 2007 12:00 pm**

Hi Matt

I have not found in Manager Manual

Which describes each table, what is the purpose ?

is something iam missing ?

Does any one have description for the same

show tables;
+--------------------------------+
| Tables_in_asterisk |
+--------------------------------+
| call_log |
| conferences |
| inbound_numbers |
| live_channels |
| live_inbound |
| live_inbound_log |
| live_sip_channels |
| park_log |
| parked_channels |
| phone_favorites |
| phones |
| recording_log |
| server_performance |
| server_updater |
| servers |
| system_settings |
| vicidial_agent_log |
| vicidial_auto_calls |
| vicidial_call_times |
| vicidial_callbacks |
| vicidial_campaign_hotkeys |
| vicidial_campaign_server_stats |
| vicidial_campaign_stats |
| vicidial_campaign_statuses |
| vicidial_campaigns |
| vicidial_closer_log |
| vicidial_conferences |
| vicidial_dnc |
| vicidial_hopper |
| vicidial_inbound_groups |
| vicidial_lead_filters |
| vicidial_lead_recycle |
| vicidial_list |
| vicidial_list_pins |
| vicidial_lists |
| vicidial_live_agents |
| vicidial_log |
| vicidial_manager |
| vicidial_pause_codes |
| vicidial_phone_codes |
| vicidial_postal_codes |
| vicidial_remote_agents |
| vicidial_scripts |
| vicidial_server_trunks |
| vicidial_state_call_times |
| vicidial_stations |
| vicidial_statuses |
| vicidial_user_groups |
| vicidial_user_log |
| vicidial_users |
| vicidial_xfer_log |
| web_client_sessions |
+--------------------------------+
52 rows in set (0.00 sec)

ram

Posted: **Thu Aug 09, 2007 1:09 pm**

The the table names are little bit self explanatory .. ain't they ?

Posted: **Thu Aug 09, 2007 2:47 pm**

Hi
Thanks for the reply. The 2 tables I am specifically interested in is the VICIDIAL_LOG and VICIDIAL_AGENT_LOG.

I cannot figure out precisely what will be in the one table but not in the other

Posted: **Fri Aug 10, 2007 8:26 am**

vicidial_log is based on calls, vicidial_agent_log is based on agent activity. A call that is in vicidial_log will not go into vicidial_agent_log if it does not get sent to an agent.

Posted: **Mon Dec 10, 2007 11:05 pm**

vicidial_log are the history of calls made where information came from vicidial_list, whatever is inside the table vicidial_list, after calling them, history for those calls will be placed inside vicidial_logs. as you see, lead_id field would connect vicidial_list and vicidial_log, if u delete one row from the vicidial_list, u will be able to view again a number's history of calls under vicidial_log table.

vicidial_agent_log are the realtime activities of the agents since they started logging in and out then log in again and also the different statuses they were able to tag for each list. if u wanted to further analyze this table u wil really need to read each of its field just to give you an idea of the contents of that table.

vicidial.org

database tables

database tables