Table Relationships
The linkage between tables (that is, the foreign key relationship) is as follows:
Patient-Study Relationship
Study-Series Relationship
Series-Instance Relationship
Sample Schema Column Descriptions:
MyPatientTable
|
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 |
MyStudyTable
|
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 |
MySeriesTable
|
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 |
MyInstanceTable
|
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 |
