Mercurial > hg > orthanc-book
diff Sphinx/source/faq/orthanc-storage.rst @ 272:07f109e3f3f7
database schema
author | Sebastien Jodogne <s.jodogne@gmail.com> |
---|---|
date | Fri, 30 Aug 2019 09:22:34 +0200 |
parents | 365427cebb64 |
children | 6cbcdb965ad3 |
line wrap: on
line diff
--- a/Sphinx/source/faq/orthanc-storage.rst Wed Aug 28 18:18:11 2019 +0200 +++ b/Sphinx/source/faq/orthanc-storage.rst Fri Aug 30 09:22:34 2019 +0200 @@ -51,6 +51,18 @@ the Orthanc core, whereas identifiers >= 1024 can be user-defined for external applications. +Besides the attachments, the database index maintains other +information for each DICOM resource, notably the :ref:`metadata +<metadata>`, the :ref:`history of changes <changes>`, and an +associative map that stores the so-called "main" DICOM tags (to avoid +accessing the storage folder are when this is not needed). The SQLite +database schema is kept as simple as possible, and can be found in the +following two files of the source code of Orthanc: +`PrepareDatabase.sql +<https://bitbucket.org/sjodogne/orthanc/src/Orthanc-1.5.7/OrthancServer/Database/PrepareDatabase.sql>`__ +and `InstallTrackAttachmentsSize.sql +<https://bitbucket.org/sjodogne/orthanc/src/Orthanc-1.5.7/OrthancServer/Database/InstallTrackAttachmentsSize.sql>`__. + Direct access -------------