Page History

Versions Compared

Key

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

Panel

Table of Contents

Legend

Icon	Description
	Primary key
	Primary key disabled
	User-defined primary key
	Unique key
	Unique key disabled
	User-defined unique key
	Active trigger
	Disabled trigger Many to one relation
	User-defined many to one relation One to many relation
	User-defined one to many relation One to one relation
Image Modified	User-defined one to one relation
	Input
	Output
Image Modified	Input/Output
	Uses dependency
	User-defined uses dependency
	Used by dependency
	User-defined used by dependency

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_application.APPLICATION_ID = csm_group.APPLICATION_ID	FK_APPLICATION_GROUP
Image Modified	csm_mapping	csm_application.APPLICATION_ID = csm_mapping.APPLICATION_ID	FK_PE_APPLICATION
Image Modified	csm_protection_group	csm_application.APPLICATION_ID = csm_protection_group.APPLICATION_I D	FK_PG_APPLICATION
Image Modified	csm_role	csm_application.APPLICATION_ID = csm_role.APPLICATION_ID	FK_APPLICATION_ROLE

...

Key	Columns	Name / Description
Image Modified	PROPERTY_KEY	PRIMARY

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_group.APPLICATION_ID = csm_application.APPLICATION_ID	FK_APPLICATION_GROUP

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user_group	csm_group.GROUP_ID = csm_user_group.GROUP_ID	FK_UG_GROUP
Image Modified	csm_user_group_role_pg	csm_group.GROUP_ID = csm_user_group_role_pg.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID	FK_PE_APPLICATION

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_protection_element	csm_pg_pe.PROTECTION_ELEMENT_I D = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_PROTECTION_GROUP
Image Modified	csm_protection_group	csm_pg_pe.PROTECTION_GROUP_ID = csm_protection_group.PROTECTION_ GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_role_privilege	csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID	FK_PRIVILEGE_ROLE

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_pg_pe	csm_protection_element.PROTECTION _ELEMENT_ID = csm_pg_pe.PROTECTION_ELEMENT_I D	FK_PROTECTION_ELEMENT_PROTECTION_GROUP
_	Table	Join	Title / Name / Description
Image Modified	csm_user_pe	csm_protection_element.PROTECTION _ELEMENT_ID = csm_user_pe.PROTECTION_ELEMENT_ ID	FK_PROTECTION_ELEMENT_USER

...

Key	Columns	Name / Description
Image Modified	PROTECTION_ELEMENT_ID	PRIMARY
	OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID	UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID	FK_PG_APPLICATION
Image Modified	csm_protection_group	csm_protection_group.PARENT_PROT ECTION_GROUP_ID = csm_protection_group.PROTECTION_ GROUP_ID	FK_PROTECTION_GROUP

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_protection_group	csm_protection_group.PROTECTION_ GROUP_ID = csm_protection_group.PARENT_PROT ECTION_GROUP_ID	FK_PROTECTION_GROUP
Image Modified	csm_pg_pe	csm_protection_group.PROTECTION_ GROUP_ID = csm_pg_pe.PROTECTION_GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT
Image Modified	csm_user_group_role_pg	csm_protection_group.PROTECTION_ GROUP_ID = csm_user_group_role_pg.PROTECTIO N_GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_application	csm_role.APPLICATION_ID = csm_application.APPLICATION_ID	FK_APPLICATION_ROLE

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_role_privilege	csm_role.ROLE_ID = csm_role_privilege.ROLE_ID	FK_ROLE
Image Modified	csm_user_group_role_pg	csm_role.ROLE_ID = csm_user_group_role_pg.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE

...

Key	Columns	Name / Description
Image Modified	ROLE_ID	PRIMARY
	APPLICATION_ID, ROLE_NAME	UQ_ROLE_ROLE_NAME

...

Key	Name	Data type	Description / Attributes
Image RemovedImage Added	ROLE_PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
	ROLE_ID	bigint(19, 0)	References: csm_role
	PRIVILEGE_ID	bigint(19, 0)	References: csm_privilege
_	UPDATE_DATE	date	Default: 1950-01-01

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_privilege	csm_role_privilege.PRIVILEGE_ID = csm_privilege.PRIVILEGE_ID	FK_PRIVILEGE_ROLE
Image Modified	csm_role	csm_role_privilege.ROLE_ID = csm_role.ROLE_ID	FK_ROLE

...

