So at this point I am trying to analyze in depth the ehrbase construction regarding the relations. My setup for now is full environment for fhir bridge and the issue is that I am not able to check the relations for postgres/ehrbase user. Although I am creating templates/ehr’s, there is always “Did not find any relations.”. I am not very into java/spring framework (I am doing as python junior), so I guess there is some spring flavour as the reason, but I can not find anything on that. What is the proper setting for checking relations in fhir bridge (running as docker container)?
I completely support that suggestion. CDRs are supposed to be queried via the domain information model using AQL or equivalent. The db schema will really not help you as it is designed at very low level to be static and unchanging. That might be interesting if you want to build a CDR, but f you just want to consume the data from a CDR you really do not want to go there!!
Sure, always great to be able to look under the hood, but you may consider using something that’s more efficient and visual for exploratory purposes. DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains is my favorite. 30 days trial free. Postgres had its own free tool (gui) for ages, I’m guessing it’s still around. Or anything else that’ll show you the schemas and and relations in them.