Page History

Versions Compared

Key

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

...

Table: query_history_attribute

CKK
Columns

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

Links to

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

Unique keys

	Columns	Name / Description
Image Modified	query_history_attribute_pk_id	PRIMARY
	query_history_attribute_pk_id	PK_Q_H_A_PK_ID

Table: saved_query

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	saved_query_pk_id	bigint(19, 0)
	user_id	bigint(19, 0)	Nullable References: csm_user
	query_name	varchar(200)	Nullable
	new_data_flag	varchar(5)	Nullable
	active	varchar(5)	Nullable
	query_execute_timestamp	datetime	Nullable

Links to

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

Linked from

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

Unique keys

	Columns	Name / Description
Image Modified	saved_query_pk_id	PRIMARY
	saved_query_pk_id	PK_SAVED_Q_PK_ID

Table: saved_query_attribute

Columns

Name	Data type	Description / Attributes
saved_query_attribute_pk_id	bigint(19, 0)
attribute_name	varchar(300)	Nullable
subattribute_name	varchar(300)	Nullable
attribute_value	varchar(300)	Nullable
saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
Name	Data type	Description / Attributes
instance_number	bigint(19, 0)	Nullable

Links to

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

Unique keys

	Columns	Name / Description
Image Modified	saved_query_attribute_pk_id	PRIMARY
	saved_query_attribute_pk_id	PK_S_Q_A_PK_ID

...

Table: site

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	site_pk_id	bigint(19, 0)
	dp_site_name	varchar(40)	Nullable
	dp_site_id	varchar(64)	Nullable
	trial_dp_pk_id	bigint(19, 0)	References: trial_data_provenance

Links to

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

Unique keys

	Columns	Name / Description
Image Modified	site_pk_id	PRIMARY
	site_pk_id	SITE_PK_ID

...

Table: species

...

Columns

		Name	Data type	Description / Attributes
	Image RemovedImage Added	species_code	varchar(64)
		species_description	varchar(500)	Nullable

Unique keys

	Columns	Name / Description
Image Modified	species_code	PRIMARY

...

Table: study

Columns

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

Links to

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

Linked from

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

Unique keys

	Columns	Name / Description
Image Modified	study_pk_id	PRIMARY
	study_pk_id	PK_STUDY_PK_ID
	study_instance_uid	study_instance_uid

...

Table: submission_history

...

Columns

Name	Data type	Description / Attributes
submission_history_pk_id	bigint(19, 0)	Identity / Auto increment
patient_id	varchar(64)	Nullable
study_instance_uid	varchar(500)	Nullable
series_instance_uid	varchar(64)	Nullable
sop_instance_uid	varchar(64)	Nullable
submission_timestamp	datetime	Nullable
project	varchar(200)	Nullable
site	varchar(40)	Nullable
operation_type	smallint(5, 0)

Unique keys

	Columns	Name / Description
	submission_history_pk_id	submission_history_pk_id

...

Table: trial_data_provenance

...

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	trial_dp_pk_id	bigint(19, 0)
	dp_site_name	varchar(40)	Nullable
	dp_site_id	varchar(64)	Nullable
	project	varchar(50)	Nullable

Linked from

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

Unique keys

CKK

	Columns	Name / Description
	trial_dp_pk_id	PRIMARY
	trial_dp_pk_id	PK_TRIAL_DP_PK_ID

...

Content

Space Tools

Versions Compared

Old Version 15

New Version 16

Key

Table: query_history_attribute

Table: saved_query

Table: saved_query_attribute

Table: site

Table: species

Table: study

Table: submission_history

Table: trial_data_provenance