Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Table: download_data_history

CKK: Start here
Columns

Name	Data type	Description / Attributes
download_data_history_pk_id	bigint(19, 0)
series_instance_uid	varchar(64)	Nullable
login_name	varchar(100)	Nullable
download_timestamp	date	Nullable
download_type	varchar(20)	Nullable
size_	decimal(22, 2)	Nullable

...

	Columns	Name / Description
Image Modified	download_data_history_pk_id	PRIMARY

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	download_history_pk_id	bigint(19, 0)
	user_id	bigint(19, 0)	Nullable
	timestamp	datetime	Nullable
	total_file_size	decimal(22, 2)	Nullable
	download_file_name	varchar(300)	Nullable

...

	Columns	Name / Description
Image Modified	download_history_pk_id	PRIMARY

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	general_equipment_pk_id	bigint(19, 0)
	manufacturer	varchar(64)	Nullable
	institution_name	varchar(64)	Nullable
	manufacturer_model_name	varchar(64)	Nullable
	software_versions	varchar(64)	Nullable
	institution_address	varchar(1024)	Nullable
	station_name	varchar(16)	Nullable
	device_serial_number	varchar(64)	Nullable

...

	Columns	Name / Description
Image Modified	general_equipment_pk_id	PRIMARY
	general_equipment_pk_id	PK_G_EQUIPMENT_ID

Table: general_image

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	image_pk_id	bigint(19, 0)
	instance_number	bigint(19, 0)	Nullable
	content_date	date	Nullable
	content_time	varchar(16)	Nullable
	image_type	varchar(16)	Nullable
	acquisition_date	date	Nullable
	acquisition_time	varchar(16)	Nullable
	acquisition_number	decimal(22, 6)	Nullable
	lossy_image_compression	varchar(16)	Nullable
	pixel_spacing	decimal(22, 6)	Nullable
	image_orientation_patient	varchar(200)	Nullable
	image_position_patient	varchar(200)	Nullable
	slice_thickness	decimal(22, 6)	Nullable
	slice_location	decimal(22, 6)	Nullable
	i_rows	decimal(22, 6)	Nullable
	i_columns	decimal(22, 6)	Nullable
	contrast_bolus_agent	varchar(64)	Nullable
	contrast_bolus_route	varchar(64)	Nullable
	sop_class_uid	varchar(64)	Nullable
	sop_instance_uid	varchar(64)	Nullable
	general_series_pk_id	bigint(19, 0)	Nullable References: general_series
	patient_position	varchar(16)	Nullable
	source_to_detector_distance	decimal(22, 6)	Nullable
	source_subject_distance	decimal(22, 6)	Nullable
	focal_spot_size	decimal(22, 6)	Nullable
	Name	Data type	Description / Attributes
	storage_media_file_set_uid	varchar(64)	Nullable
	dicom_file_uri	varchar(2000)	Nullable
	acquisition_datetime	varchar(50)	Nullable
	image_comments	varchar(4000)	Nullable
	image_receiving_timestamp	datetime	Nullable
	curation_timestamp	datetime	Nullable
	annotation	varchar(20)	Nullable
	submission_date	date	Nullable
	dicom_size	decimal(22, 6)	Nullable
	image_laterality	varchar(16)	Nullable
	trial_dp_pk_id	bigint(19, 0)	Nullable
	patient_id	varchar(64)	Nullable
	study_instance_uid	varchar(500)	Nullable
	series_instance_uid	varchar(64)	Nullable
	patient_pk_id	bigint(19, 0)	Nullable References: patient
	study_pk_id	bigint(19, 0)	Nullable References: study
	project	varchar(200)	Nullable
	acquisition_matrix	decimal(22, 6)	Nullable Default: 0.000000
	dx_data_collection_diameter	decimal(22, 6)	Nullable Default: 0.000000
	md5_digest	varchar(50)	Nullable
	US_FRAME_NUMBER	varchar(50)	Nullable
	US_COLOR_DATA_PRESENT	varchar(50)	Nullable
	US_MULTI_MODALITY	varchar(50)	Nullable

Links to

Table	Join	Title / Name / Description
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

Linked from

	Table	Join	Title / Name / Description
	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

Unique keys

	Columns	Name / Description
Image Modified	image_pk_id	PRIMARY
	image_pk_id, submission_date	Image_Visibility_Submitted_IDX
	image_pk_id	PK_IMAGE_PK_ID
	sop_instance_uid	sop_instance_uid