Key	Name	Data type	Description / Attributes
	USER_ID	bigint(19, 0)	Identity / Auto increment
_	LOGIN_NAME	varchar(500)	Nullable
__	FIRST_NAME	varchar(100)
_	LAST_NAME	varchar(100)
__	ORGANIZATION	varchar(500)	Nullable
__	DEPARTMENT	varchar(100)	Nullable
_	TITLE	varchar(100)	Nullable
_	PHONE_NUMBER	varchar(100)	Nullable
_	PASSWORD	varchar(100)	Nullable
_	EMAIL_ID	varchar(100)	Nullable
_	START_DATE	date	Nullable
_	END_DATE	date	Nullable
_	UPDATE_DATE	date	Default: 1950-01-01
_	MIDDLE_NAME	varchar(100)	Nullable
_	FAX	varchar(20)	Nullable
_	ADDRESS	varchar(200)	Nullable
_	CITY	varchar(100)	Nullable
_	STATE	varchar(100)	Nullable
_	COUNTRY	varchar(100)	Nullable
_	POSTAL_CODE	varchar(10)	Nullable
_	MIGRATED_FLAG	tinyint(3, 0)	Default: 0
_	PREMGRT_LOGIN_NAME	varchar(100)	Nullable
_	PASSWORD_EXPIRED	tinyint(3, 0)	Nullable Default: 0
_	FIRST_TIME_LOGIN	tinyint(3, 0)	Nullable Default: 0
_	ACTIVE_FLAG	tinyint(3, 0)	Nullable Default: 1
_	PASSWORD_EXPIRY_DATE	date	Nullable Default: 2012-10-10

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_user_group	csm_user.USER_ID = csm_user_group.USER_ID	FK_USER_GROUP
Image Modified	csm_user_group_role_pg	csm_user.USER_ID = csm_user_group_role_pg.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER
Image Modified	csm_user_pe	csm_user.USER_ID = csm_user_pe.USER_ID	FK_PE_USER
Image Modified	query_history	csm_user.USER_ID = query_history.user_id	FK_Q_H_USER_ID
Image Modified	saved_query	csm_user.USER_ID = saved_query.user_id	FK_SAVED_QUERY_USER_ID

...

Key	Name	Data type	Description / Attributes
	USER_GROUP_ID	bigint(19, 0)	Identity / Auto increment
_	USER_ID	bigint(19, 0)	References: csm_user
_	GROUP_ID	bigint(19, 0)	References: csm_group

Links to

IconRelationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_user_group.GROUP_ID = csm_group.GROUP_ID	FK_UG_GROUP
Image Modified	csm_user	csm_user_group.USER_ID = csm_user.USER_ID	FK_USER_GROUP

Unique keys

IconKey	Columns	Name / Description
	USER_GROUP_ID	PRIMARY

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_group	csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
Image Modified	csm_protection_group	csm_user_group_role_pg.PROTECTIO N_GROUP_ID = csm_protection_group.PROTECTION_ GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_PROTECTION_GROUP
Image Modified	csm_role	csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE
Image Modified	csm_user	csm_user_group_role_pg.USER_ID = csm_user.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

...

Relationship	Table	Join	Title / Name / Description
Image Modified	csm_protection_element	csm_user_pe.PROTECTION_ELEMENT_ ID = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_USER
Image Modified	csm_user	csm_user_pe.USER_ID = csm_user.USER_ID	FK_PE_USER

...

Relationship	Table	Join	Title / Name / Description
Image Modified	general_image	ct_image.image_pk_id = general_image.image_pk_id	fk_image_pk_id
Image Modified	general_series	ct_image.general_series_pk_id = general_series.general_series_pk_id	ct_image_ibfk_1

...

Key	Columns	Name / Description
Image Modified	ct_image_pk_id	PRIMARY
	ct_image_pk_id	PK_CT_IMAGE_PK_ID

...

Relationship	Table	Join	Title / Name / Description
Image Modified	custom_series_list_attribute	custom_series_list.CUSTOM_SERIES_LI ST_PK_ID = custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID	FK_CUSTOM_SERIES_LIST_PK_ID

...

Relationship	Table	Join	Title / Name / Description
Image Modified	custom_series_list	custom_series_list_attribute.CUSTOM_ SERIES_LIST_PK_ID = custom_series_list.CUSTOM_SERIES_LI ST_PK_ID	FK_CUSTOM_SERIES_LIST_PK_ID

...

