# HG changeset patch
# User Sebastien Jodogne <s.jodogne@gmail.com>
# Date 1567149754 -7200
# Node ID 07f109e3f3f7e89c9a9779b1b014c23c26c2b94b
# Parent  1173e40cbf35e399c0b1f3fbcbb76753d12f35d4
database schema

diff -r 1173e40cbf35 -r 07f109e3f3f7 Sphinx/source/faq/orthanc-storage.rst
--- 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
 -------------