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
...
- images - to-many relationship to the Image entity;
- study - to-many 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-many one relationship to the Series entity;