Table Relationships

The linkage between tables (i.e. the foreign key relationship) is as follows:

Sample Schema Column Descriptions:

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
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