Re: [Health-dev] Diagram of GNU Health postgresql tables

[Gerald Wiese]

Hi Luis,

Yannick and me had a look at this and we had to resolve missing 
dependencies.

After installing pydot using pip and graphviz as a system package it was 
working. On Ubuntu simply "pip install pydot" & "sudo apt install graphviz".

Not sure if this is a problem in every installation method. He used my 
ansible scripts and PyPI package gnuhealth-all-modules. In mercurial 
repos I can't find "pydot" or "graphviz" either.

Best

Gerald

On 29.09.22 21:16, Luis Falcon wrote:
> Dear Yannick
> On Thu, 29 Sep 2022 20:37:29 +0200
> Yannick Busse <yannick.busse@stud.uni-hannover.de> wrote:
>
> > Hello,
> >
> > I am currently working on a project for my university for which I
> > need to build queries for the postgresql of GNU Health. While looking
> > through I've seen there to be around 160+ public tables and I was
> > wondering, if there would happen to be a diagram of the postgresql
> > database that would show the dependencies and references between the
> > tables? For example what tables all contain information for patients,
> > etc.
> >
> > To get a better overview over the database would help my work a lot.
> Thanks for reaching out! The models UML diagrams are accessible from the
> GH client (Administration -> Models and use the Graph Report action).
>
> I'm attaching one example here of a Level 1 graph of the patient as an
> example.
>
> Best regards
> Luis
>
>