Key	Name	Data type	Description / Attributes
Image RemovedImage Added	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

...

Relationship	Table	Join	Title / Name / Description
Image Modified	general_series	general_equipment.general_equipmen t_pk_id = general_series.general_equipment_pk_ id	fk_g_equipment_pk_id

Unique keys

IconKey	Columns	Name / Description
	general_equipment_pk_id	PRIMARY
	general_equipment_pk_id	PK_G_EQUIPMENT_ID

...

Relationship	Table	Join	Title / Name / Description
Image Modified	general_series	general_image.general_series_pk_id = general_series.general_series_pk_id	fk_g_series_pk_id
Image Modified	patient	general_image.patient_pk_id = patient.patient_pk_id	FK_general_image_patient
Image Modified	study	general_image.study_pk_id = study.study_pk_id	FK_general_image_study

...

Relationship	Table	Join	Title / Name / Description
Image Modified	ct_image	general_image.image_pk_id = ct_image.image_pk_id	fk_image_pk_id
Image Modified	mr_image	general_image.image_pk_id = mr_image.IMAGE_PK_ID	FK_MR_GEN_IMAGE_PK_ID

...

Relationship	Table	Join	Title / Name / Description
Image Modified	general_equipment	general_series.general_equipment_pk_ id = general_equipment.general_equipmen t_pk_id	fk_g_equipment_pk_id
Image Modified	study	general_series.study_pk_id = study.study_pk_id	fk_gs_study_pk_id

...

Relationship	Table	Join	Title / Name / Description
Image Modified	ct_image	general_series.general_series_pk_id = ct_image.general_series_pk_id	ct_image_ibfk_1
Image Modified	general_image	general_series.general_series_pk_id = general_image.general_series_pk_id	fk_g_series_pk_id
Image Modified	mr_image	general_series.general_series_pk_id = mr_image.GENERAL_SERIES_PK_ID	FK_MR_GEN_SERIES_PK_ID

...

Key	Columns	Name / Description
Image Modified	modality_descriptions_pk_id	PRIMARY
	modality_descriptions_pk_id	MD_COLLECTION_DESC_PK_ID

...

Key	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
-	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
Image RemovedImage Added	MR_IMAGE_PK_ID	bigint(19, 0)	Identity / Auto increment
-	GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable References: general_series

...

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

Unique keys

IconKey	Columns	Name / Description
	MR_IMAGE_PK_ID	PRIMARY

Table: patient

Columns

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

Links to

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

Linked from

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

Unique keys

IconKey	Columns	Name / Description
	patient_pk_id	PRIMARY
	patient_pk_id	PK_PATINET_PK_ID

Table: qc_status_history

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	qc_status_history_pk_id	bigint(19, 0)	-
- Image Removed	series_instance_uid	varchar(64)	-
- Image Removed	user_id	varchar(100)	Nullable
Image Removed -	comment_	varchar(4000)	Nullable
Image Removed -	history_timestamp	datetime	Nullable
Image Removed -	new_value	varchar(100)	Nullable
Image Removed -	old_value	varchar(100)	Nullable
Image Removed -	oldBatch	varchar(20)	Nullable
Image Removed -	newBatch	varchar(20)	Nullable
Image Removed -	oldSubmissionType	varchar(100)	Nullable
Image Removed -	newSubmissionType	varchar(100)	Nullable
Image Removed -	oldReleasedStatus	varchar(50)	Nullable
Image Removed -	newReleasedStatus	varchar(50)	Nullable

Unique keys

IconKey	Columns	Name / Description
	qc_status_history_pk_id	PRIMARY
	qc_status_history_pk_id	PK_QC_STATUS_HISTORY_PK_ID

Table: query_history

Columns

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

Links to

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

Linked from

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

Unique keys

IconKey	Columns	Name / Description
	query_history_pk_id	PRIMARY
	query_history_pk_id	PK_QUERY_HISTORY_PK_ID

Table: query_history_attribute

Columns

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

Links to

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

Unique keys

IconKey	Columns	Name / Description
	query_history_attribute_pk_id	PRIMARY
	query_history_attribute_pk_id	PK_Q_H_A_PK_ID

Table: saved_query

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	saved_query_pk_id	bigint(19, 0)	-
Image Removed -	user_id	bigint(19, 0)	Nullable References: csm_user
Image Removed -	query_name	varchar(200)	Nullable
Image Removed -	new_data_flag	varchar(5)	Nullable
Image Removed -	active	varchar(5)	Nullable
Image Removed -	query_execute_timestamp	datetime	Nullable

