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
...
- 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
...
- images - to-many relationship to the Image entity
- study - to-many one relationship to the Study entity
...
Relationships:
- series - to-many one relationship to the Series entity