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
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
...
Study
Series
...
- - 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-many 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 relationship to the Series entity;