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

[Luis Falcon]

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

gnuhealth_uml_patient_health_core_level1.png
Description: PNG image