Page History

general_equipment_pk_id

bigint(19, 0)

-

Image Removed

-

manufacturer

varchar(64)

Nullable

Image Removed

-

institution_name

varchar(64)

Nullable

Image Removed

-

manufacturer_model_name

varchar(64)

Nullable

Image Removed

-

software_versions

varchar(64)

Nullable

Image Removed

-

institution_address

varchar(1024)

Nullable

Image Removed

-

station_name

varchar(16)

Nullable

Image Removed

-

device_serial_number

varchar(64)

Nullable

image_pk_id

bigint(19, 0)

-

Image Removed

-

instance_number

bigint(19, 0)

Nullable

Image Removed

-

content_date

date

Nullable

Image Removed

-

content_time

varchar(16)

Nullable

Image Removed

-

image_type

varchar(16)

Nullable

Image Removed

-

acquisition_date

date

Nullable

Image Removed

-

acquisition_time

varchar(16)

Nullable

Image Removed

-

acquisition_number

decimal(22, 6)

Nullable

Image Removed

-

lossy_image_compression

varchar(16)

Nullable

Image Removed

-

pixel_spacing

decimal(22, 6)

Nullable

Image Removed

-

image_orientation_patient

varchar(200)

Nullable

Image Removed

-

image_position_patient

varchar(200)

Nullable

Image Removed

-

slice_thickness

decimal(22, 6)

Nullable

Image Removed

-

slice_location

decimal(22, 6)

Nullable

Image Removed

-

i_rows

decimal(22, 6)

Nullable

Image Removed

-

i_columns

decimal(22, 6)

Nullable

Image Removed

-

contrast_bolus_agent

varchar(64)

Nullable

Image Removed

-

contrast_bolus_route

varchar(64)

Nullable

Image Removed

-

sop_class_uid

varchar(64)

Nullable

sop_instance_uid

varchar(64)

Nullable

Image Removed

-

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Image Removed

-

patient_position

varchar(16)

Nullable

Image Removed

-

source_to_detector_distance

decimal(22, 6)

Nullable

Image Removed

-

source_subject_distance

decimal(22, 6)

Nullable

Image Removed

-

focal_spot_size

decimal(22, 6)

Nullable

-

Name

Data type

Description / Attributes

Image Removed

-

storage_media_file_set_uid

varchar(64)

Nullable

Image Removed

-

dicom_file_uri

varchar(2000)

Nullable

Image Removed

-

acquisition_datetime

varchar(50)

Nullable

Image Removed

-

image_comments

varchar(4000)

Nullable

Image Removed

-

image_receiving_timestamp

datetime

Nullable

Image Removed

-

curation_timestamp

datetime

Nullable

Image Removed

-

annotation

varchar(20)

Nullable

Image Removed

submission_date

date

Nullable

Image Removed

-

dicom_size

decimal(22, 6)

Nullable

Image Removed

-

image_laterality

varchar(16)

Nullable

Image Removed

-

trial_dp_pk_id

bigint(19, 0)

Nullable

Image Removed

-

patient_id

varchar(64)

Nullable

Image Removed

-

study_instance_uid

varchar(500)

Nullable

Image Removed

-

series_instance_uid

varchar(64)

Nullable

Image Removed

-

patient_pk_id

bigint(19, 0)

Nullable References: patient

Image Removed

-

study_pk_id

bigint(19, 0)

Nullable References: study

Image Removed

-

project

varchar(200)

Nullable

Image Removed

-

acquisition_matrix

decimal(22, 6)

Nullable
Default: 0.000000

Image Removed

-

dx_data_collection_diameter

decimal(22, 6)

Nullable
Default: 0.000000

Image Removed

-

md5_digest

varchar(50)

Nullable

Image Removed

-

US_FRAME_NUMBER

varchar(50)

Nullable

Image Removed

-

US_COLOR_DATA_PRESENT

varchar(50)

Nullable

Image Removed

-

US_MULTI_MODALITY

varchar(50)

Nullable

general_series

general_image.general_series_pk_id = general_series.general_series_pk_id

fk_g_series_pk_id

patient

general_image.patient_pk_id = patient.patient_pk_id

FK_general_image_patient

study

general_image.study_pk_id = study.study_pk_id

FK_general_image_study

ct_image

general_image.image_pk_id = ct_image.image_pk_id

fk_image_pk_id

mr_image

general_image.image_pk_id = mr_image.IMAGE_PK_ID

FK_MR_GEN_IMAGE_PK_ID