Mercurial > hg > orthanc-book
changeset 272:07f109e3f3f7
database schema
| author | Sebastien Jodogne <s.jodogne@gmail.com> |
|---|---|
| date | Fri, 30 Aug 2019 09:22:34 +0200 |
| parents | 1173e40cbf35 |
| children | 869d6efbb54c |
| files | Sphinx/source/faq/orthanc-storage.rst |
| diffstat | 1 files changed, 12 insertions(+), 0 deletions(-) [+] |
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 -------------