Links to

IconRelationship	Table	Join	Title / Name / Description
Image Modified	csm_user	saved_query.user_id = csm_user.USER_ID	FK_SAVED_QUERY_USER_ID

Linked from

IconRelationship	Table	Join	Title / Name / Description
Image Modified	query_history	saved_query.saved_query_pk_id = query_history.saved_query_pk_id	fk_s_query_pk_id
Image Modified	saved_query_attribute	saved_query.saved_query_pk_id = saved_query_attribute.saved_query_pk _id	FK_SAVED_QUERY_PK_ID

Unique keys

IconKey	Columns	Name / Description
	saved_query_pk_id	PRIMARY
	saved_query_pk_id	PK_SAVED_Q_PK_ID

Table: saved_query_attribute

Columns

Icon1	Icon2Key	Name	Data type	Description / Attributes
Image RemovedImage Added	Image Removed	saved_query_attribute_pk_id	bigint(19, 0)	-
Image Removed -	attribute_name	varchar(300)	Nullable
Image Removed -	subattribute_name	varchar(300)	Nullable
Image Removed -	attribute_value	varchar(300)	Nullable
Image Removed -	saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
-	Name	Data type	Description / Attributes
Image Removed -	instance_number	bigint(19, 0)	Nullable

Links to

IconRelationship	Table	Join	Title / Name / Description
Image Modified	saved_query	saved_query_attribute.saved_query_pk _id = saved_query.saved_query_pk_id	FK_SAVED_QUERY_PK_ID

Unique keys

IconKey	Columns	Name / Description
	saved_query_attribute_pk_id	PRIMARY
	saved_query_attribute_pk_id	PK_S_Q_A_PK_ID

Table: site

Columns

Image Removed

Icon1Key	Icon2	Name	Data type
	site_pk_id	bigint(19, 0)	-
Image Removed -	dp_site_name	varchar(40)	Nullable
Image Removed -	dp_site_id	varchar(64)	Nullable
Image Removed -	trial_dp_pk_id	bigint(19, 0)	References: trial_data_provenance

Links to

IconRelationship	Table	Join	Title / Name / Description
Image Modified	trial_data_provenance	site.trial_dp_pk_id = trial_data_provenance.trial_dp_pk_id	fk_tdp_st_pk_id

Unique keys

IconKey	Columns	Name / Description
	site_pk_id	PRIMARY
	site_pk_id	SITE_PK_ID

Table: species

Columns

Image Removed

Icon1Key

Icon2

Name

Data type

Description / Attributes

species_code

varchar(64)

Image Removed

species_description

varchar(500)

Nullable

Unique keys

IconKey	Columns	Name / Description
	species_code	PRIMARY

Table: study

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	study_pk_id	bigint(19, 0) Image Removed
	study_instance_uid	varchar(500)	Nullable
Image Removed -	study_date	date	-
- Image Removed	study_time	varchar(16)	Nullable
Image Removed -	study_desc	varchar(64)	Nullable
Image Removed -	admitting_diagnoses_desc	varchar(64)	Nullable
Image Removed -	admitting_diagnoses_code_seq	varchar(500)	Nullable
Image Removed -	patient_pk_id	bigint(19, 0)	Nullable References: patient
Image Removed -	study_id	varchar(16)	Nullable
Image Removed -	trial_time_point_id	varchar(64)	Nullable
Image Removed -	trial_time_point_desc	varchar(1024)	Nullable
Image Removed -	patient_age	varchar(4)	Nullable
Image Removed -	age_group	varchar(10)	Nullable
Image Removed -	patient_size	decimal(22, 6)	Nullable
Image Removed -	patient_weight	decimal(22, 6)	Nullable
Image Removed -	occupation	varchar(16)	Nullable
Image Removed -	additional_patient_history	varchar(4000)	Nullable

Links to

IconRelationship	Table	Join	Title / Name / Description
Image Modified	patient	study.patient_pk_id = patient.patient_pk_id	fk_patient_pk_id

Linked from

IconRelationship	Table	Join	Title / Name / Description
Image Modified	general_image	study.study_pk_id = general_image.study_pk_id	FK_general_image_study
Image Modified	general_series	study.study_pk_id = general_series.study_pk_id	fk_gs_study_pk_id

Unique keys

