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
...
Study
Series
...
- - 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