Page History

general_series_pk_id

bigint(19, 0)

-

Image Removed

-

modality

varchar(16)

Image Removed

-

series_instance_uid

varchar(64)

Nullable

Image Removed

-

series_laterality

varchar(16)

Nullable

Image Removed

-

series_date

date

Nullable

Image Removed

-

protocol_name

varchar(64)

Nullable

Image Removed

-

series_desc

varchar(64)

Nullable

Image Removed

-

body_part_examined

varchar(16)

Nullable

Image Removed

-

study_pk_id

bigint(19, 0)

Nullable References: study

Image Removed

-

general_equipment_pk_id

bigint(19, 0)

Nullable
References: general_equipment

Image Removed

-

trial_protocol_id

varchar(64)

Nullable

Image Removed

-

trial_protocol_name

varchar(64)

Nullable

Image Removed

-

trial_site_name

varchar(64)

Nullable

Image Removed

-

study_date

date

Nullable

Image Removed

-

study_desc

varchar(64)

Nullable

Image Removed

-

admitting_diagnoses_desc

varchar(64)

Nullable

Image Removed

-

patient_age

varchar(4)

Nullable

Image Removed

-

patient_sex

varchar(16)

Nullable

Image Removed

-

patient_weight

decimal(22, 6)

Nullable

Image Removed

-

age_group

varchar(10)

Nullable

Image Removed

-

patient_pk_id

bigint(19, 0)

Nullable

Image Removed

-

series_number

decimal(22, 6)

Nullable

Image Removed

-

sync_frame_of_ref_uid

varchar(64)

Nullable

Image Removed

-

patient_id

varchar(64)

Nullable

Image Removed

-

frame_of_reference_uid

varchar(64)

Nullable

Image Removed

-

visibility

varchar(5)

Nullable

Image Removed

-

security_group

varchar(50)

Nullable

Image Removed

-

annotations_flag

varchar(5)

Nullable

-

Name

Data type

Description / Attributes

Image Removed

-

project

varchar(200)

Nullable

Image Removed

-

site

varchar(40)

Nullable

Image Removed

-

study_instance_uid

varchar(500)

Nullable

Image Removed

-

max_submission_timestamp

datetime

Nullable

Image Removed

-

batchNum

int(10, 0)

Nullable

Image Removed

-

submission_type

varchar(100)

Nullable

Image Removed

-

released_status

varchar(50)

Nullable

Image Removed

-

third_party_analysis

varchar(4)

Nullable

Image Removed

-

description_uri

varchar(500)

Nullable

general_equipment

general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id

fk_g_equipment_pk_id

study

general_series.study_pk_id = study.study_pk_id

fk_gs_study_pk_id

ct_image

general_series.general_series_pk_id = ct_image.general_series_pk_id

ct_image_ibfk_1

general_image

general_series.general_series_pk_id = general_image.general_series_pk_id

fk_g_series_pk_id

mr_image

general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID

FK_MR_GEN_SERIES_PK_ID

GUI_ACTION_HISTORY_PK_ID

bigint(19, 0)

Default: 0

Image Removed

-

ACTION_TIMESTAMP

date

Nullable

Image Removed

-

ACTION

varchar(255)

Nullable

login_history_pk_id

bigint(19, 0)

-

Image Removed

-

login_timestamp

datetime

Nullable

Image Removed

-

ip_address

varchar(15)

Nullable

modality_descriptions_pk_id

bigint(19, 0)

-

Image Removed

-

modality_name

varchar(20)

Nullable

Image Removed

-

description

mediumtext

Nullable

modality_descriptions_pk_id

PRIMARY

modality_descriptions_pk_id

MD_COLLECTION_DESC_PK_ID

Image Removed

-

IMAGE_TYPE_VALUE_3

varchar(16)

-

Image Removed

-

SCANNING_SEQUENCE

varchar(126)

-

Image Removed

-

SEQUENCE_VARIANT

varchar(126)

-

Image Removed

-

REPETITION_TIME

decimal(22, 10)

Nullable

Image Removed

-

ECHO_TIME

decimal(22, 10)

Nullable

Image Removed

-

INVERSION_TIME

decimal(22, 10)

Nullable

Image Removed

-

SEQUENCE_NAME

varchar(64)

Nullable

Name

-

Data type

Description / Attributes

Image Removed

IMAGED_NUCLEUS

varchar(64)

Nullable

Image Removed

-

MAGNETIC_FIELD_STRENGTH

decimal(22, 10)

Nullable

Image Removed

-

SAR

decimal(22, 10)

Nullable

Image Removed

-

DB_DT

decimal(22, 10)

Nullable

Image Removed

-

TRIGGER_TIME

decimal(22, 10)

Nullable

Image Removed

-

ANGIO_FLAG

varchar(1)

Nullable

Image Removed

-

IMAGE_PK_ID

bigint(19, 0)

References: general_image

MR_IMAGE_PK_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

-

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable
References: general_series