Skip to main content

Table 1 Structure of the Image database table

From: OSPACS: Ultrasound image management system

 

Column Name

Condensed Type

Nullable

PK

ImageID

uniqueidentifier

No

 

CaptureDate

datetime

Yes

 

StoredDate

datetime

Yes

 

StoredBy

varchar(50)

Yes

 

DiskRef

varchar(50)

Yes

 

VolunteerRef

int

Yes

 

DicomRef

varchar(64)

Yes

 

DicomFile

image

Yes

 

DicomFileSize

int

Yes

 

MaskFile

varchar(255)

Yes

 

Flags

varbinary(10)

Yes

  1. PK indicates the Primary Key.