database diagram

[Chris van der Westhuizen]

Does someone have a blesta database diagram showing primary/foreign key relations etc.?

It will save me time composing one for quick reference while developing modules/plugings.

Kind regards
Chris

[Chris van der Westhuizen]

i did create an EER Diagram using MySQL Workbench's Reverse Engineer option, but it is not linking the table fields. Although the naming of the tables and sub tables and fields is self explanatory, I am not sure if I should link an id of id_value field to an appropriate table without investigation, because there is no primary foreign key relations on the diagram, thus not in the db.

[katycomputer]

If I remember correctly, this is something the development team views as proprietary information.

Blesta is their product they are free to do what they want, but Blesta would be a much better product with readily available diagrams.

[Paul]

If I remember right, Cody architected the database originally on paper. I'm not sure if that paper still exists, and if it does it wouldn't be complete now. If I had a diagram, I'd be happy to share it, but I don't. We should probably make one we can add to the dev docs though.

[katycomputer]

Paul: I apologize for mis-representing your position on the data diagram - not sure where I got the idea that the diagram is proprietary. 

Where are the dev docs saved?

[Paul]

9 hours ago, katycomputer said:

Paul: I apologize for mis-representing your position on the data diagram - not sure where I got the idea that the diagram is proprietary. 

Where are the dev docs saved?

Dev docs are a section of our documentation at https://docs.blesta.com/display/dev

[Tyson]

On 4/25/2018 at 3:22 AM, Chris van der Westhuizen said:

I am not sure if I should link an id of id_value field to an appropriate table without investigation

Don't link an `id_value` column to anything. It relates no table records, rather it is a derived value used in conjunction with `id_format`.

[Chris van der Westhuizen]

Thank you Tyson.  I completed as complete as possible the EER_Diagram on MySQL Workbench, but do have +/- 10 relationships I am not sure about.  Should I attach the wbs, sql, pdf copy of the layout with the questions here, or should I rather email these files first that we upload them here when done, or make them part of the documentation?  I think if I had something like this, I would have been on the road to success long ago.  I'm not complaining, Thank you very much for the current documentation it helped me very much, as well as this forum. ?

[Paul]

I'd say go ahead and attach the MySQL Workbench file so we can open it, and maybe Tyson can help with those remaining relationships. I'd love to keep a copy of the file on hand, so we can update it going forward, and provide a visual and download within the documentation. Really appreciate the contribution!

[Paul]

On second thought, please PM the file to me or email to sales@. There is some internal debate as to whether we should publish this, so better if it's not public just yet.

[Chris van der Westhuizen]

Hi Paul, my thought too, that's why I did not post it.  I'll email you tomorrow South African time (GM+2) when I'm back at work.

[Chris van der Westhuizen]

Hi Paul, files left the building ?  See your email box. I hope you will like my spiderweb compilation ?

[Blesta Addons]

13 hours ago, Chris van der Westhuizen said:

Hi Paul, files left the building ?  See your email box. I hope you will like my spiderweb compilation ? 

Hope we can see it in the sky soon for all users can see it online.

[Paul]

13 hours ago, Chris van der Westhuizen said:

Hi Paul, files left the building ?  See your email box. I hope you will like my spiderweb compilation ?

Yes, it is very spiderwebby indeed. ? Fortunately the relationship notation can be changed from spiderweb to UML ?

I forwarded you Tyson's response to your questions.

[Chris van der Westhuizen]

Thank you Paul for the quick response. 

Okey.  The semi-good news is, I sent the semi-final version by email to you.  I have a few more questions there, and as soon as we can have that sorted then newbies on Blesta, like me, can advance fast ?