Table Relationships

The linkage between tables (i.e. 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


Products | Support | Contact Us | Copyright Notices
© 2006-2014 All Rights Reserved. LEAD Technologies, Inc.