Page tree
Skip to end of metadata
Go to start of metadata

The database index is stored using the following database scheme. This information is available to you because it might come useful when constructing advanced SQL queries in the Predicate Format String Syntax.

Album ↔︎ Study ↔︎ Series ↔︎ Image

Album

Attributes:

  • index - integer
  • name - string
  • predicateString - string
  • smartAlbum - boolean

Relationships:

  • studies - to-many relationship to the Study entity

Study

Attributes:

  • accessionNumber - string
  • comment - string
  • comment2 - string
  • comment3 - string
  • comment4 - string
  • date - date
  • dateAdded - date
  • dateOfBirth - date
  • dateOpened - date
  • dictateURL - string
  • expanded - boolean
  • hasDICOM - boolean
  • id - string
  • institutionName - string
  • lockedStudy - boolean
  • modality - string
  • name - string
  • numberOfImages - integer
  • patientID - string
  • patientSex - string
  • patientUID - string
  • performingPhysician - string
  • referringPhysician - string
  • reportURL - string
  • stateText - integer
  • studyInstanceUID - string
  • studyName - string
  • windowsState - blob


Relationships:

  • albums - to-many relationship to the Album entity
  • series - to-many relationship to the Series entity

Series

Attributes:

  • comment - string
  • comment2 - string
  • comment3 - string
  • comment4 - string
  • date - date
  • dateAdded - date
  • dateOpened - date
  • displayStyle - integer
  • id - integer
  • keySeries - boolean
  • modality - string
  • mountedVolume - boolean
  • name - string
  • numberOfImages - integer
  • numberOfKeyImages - integer
  • rotationAngle - real
  • scale - real
  • seriesDescription - string
  • seriesDICOMUID - string
  • seriesInstanceUID - string
  • seriesSOPClassUID - string
  • stateText - integer
  • thumbnail - blob
  • windowLevel - real
  • windowWidth - real
  • xFlipped - boolean
  • xOffset - real
  • yFlipped - boolean
  • yOffset - real

Relationships:

  • images - to-many relationship to the Image entity
  • study - to-one relationship to the Study entity

Image

Attributes:

  • comment - string
  • comment2 - string
  • comment3 - string
  • comment4 - string
  • compressedSopInstanceUID - blob
  • date - date
  • frameID - integer
  • generatedByOsiriX - boolean
  • importedFile - boolean
  • instanceNumber - integer
  • pathNumber - integer
  • pathString - string
  • rotationAngle - real
  • scale - real
  • sliceLocation - real
  • stateText - string
  • storedExtension - string
  • storedFileType - string
  • storedHeight - integer
  • storedInDatabaseFolder - boolean
  • storedIsKeyImage - boolean
  • storedModality - string
  • storedMountedVolume - boolean
  • storedNumberOfFrames - integer
  • storedNumberOfSeries - integer
  • storedWidth - integer
  • windowLevel - real
  • windowWidth - real
  • xFlipped - boolean
  • xOffset - real
  • yFlipped - boolean
  • yOffset - real
  • zoom - real

Relationships:

  • series - to-one relationship to the Series entity
  • No labels