Forums

Where can I find ER diagrams for C5 database?

Permalink
This may have been asked before but I couldn't find an answer. So I am asking again. Where can I find ER diagrams for C5 database? or do I need to create one myself?

Thanks
BlueFractals
 
JohntheFish replied on at Permalink Reply
JohntheFish
As far as I know you have to read the SQL and work it out for yourself. Not just SQL, because some of the relationships are maintained by php rather than just in SQL.

If you do work this out, please publish it for the rest of us to enjoy the benefits.
mkly replied on at Permalink Reply
mkly
This should be interesting. Most people don't work with core database stuff via the database. It's not really written to be used that way. But it would be nice to have. Go for it!
BlueFractals replied on at Permalink Reply
BlueFractals
Thanks for the replies.

Which tool is best to create an ERD?
I am using phpMyAdmin. There is a Designer View feature in it.
I've heard of MySQL Workshop. Not sure how good this is though.
lawsonium replied on at Permalink Reply
I'd be interested to help with this.
Rather than re-inventing the proverbial wheel, has anyone made a start?
If not, I don't have the time to just sit at it for hours so I will attempt to tackle it in stages.