The database index is stored using the following database scheme:
Album
Study
Series
...
. 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