Table: general_series

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	general_series_pk_id	bigint(19, 0)
	modality	varchar(16)
	series_instance_uid	varchar(64)	Nullable
	series_laterality	varchar(16)	Nullable
	series_date	date	Nullable
	protocol_name	varchar(64)	Nullable
	series_desc	varchar(64)	Nullable
	body_part_examined	varchar(16)	Nullable
	study_pk_id	bigint(19, 0)	Nullable References: study
	general_equipment_pk_id	bigint(19, 0)	Nullable References: general_equipment
	trial_protocol_id	varchar(64)	Nullable
	trial_protocol_name	varchar(64)	Nullable
	trial_site_name	varchar(64)	Nullable
	study_date	date	Nullable
	study_desc	varchar(64)	Nullable
	admitting_diagnoses_desc	varchar(64)	Nullable
	patient_age	varchar(4)	Nullable
	patient_sex	varchar(16)	Nullable
	patient_weight	decimal(22, 6)	Nullable
	age_group	varchar(10)	Nullable
	patient_pk_id	bigint(19, 0)	Nullable
	series_number	decimal(22, 6)	Nullable
	sync_frame_of_ref_uid	varchar(64)	Nullable
	patient_id	varchar(64)	Nullable
	frame_of_reference_uid	varchar(64)	Nullable
	visibility	varchar(5)	Nullable
	security_group	varchar(50)	Nullable
	annotations_flag	varchar(5)	Nullable
	Name	Data type	Description / Attributes
	project	varchar(200)	Nullable
	site	varchar(40)	Nullable
	study_instance_uid	varchar(500)	Nullable
	max_submission_timestamp	datetime	Nullable
	batchNum	int(10, 0)	Nullable
	submission_type	varchar(100)	Nullable
	released_status	varchar(50)	Nullable
	third_party_analysis	varchar(4)	Nullable
	description_uri	varchar(500)	Nullable

Links to

	Table	Join	Title / Name / Description
	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

Linked from

Table	Join	Title / Name / Description
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

Unique keys

	Columns	Name / Description
Image Modified	general_series_pk_id	PRIMARY
	general_series_pk_id	PK_G_SERIES_PK_ID
	series_instance_uid	series_instance_uid

Table: gui_action_history

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	GUI_ACTION_HISTORY_PK_ID	bigint(19, 0)	Default: 0
	ACTION_TIMESTAMP	date	Nullable
	ACTION	varchar(255)	Nullable

Unique keys

	Columns	Name / Description
Image Modified	GUI_ACTION_HISTORY_PK_ID	PRIMARY

Table: hibernate_unique_key

Columns

		Name	Data type	Description / Attributes
		next_hi	bigint(19, 0)

Table: login_history

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	login_history_pk_id	bigint(19, 0)
	login_timestamp	datetime	Nullable
	ip_address	varchar(15)	Nullable

Unique keys

	Columns	Name / Description
Image Modified	login_history_pk_id	PRIMARY
	login_history_pk_id	PK_LOGIN_HISTORY_PK_ID

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	modality_descriptions_pk_id	bigint(19, 0)
	modality_name	varchar(20)	Nullable
	description	mediumtext	Nullable

...

	Columns	Name / Description
	modality_descriptions_pk_id	PRIMARY
	modality_descriptions_pk_id	MD_COLLECTION_DESC_PK_ID

Table: mr_image

Columns

Name	Data type	Description / Attributes
IMAGE_TYPE_VALUE_3	varchar(16)
SCANNING_SEQUENCE	varchar(126)
SEQUENCE_VARIANT	varchar(126)
REPETITION_TIME	decimal(22, 10)	Nullable
ECHO_TIME	decimal(22, 10)	Nullable
INVERSION_TIME	decimal(22, 10)	Nullable
SEQUENCE_NAME	varchar(64)	Nullable
Name	Data type	Description / Attributes
IMAGED_NUCLEUS	varchar(64)	Nullable
MAGNETIC_FIELD_STRENGTH	decimal(22, 10)	Nullable
SAR	decimal(22, 10)	Nullable
DB_DT	decimal(22, 10)	Nullable
TRIGGER_TIME	decimal(22, 10)	Nullable
ANGIO_FLAG	varchar(1)	Nullable
IMAGE_PK_ID	bigint(19, 0)	References: general_image
MR_IMAGE_PK_ID	bigint(19, 0)	Identity / Auto increment
GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable References: general_series

