Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Anything that you think should be in Cacti.
Moderators: Developers , Moderators
JT
Post
by JT Wed Jun 11, 2003 10:54 am
I'd like to see a diagram of the table relationships.
wasabi
Posts: 7 Joined: Fri Jul 11, 2003 6:41 pm
Post
by wasabi Fri Jul 18, 2003 1:44 pm
I'm currently working on this. If anybody would like to help it would make this easier on me:)
raX
Lead Developer
Posts: 2243 Joined: Sat Oct 13, 2001 7:00 pmLocation: Carlisle, PA
Contact:
Post
by raX Mon Jul 21, 2003 12:48 pm
I would be more than happy to make one... I just have no idea what program to use. Anyone have any ideas?
kmpanilla
Posts: 7 Joined: Sat May 11, 2002 12:31 pm
Post
by kmpanilla Mon Jul 21, 2003 1:35 pm
phpMyAdmin does some nice PDF schema generation of tables.
raX
Lead Developer
Posts: 2243 Joined: Sat Oct 13, 2001 7:00 pmLocation: Carlisle, PA
Contact:
Post
by raX Mon Jul 21, 2003 4:13 pm
Alright, I will work in it right now once I get phpMyAdmin to output PDFs.
raX
Lead Developer
Posts: 2243 Joined: Sat Oct 13, 2001 7:00 pmLocation: Carlisle, PA
Contact:
Post
by raX Mon Jul 21, 2003 5:17 pm
OK I am finished with my first revision. You can download it here:
http://www.raxnet.net/downloads/database-schema/
Feel free to use the provided 'phpMyAdmin.sql' to modify the provided PDF. My Cacti development database is named 'dev_cacti_2'.
-Ian
wasabi
Posts: 7 Joined: Fri Jul 11, 2003 6:41 pm
Post
by wasabi Wed Jul 23, 2003 7:00 pm
I like this. Thanks alot. I didnt know phpmyadmin did this.
wasabi
Posts: 7 Joined: Fri Jul 11, 2003 6:41 pm
Post
by wasabi Thu Jul 24, 2003 3:09 pm
One thing I didnt see any metion to the host table in this diagram is that not relavent or is this not the 0.8.2a database?
raX
Lead Developer
Posts: 2243 Joined: Sat Oct 13, 2001 7:00 pmLocation: Carlisle, PA
Contact:
Post
by raX Fri Jul 25, 2003 12:28 am
For some reason I forgot to add foreign key information for the host* tables. This has been fixed and they have been added to the database diagram.
Guest
Post
by Guest Fri Jul 25, 2003 11:04 am
Thanks I am a beginner with mysql I hope to be able to do these things someday.
jlancaster
Posts: 38 Joined: Tue Feb 04, 2003 12:05 pmLocation: Dallas, TX
Contact:
Post
by jlancaster Tue Aug 05, 2003 7:47 am
Ian, check out DeZign for Databases (
http://www.datanamic.com/ ). It is a very inexpensive ERD tool. I've been using it for a couple of months after someone turned me on to it. It is a really, really, useful tool--all the way down to writing the sql scripts for table creation for you.
I also found a tool called TopStyle Pro (
http://www.bradsoft.com/topstyle/ ) for creating, editing, managing style sheets. It has helped me tremendously in the projects I've used it on.
Jim
Users browsing this forum: No registered users and 0 guests