Database Relationship Diagram

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

Database Relationship Diagram

Postby mmiller » Fri Sep 09, 2011 12:19 pm

Hello,

Does anyone have a diagram of the mysql tables underlying Vicidial?

I was able to generate a basic diagram using mysql workbench, but that doesn't show the relationships between tables.

Can anyone point me toward an automated way of showing the table relationships or share their diagram?

The end goal I seek is to generate custom reports.

Thanks,

Malik
mmiller
 
Posts: 4
Joined: Fri Sep 09, 2011 11:52 am

Postby mflorell » Fri Sep 09, 2011 5:23 pm

There currently is no relational diagram, but most of the fields that have the same name in different tables are linked, like:
- lead_id
- user
- campaign_id
- uniqueid
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby williamconley » Fri Sep 09, 2011 9:33 pm

if there were a way to generate a diagram in a mediawiki i could open a page to several users to construct one on viciwiki and move it to the Vicidial Wiki when it's done (and not been attacked). But I'm not sure there's an appropriate language to allow collaboration on such an item.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

re: db diagram

Postby jdcsyoung » Thu Oct 06, 2011 8:44 am

I am in the exact same boat. I am also using the workbench to try and figure things out. It is tedious at best.

Is there better information on the tables and relationships in the pay-for documentation?
jdcsyoung
 
Posts: 3
Joined: Tue Sep 20, 2011 8:51 am

Postby mmiller » Thu Oct 06, 2011 9:06 am

In order to break through the tedium I have created an excel spreadsheet which shows all of the field names that appear in more than one table along with the table names that they appear in.

I think this will help with mapping the database, but I haven't started mapping it yet.

If you would like a copy of the spreadsheet, private message me with your email address and I will send it to you.

Cheers, Malik
mmiller
 
Posts: 4
Joined: Fri Sep 09, 2011 11:52 am

Postby mflorell » Thu Oct 06, 2011 9:35 am

You can always post it to the Issue Tracker as well if you want.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby mmiller » Thu Oct 06, 2011 9:43 am

I just created an account for the Issue tracker, but I am not sure where to upload the excel sheet.

Any direction that can be provided would be much appreciated.

Thanks, Malik
mmiller
 
Posts: 4
Joined: Fri Sep 09, 2011 11:52 am

Postby mflorell » Thu Oct 06, 2011 10:23 am

Create a new issue and add it as an attachment to that issue.
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby mmiller » Thu Oct 06, 2011 11:02 am

Ok, the spreadsheet is now posted here:

http://www.vicidial.org/VICIDIALmantis/view.php?id=523

Any help with creating the map would be much appreciated.

Thanks, Malik
mmiller
 
Posts: 4
Joined: Fri Sep 09, 2011 11:52 am

Re:

Postby rogelio@boom.ai » Wed Aug 24, 2022 4:04 pm

mmiller wrote:Ok, the spreadsheet is now posted here:

http://www.vicidial.org/VICIDIALmantis/view.php?id=523

Any help with creating the map would be much appreciated.

Thanks, Malik


Im unable to access to that link (it requires additional login) could you share this in some other way please?
rogelio@boom.ai
 
Posts: 1
Joined: Wed Aug 24, 2022 11:56 am

Re: Database Relationship Diagram

Postby carpenox » Mon Aug 29, 2022 12:33 pm

just sign up at that link
Alma Linux 9.3 | Version: 2.14-911a | SVN Version: 3815 | DB Schema Version: 1710 | Asterisk 18.18.1
www.dialer.one -:- 1-833-DIALER-1 -:- https://linktr.ee/CyburDial -:- WhatsApp: +19549477572 -:- Skype: live:carpenox_3
carpenox
 
Posts: 2230
Joined: Wed Apr 08, 2020 2:02 am
Location: Coral Springs, FL


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 48 guests