Links to

	Table	Join	Title / Name / Description
	general_image	mr_image.IMAGE_PK_ID = general_image.image_pk_id	FK_MR_GEN_IMAGE_PK_ID
	general_series	mr_image.GENERAL_SERIES_PK_ID = general_series.general_series_pk_id	FK_MR_GEN_SERIES_PK_ID

Unique keys

	Columns	Name / Description
Image Modified	MR_IMAGE_PK_ID	PRIMARY

Table: patient

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	patient_pk_id	bigint(19, 0)
	patient_id	varchar(64)	Nullable
	patient_name	varchar(250)	Nullable
	patient_birth_date	date	Nullable
	patient_sex	varchar(16)	Nullable
	ethnic_group	varchar(16)	Nullable
	trial_dp_pk_id	bigint(19, 0)	Nullable References: trial_data_provenance
	trial_subject_id	varchar(64)	Nullable
	trial_subject_reading_id	varchar(255)	Nullable
	trial_site_pk_id	bigint(19, 0)	Nullable
	species_code	varchar(100)	Nullable
	species_description	varchar(100)	Nullable
	qc_subject	varchar(4)	Nullable

Links to

	Table	Join	Title / Name / Description
	trial_data_provenance	patient.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id	fk_trial_dp_pk_id

Linked from

	Table	Join	Title / Name / Description
	general_image	patient.patient_pk_id = general_image.patient_pk_id	FK_general_image_patient
	study	patient.patient_pk_id = study.patient_pk_id	fk_patient_pk_id

Unique keys

	Columns	Name / Description
Image Modified	patient_pk_id	PRIMARY
	patient_pk_id	PK_PATINET_PK_ID

Table: qc_status_history

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	qc_status_history_pk_id	bigint(19, 0)
	series_instance_uid	varchar(64)
	user_id	varchar(100)	Nullable
	comment_	varchar(4000)	Nullable
	history_timestamp	datetime	Nullable
	new_value	varchar(100)	Nullable
	old_value	varchar(100)	Nullable
	oldBatch	varchar(20)	Nullable
	newBatch	varchar(20)	Nullable
	oldSubmissionType	varchar(100)	Nullable
	newSubmissionType	varchar(100)	Nullable
	oldReleasedStatus	varchar(50)	Nullable
	newReleasedStatus	varchar(50)	Nullable

Unique keys

	Columns	Name / Description
Image Modified	qc_status_history_pk_id	PRIMARY
	qc_status_history_pk_id	PK_QC_STATUS_HISTORY_PK_ID

Table: query_history

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	query_history_pk_id	bigint(19, 0)
	user_id	bigint(19, 0)	Nullable References: csm_user
	query_execute_timestamp	datetime	Nullable
	query_elapsed_time	bigint(19, 0)	Nullable
	saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
	tool	varchar(100)	Nullable

Links to

	Table	Join	Title / Name / Description
	csm_user	query_history.user_id = csm_user.USER_ID	FK_Q_H_USER_ID
	saved_query	query_history.saved_query_pk_id = saved_query.saved_query_pk_id	fk_s_query_pk_id

Linked from

	Table	Join	Title / Name / Description
	query_history_attribute	query_history.query_history_pk_id = query_history_attribute.query_history_ pk_id	FK_Q_H_PK_ID

Unique keys

	Columns	Name / Description
Image Modified	query_history_pk_id	PRIMARY
	query_history_pk_id	PK_QUERY_HISTORY_PK_ID

...

Table: query_history_attribute

...

CKK

Columns

Name	Data type	Description / Attributes
query_history_attribute_pk_id	bigint(19, 0)
attribute_name	varchar(300)	Nullable
subattribute_name	varchar(300)	Nullable
attribute_value	varchar(300)	Nullable
query_history_pk_id	bigint(19, 0)	Nullable References: query_history
instance_number	bigint(19, 0)	Nullable

...

Content

Space Tools

Versions Compared

Old Version 14

New Version 15

Key

Table: download_data_history

Table: general_image

Table: general_series

Table: gui_action_history

Table: hibernate_unique_key

Table: login_history

Table: mr_image

Table: patient

Table: qc_status_history

Table: query_history

Table: query_history_attribute