IconKey	Columns	Name / Description
	study_pk_id	PRIMARY
	study_pk_id	PK_STUDY_PK_ID
	study_instance_uid	study_instance_uid

Table: submission_history

Columns

Image Removed

Icon1Key	Icon2	Name	Data type
	submission_history_pk_id	bigint(19, 0)	Identity / Auto increment
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 -	sop_instance_uid	varchar(64)	Nullable
Image Removed -	submission_timestamp	datetime	Nullable
Image Removed -	project	varchar(200)	Nullable
Image Removed -	site	varchar(40)	Nullable
Image Removed -	operation_type	smallint(5, 0)	-

Unique keys

IconKey	Columns	Name / Description
	submission_history_pk_id	submission_history_pk_id

Table: trial_data_provenance

Columns

Icon1	Icon2Key	Name	Data type	Description / Attributes
Image Removed		trial_dp_pk_id	bigint(19, 0)	-
Image Removed -	dp_site_name	varchar(40)	Nullable
Image Removed -	dp_site_id	varchar(64)	Nullable
Image Removed -	project	varchar(50)	Nullable

Linked from

IconRelationship	Table	Join	Title / Name / Description
Image Modified	patient	trial_data_provenance.trial_dp_pk_id = patient.trial_dp_pk_id	fk_trial_dp_pk_id
Image Modified	site	trial_data_provenance.trial_dp_pk_id = site.trial_dp_pk_id	fk_tdp_st_pk_id

Unique keys

IconKey	Columns	Name / Description
	trial_dp_pk_id	PRIMARY
	trial_dp_pk_id	PK_TRIAL_DP_PK_ID

Table: trial_site

Columns

Icon1	Icon2Key	Name	Data type	Description / Attributes
Image Removed		trial_site_pk_id	bigint(19, 0)	-
Image Removed -	trial_site_id	varchar(64)	Nullable	Name
-	Data type	Description / Attributes	Image Removed trial_site_name	varchar(64)	Nullable
Image Removed -	trial_pk_id	bigint(19, 0)	Nullable

Unique keys

IconKey	Columns	Name / Description
	trial_site_pk_id	PRIMARY
	trial_site_pk_id	PK_TRIAL_SITE_PK_ID

Table: workflow

Columns

Image Removed

Icon1Key	Icon2	Name	Data type
	WORKFLOW_ID	bigint(19, 0)	-
Image Removed -	NAME	varchar(50)	Nullable
Image Removed -	COLLECTION	varchar(200)	Nullable
Image Removed -	SITE	varchar(200)	Nullable
Image Removed -	URL	varchar(255)	Nullable
Image Removed -	WORKFLOW_TYPE	varchar(50)	Nullable

Unique keys

IconKey	Columns	Name / Description
	WORKFLOW_ID	PRIMARY

...

View: dicom_image

VIEW
Columns

Icon1	Icon2	Name
Image Removed	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 Image Removed
SOP_INSTANCE_UID	varchar(64)	Nullable Image Removed
GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable 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 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 Image Removed
STUDY_PK_ID	bigint(19, 0)	Nullable 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 KVP	decimal(22, 6)	Nullable Image Removed
SCAN_OPTIONS	varchar(16)	Nullable Image Removed
DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Image Removed
RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable Image Removed
GANTRY_DETECTOR_TILT	decimal(22, 6)	Nullable
Name	Data type	Description / Attributes Image Removed
EXPOSURE_TIME	decimal(22, 6)	Nullable Image Removed
X_RAY_TUBE_CURRENT	decimal(22, 6)	Nullable Image Removed
EXPOSURE	decimal(22, 6)	Nullable Image Removed
EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable Image Removed
CONVOLUTION_KERNEL	varchar(16)	Nullable Image Removed
REVOLUTION_TIME	decimal(22, 6)	Nullable Image Removed
SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable Image Removed
TOTAL_COLLIMATION_WIDTH	decimal(22, 6)	Nullable Image Removed
TABLE_SPEED	decimal(22, 6)	Nullable Image Removed
TABLE_FEED_PER_ROTATION	decimal(22, 6)	Nullable Image Removed
CT_PITCH_FACTOR	decimal(22, 6)	Nullable Image Removed
ANATOMIC_REGION_SEQ	varchar(500)	Nullable

View: dicom_series

VIEW
Columns

