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
 -------------