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 |
Raster .NET | C API | C++ Class Library | JavaScript HTML5
Document .NET | C API | C++ Class Library | JavaScript HTML5
Medical .NET | C API | C++ Class Library | JavaScript HTML5
Medical Web Viewer .NET