Icon1	Icon2	Name	Data type
Image Removed	GENERAL_SERIES_PK_ID	bigint(19, 0)	Image Removed -
BODY_PART_EXAMINED	varchar(16)	Nullable Image Removed
FRAME_OF_REFERENCE_UID	varchar(64)	Nullable Image Removed
SERIES_LATERALITY	varchar(16)	Nullable Image Removed
MODALITY	varchar(16)	Image Removed -
PROTOCOL_NAME	varchar(64)	Nullable Image Removed
SERIES_DATE	date	Nullable Image Removed
SERIES_DESC	varchar(64)	Nullable Image Removed
SERIES_INSTANCE_UID	varchar(64)	Nullable Image Removed
SERIES_NUMBER	decimal(22, 6)	Nullable Image Removed
SYNC_FRAME_OF_REF_UID	varchar(64)	Nullable Image Removed
STUDY_PK_ID	bigint(19, 0)	Nullable Image Removed
GENERAL_EQUIPMENT_PK_ID	bigint(19, 0)	Nullable

View: dicom_study

VIEW
Columns

...

Icon1

...

Image Removed

Name	Data type	Description / Attributes
STUDY_PK_ID	bigint(19, 0)	Image Removed -
STUDY_INSTANCE_UID	varchar(500)	Nullable Image Removed
ADDITIONAL_PATIENT_HISTORY	varchar(4000)	Nullable Image Removed
STUDY_DATE	date	Image Removed -
STUDY_DESC	varchar(64)	Nullable Image Removed
ADMITTING_DIAGNOSES_DESC	varchar(64)	Nullable Image Removed
ADMITTING_DIAGNOSES_CODE_S EQ	varchar(500)	Nullable Image Removed
OCCUPATION	varchar(16)	Nullable Image Removed
PATIENT_AGE	varchar(4)	Nullable Image Removed
PATIENT_SIZE	decimal(22, 6)	Nullable Image Removed
PATIENT_WEIGHT	decimal(22, 6)	Nullable Image Removed
STUDY_ID	varchar(16)	Nullable Image Removed
STUDY_TIME	varchar(16)	Nullable Image Removed
TRIAL_TIME_POINT_ID	varchar(64)	Nullable Image Removed
TRIAL_TIME_POINT_DESC	varchar(1024)	Nullable Image Removed
PATIENT_PK_ID	bigint(19, 0)	Nullable

View: manufacturer

VIEW
Columns

...

Icon2	Name	Data type	Description / Attributes
Image Removed	MANUFACTURER	varchar(64)	Nullable

View: manufacturer_model_software

VIEW
Columns

Image Removed

Icon1	Icon2	Name
ID	bigint(19, 0)	Image Removed -
MANUFACTURER	varchar(64)	Nullable Image Removed
MODEL	varchar(64)	Nullable Image Removed
SOFTWARE	varchar(64)	Nullable

View: number_month

VIEW
Columns

...

Icon2	Name	Data type	Description / Attributes
Image Removed	PATIENT_ID	bigint(19, 0)	Nullable
Image Removed	NUMBER_MONTH	bigint(19, 0)	Nullable

View: saved_query_last_exec

VIEW
Columns

...

Image Removed

Icon2

Name

Data type

Description / Attributes

SAVED_QUERY_PK_ID

bigint(19, 0)

Nullable

Image Removed

LAST_EXECUTE_DATE

datetime

Nullable

View: software_versions

VIEW
Columns

...

Icon1

...

Name	Data type	Description / Attributes
Image Removed	SOFTWARE_VERSIONS	varchar(64)	Nullable

View: study_series_number

VIEW
Columns

Image Removed

Icon1	Icon2	Name
PATIENT_PK_ID	bigint(19, 0)	Nullable Image Removed
PATIENT_ID	varchar(64)	Nullable Image Removed
PROJECT	varchar(50)	Nullable Image Removed
STUDY_NUMBER	bigint(19, 0)	Default: 0 Image Removed
SERIES_NUMBER	bigint(19, 0)	Default: 0

Content

Space Tools

Versions Compared

Old Version 25

New Version Current

Key

Legend

Table: patient

Table: qc_status_history

Table: query_history

Table: query_history_attribute

Table: saved_query

Table: saved_query_attribute

Table: site

Table: species

Table: study

Table: submission_history

Table: trial_data_provenance

Table: trial_site

Table: workflow

View: dicom_image

View: dicom_series

View: dicom_study

View: manufacturer

View: manufacturer_model_software

View: number_month

View: saved_query_last_exec

View: software_versions

View: study_series_number