database tables

[louie]

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

Thanks

[mflorell]

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.

[ramindia]

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

[aster1]

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

[louie]

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

[mflorell]

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.

[prolixus]

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.