Database Model (Graphical)
Permalink
I'm developing custom package within C5 using dasboard editing data. I also need to use custom attributes, sets etc within my code. I need a graphical database model if exists. I searched throug google and forums but could not find any.
It would be nice if i can see relations between tables. I tried to reverse engineer db with mysql gui tools and navicat, but could not manage to identify relationships. There is not any foreign key relationships defined in the database layer.
Could you please lead me to any link if you know any db model to understand table relationships.
Thanks.
By the way, I think C5 has a complex db schema to not to use foreign keys while using InnoDB, anyways this is an other discussion...
It would be nice if i can see relations between tables. I tried to reverse engineer db with mysql gui tools and navicat, but could not manage to identify relationships. There is not any foreign key relationships defined in the database layer.
Could you please lead me to any link if you know any db model to understand table relationships.
Thanks.
By the way, I think C5 has a complex db schema to not to use foreign keys while using InnoDB, anyways this is an other discussion...
I used Navicat and began with reverse engineer database to model. After that cleaning some tables that i do not need, i successfully created a minimized database model for blocks, pages, pagetypes and blocktypes etc. I think it is much more easier that way to understand block-blocktypes page-pagetype and collection relationships.
While I think this is a great way to understand the various relationships, and helps you also visualize /some/ of the models, I'm a bit scared of this request.
The APIs are models are available for a reason. You can do 99% of what you ever need by using the models. If you need to know the relationships for development reasons, then you're doing something wrong.
The APIs are models are available for a reason. You can do 99% of what you ever need by using the models. If you need to know the relationships for development reasons, then you're doing something wrong.
I disagree with other replies that visualizing a db is bad for development. I use it to organize a db before making a project. This is especially helpful when making a module using single pages etc for a specifically customized site.
Personally, I use mysql workbench (http://dev.mysql.com/downloads/tools/workbench/) and used it for my own CMS and now for C5.
That will allow you to build relationships using an EES diagram.
Personally, I use mysql workbench (http://dev.mysql.com/downloads/tools/workbench/) and used it for my own CMS and now for C5.
That will allow you to build relationships using an EES diagram.
I need to do some db work and having a db diagram would really be helpful.