how can i access and orthanc database structure

dear friends. i have a study to do using orthanc pacs server. i am suppose to do a Reverse engineering and obtain the structure of the orthanc database. please can some one help

Fozao,

I don’t know if there is formal documentation somewhere about that, but if you just install your own instance of Orthanc try it using SQLite, MySQL and Postgres for the database, then you can inspect the database structure yourself. It would be nice if there were some documentation somewhere about that, but if you have a DB tool like phpMyAdmin, pgAdmin, or SQLite, you’ll be able to inspect and sort of map out the DB for yourself.

You could maybe just even use a Docker Image, or otherwise install from a package manager and then sequentially load the different databases, but you’ll have to populate it the DB with a few studies also to understand the DB structure.

I attached a screen shot of the GUI from pgAdmin running on MacOS that show the Table structure for the Orthanc DB.

HTH

/sds

postgresorthanc.png

The nice thing about free and open-source software is that, well, it is precisely “open-source”.

There is nothing to reverse-engineer. You just have to look at the source code.

In your case:

https://hg.orthanc-server.com/orthanc/file/default/OrthancServer/Sources/Database/PrepareDatabase.sql

https://hg.orthanc-server.com/orthanc/file/tip/OrthancServer/Sources/Database/InstallTrackAttachmentsSize.sql

Nice to know.

i am just so grateful. i have been relieve by your prompt response.
my difficulty now is to generate the schema of the Conceptual and Logical models. that is the conceptual data model and the logical data model. thanks i m already woking on the code. before now i was struggling Apache2.4 which keeps on given a sries of errors because i wanted to install phpmyadmin for this database