The linkage between tables (that is, the foreign key relationship) is as follows:
Column |
Description |
DICOM Element |
PatientId |
Auto-generated primary key |
None |
PatientIdentification |
Patient ID |
0010:0020 |
PatientName |
Patient’s name. |
0010:0010 |
PatientBirthday |
Patient’s Birth Date |
0010:0030 |
PatientSex |
Patient’s Sex |
0010:0040 |
PatientComments |
Patient Comments |
0010:4000 |
Column |
Description |
DICOM Element |
StudyId |
Auto-generated primary key |
None |
StudyPatientId |
Foreign key to MyPatientTable |
None |
StudyStudyInstanceUID |
Study Instance Unique ID |
0020:000D |
StudyStudyDate |
Study Date |
0008:0020 |
StudyAccessionNumber |
Accession Number |
0008:0050 |
StudyStudyDescription |
Study Description |
0008:1030 |
StudyReferringPhysiciansName |
Referring Physician’s Name |
0008:0090 |
StudyStudyId |
Study ID |
0020:0010 |
Column |
Description |
DICOM Element |
SeriesId |
Auto-generated primary key |
None |
SeriesStudyId |
Foreign key to MyStudyTable |
None |
SeriesSeriesInstanceUID |
Series Instance Unique ID |
0020:000E |
SeriesBodyPartExamined |
Body Part Examined |
0018:0015 |
SeriesSeriesNumber |
Series Number |
0020:0011 |
SeriesSeriesDescription |
Series Description |
0008:103E |
SeriesSeriesDate |
Series Date |
0008:0021 |
SeriesModality |
Modality |
0008:0060 |
Column |
Description |
DICOM Element |
ImageId |
Auto-generated primary key |
None |
ImageSeriesId |
Foreign key to MySeriesTable |
None |
SOPInstanceUID |
SOP Instance UID |
0008:0018 |
ImageImageNumber |
Instance Number |
0020:0013 |
ImageLastStoreDate |
Date the instance was stored. This field is used in the Database Manager search screen, with the Storage Date options |
None |
ImageFilename |
Full path to DICOM file |
None |
ImageUniqueSOPClassUID |
SOP Class Unique ID |
0008:0016 |
ImageRows |
Number of rows in image |
0028:0010 |
ImageColumns |
Number of columns in image |
0028:0011 |
ImageBitsAllocated |
Bits allocated in image |
0028:0100 |
Help Collections
Raster .NET | C API | C++ Class Library | HTML5 JavaScript
Document .NET | C API | C++ Class Library | HTML5 JavaScript
Medical .NET | C API | C++ Class Library | HTML5 JavaScript
Medical Web Viewer .NET
Multimedia
Direct Show .NET | C API | Filters
Media Foundation .NET | C API | Transforms
Supported Platforms
.NET, Java, Android, and iOS/macOS Assemblies
Imaging, Medical, and Document
C API/C++ Class Libraries
Imaging, Medical, and Document
HTML5 JavaScript Libraries
Imaging, Medical, and Document
Your email has been sent to support! Someone should be in touch! If your matter is urgent please come back into chat.
Chat Hours:
Monday - Friday, 8:30am to 6pm ET
Thank you for your feedback!
Please fill out the form again to start a new chat.
All agents are currently offline.
Chat Hours:
Monday - Friday
8:30AM - 6PM EST
To contact us please fill out this form and we will contact you via email.