Error rendering macro 'rw-search'

null

Page History

Versions Compared

Key

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

...

	Columns	Name / Description
	ROLE_PRIVILEGE_ID	PRIMARY
	PRIVILEGE_ID, ROLE_ID	UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user

Columns

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
Name	Data type	Description / Attributes
ACTIVE_FLAG	tinyint(3, 0)	Nullable Default: 1
PASSWORD_EXPIRY_DATE	date	Nullable Default: 2012-10-10

...

	Columns	Name / Description
	USER_ID	PRIMARY

Anchor
1.15. Table: csm_user_group
1.15. Table: csm_user_group
Anchor
_bookmark16
_bookmark16
Anchor
_bookmark16
_bookmark16
Table: csm_user_group

Columns

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

...

	Columns	Name / Description
	USER_GROUP_ROLE_PG_ID	PRIMARY

Anchor
1.17. Table: csm_user_pe
1.17. Table: csm_user_pe
Anchor
_bookmark18
_bookmark18
Anchor
_bookmark18
_bookmark18
Table: csm_user_pe

Columns

Name	Data type	Description / Attributes
USER_PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
USER_ID	bigint(19, 0)	References: csm_user
UPDATE_DATE	date	Default: 1950-01-01

...

	Columns	Name / Description
	USER_PROTECTION_ELEMENT_ID	PRIMARY
	Columns	Name / Description
	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

Name	Data type	Description / Attributes
kvp	decimal(22, 6)	Nullable
scan_options	varchar(16)	Nullable
data_collection_diameter	decimal(22, 6)	Nullable
reconstruction_diameter	decimal(22, 6)	Nullable
gantry_detector_tilt	decimal(22, 6)	Nullable
exposure_time	decimal(22, 6)	Nullable
x_ray_tube_current	decimal(22, 6)	Nullable
exposure	decimal(22, 6)	Nullable
exposure_in_microas	decimal(22, 6)	Nullable
convolution_kernel	varchar(16)	Nullable
revolution_time	decimal(22, 6)	Nullable
single_collimation_width	decimal(22, 6)	Nullable
total_collimation_width	decimal(22, 6)	Nullable
table_speed	decimal(22, 6)	Nullable
table_feed_per_rotation	decimal(22, 6)	Nullable
ct_pitch_factor	decimal(22, 6)	Nullable
anatomic_region_seq	varchar(500)	Nullable
image_pk_id	bigint(19, 0)	References: general_image
ct_image_pk_id	bigint(19, 0)
general_series_pk_id	bigint(19, 0)	Nullable References: general_series

...

	Columns	Name / Description
	ct_image_pk_id	PRIMARY
	ct_image_pk_id	PK_CT_IMAGE_PK_ID

Anchor
1.19. Table: custom_series_list
1.19. Table: custom_series_list
Anchor
_bookmark20
_bookmark20
Anchor
_bookmark20
_bookmark20
Table: custom_series_list

Columns

Name	Data type	Description / Attributes
CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)
NAME	varchar(200)	Nullable
comment_	varchar(200)	Nullable
HYPERLINK	varchar(200)	Nullable
CUSTOM_SERIES_LIST_TIMESTAMP	date	Nullable
USER_NAME	varchar(20)	Nullable
usage_count	unsigned int(10, 0)	Nullable Default: 0

...

	Columns	Name / Description
	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
	CUSTOM_SERIES_LIST_PK_ID	CUSTOM_SERIES_LIST_PK_ID

Table: custom_series_list_attribute

Columns

Name	Data type	Description / Attributes
custom_series_list_attribute_p	bigint(19, 0)
SERIES_INSTANCE_UID	varchar(200)	Nullable
CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)	References: custom_series_list

...

	Columns	Name / Description
	custom_series_list_attribute_p	PRIMARY
	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Name	Data type	Description / Attributes
ID	varchar(63)
AUTHOR	varchar(63)
FILENAME	varchar(200)
DATEEXECUTED	datetime
MD5SUM	varchar(32)	Nullable
DESCRIPTION	varchar(255)	Nullable
COMMENTS	varchar(255)	Nullable
TAG	varchar(255)	Nullable
LIQUIBASE	varchar(10)	Nullable

...

	Columns	Name / Description
	ID, AUTHOR, FILENAME	PRIMARY

Table: databasechangeloglock

Columns

Name	Data type	Description / Attributes
ID	int(10, 0)
LOCKED	tinyint(3, 0)
LOCKGRANTED	datetime	Nullable
LOCKEDBY	varchar(255)	Nullable

...

	Columns	Name / Description
	ID	PRIMARY

Table: deletion_audit_trail

Columns

Name	Data type	Description / Attributes
deletion_pk_id	bigint(19, 0)
data_id	varchar(64)	Nullable
data_type	varchar(50)	Nullable
total_image	bigint(19, 0)	Nullable
user_name	varchar(50)	Nullable
time_stamp	datetime	Nullable

...

	Columns	Name / Description
	deletion_pk_id	PRIMARY

Table: download_data_history

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
	download_data_history_pk_id	PRIMARY

Table: download_history

Columns

Name	Data type	Description / Attributes
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
	download_history_pk_id	PRIMARY

Table: general_equipment

Columns

Name	Data type	Description / Attributes
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
	general_equipment_pk_id	PRIMARY
	general_equipment_pk_id	PK_G_EQUIPMENT_ID

Table: general_image

Columns

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

...

	Columns	Name / Description
	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
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

...

	Columns	Name / Description
	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
GUI_ACTION_HISTORY_PK_ID	bigint(19, 0)	Default: 0
ACTION_TIMESTAMP	date	Nullable
ACTION	varchar(255)	Nullable

...

	Columns	Name / Description
	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
login_history_pk_id	bigint(19, 0)
login_timestamp	datetime	Nullable
ip_address	varchar(15)	Nullable

...

	Columns	Name / Description
	login_history_pk_id	PRIMARY
	login_history_pk_id	PK_LOGIN_HISTORY_PK_ID

Table: modality_descriptions

Columns

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

Unique keys

	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

...

	Columns	Name / Description
	MR_IMAGE_PK_ID	PRIMARY

Table: patient

Columns

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

...

	Columns	Name / Description
	patient_pk_id	PRIMARY
	patient_pk_id	PK_PATINET_PK_ID

Table: qc_status_history

Columns

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

...

	Columns	Name / Description
	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
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

...

	Columns	Name / Description
	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

...

	Columns	Name / Description
	site_pk_id	PRIMARY
	site_pk_id	SITE_PK_ID

Anchor
1.41. Table: species
1.41. Table: species
Anchor
_bookmark42
_bookmark42
Anchor
_bookmark42
_bookmark42
Table: species

Columns

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

...

	Columns	Name / Description
	study_pk_id	PRIMARY
	study_pk_id	PK_STUDY_PK_ID
	study_instance_uid	study_instance_uid

Anchor
1.43. Table: submission_history
1.43. Table: submission_history
Anchor
_bookmark44
_bookmark44
Anchor
_bookmark44
_bookmark44
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)

...

	Columns	Name / Description
	submission_history_pk_id	submission_history_pk_id

Anchor
1.44. Table: trial_data_provenance
1.44. Table: trial_data_provenance
Anchor
_bookmark45
_bookmark45
Anchor
_bookmark45
_bookmark45
Table: trial_data_provenance

Columns

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

...

	Columns	Name / Description
	trial_site_pk_id	PRIMARY
	trial_site_pk_id	PK_TRIAL_SITE_PK_ID

Anchor
1.46. Table: workflow
1.46. Table: workflow
Anchor
_bookmark47
_bookmark47
Anchor
_bookmark47
_bookmark47
Table: workflow

Columns

Name	Data type	Description / Attributes
WORKFLOW_ID	bigint(19, 0)
NAME	varchar(50)	Nullable
COLLECTION	varchar(200)	Nullable
SITE	varchar(200)	Nullable
URL	varchar(255)	Nullable
WORKFLOW_TYPE	varchar(50)	Nullable

...

	Columns	Name / Description
	WORKFLOW_ID	PRIMARY

...

Views

...

View: dicom_image

VIEW
Columns

Name	Data type	Description / Attributes
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
Name	Data type	Description / Attributes
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
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
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
STUDY_PK_ID	bigint(19, 0)	Nullable
PROJECT	varchar(200)	Nullable
ACQUISITION_MATRIX	decimal(22, 6)	Nullable Default: 0.000000
DX_DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Default: 0.000000
KVP	decimal(22, 6)	Nullable
SCAN_OPTIONS	varchar(16)	Nullable
DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable
RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable
GANTRY_DETECTOR_TILT	decimal(22, 6)	Nullable
Name	Data type	Description / Attributes
EXPOSURE_TIME	decimal(22, 6)	Nullable
X_RAY_TUBE_CURRENT	decimal(22, 6)	Nullable
EXPOSURE	decimal(22, 6)	Nullable
EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable
CONVOLUTION_KERNEL	varchar(16)	Nullable
REVOLUTION_TIME	decimal(22, 6)	Nullable
SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
TOTAL_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
TABLE_SPEED	decimal(22, 6)	Nullable
TABLE_FEED_PER_ROTATION	decimal(22, 6)	Nullable
CT_PITCH_FACTOR	decimal(22, 6)	Nullable
ANATOMIC_REGION_SEQ	varchar(500)	Nullable

...

View: dicom_series

VIEW
Columns

Name	Data type	Description / Attributes
GENERAL_SERIES_PK_ID	bigint(19, 0)
BODY_PART_EXAMINED	varchar(16)	Nullable
FRAME_OF_REFERENCE_UID	varchar(64)	Nullable
SERIES_LATERALITY	varchar(16)	Nullable
MODALITY	varchar(16)
PROTOCOL_NAME	varchar(64)	Nullable
SERIES_DATE	date	Nullable
SERIES_DESC	varchar(64)	Nullable
SERIES_INSTANCE_UID	varchar(64)	Nullable
SERIES_NUMBER	decimal(22, 6)	Nullable
SYNC_FRAME_OF_REF_UID	varchar(64)	Nullable
STUDY_PK_ID	bigint(19, 0)	Nullable
GENERAL_EQUIPMENT_PK_ID	bigint(19, 0)	Nullable

View: dicom_study

VIEW
Columns

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

Anchor
2.4. View: manufacturer
2.4. View: manufacturer
Anchor
_bookmark52
_bookmark52
Anchor
_bookmark52
_bookmark52
View: manufacturer

VIEW
Columns

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

Anchor
2.5. View: manufacturer_model_software
2.5. View: manufacturer_model_software
Anchor
_bookmark53
_bookmark53
Anchor
_bookmark53
_bookmark53
View: manufacturer_model_software

VIEW
Columns

Name	Data type	Description / Attributes
ID	bigint(19, 0)
MANUFACTURER	varchar(64)	Nullable
MODEL	varchar(64)	Nullable
SOFTWARE	varchar(64)	Nullable

Anchor
2.6. View: number_month
2.6. View: number_month
Anchor
_bookmark54
_bookmark54
Anchor
_bookmark54
_bookmark54
View: number_month

VIEW
Columns

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

Anchor
2.7. View: saved_query_last_exec
2.7. View: saved_query_last_exec
Anchor
_bookmark55
_bookmark55
Anchor
_bookmark55
_bookmark55
View: saved_query_last_exec

VIEW
Columns

Name	Data type	Description / Attributes
SAVED_QUERY_PK_ID	bigint(19, 0)	Nullable
LAST_EXECUTE_DATE	datetime	Nullable

Anchor
2.8. View: software_versions
2.8. View: software_versions
Anchor
_bookmark56
_bookmark56
Anchor
_bookmark56
_bookmark56
View: software_versions

VIEW
Columns

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

...

Content

Space Tools

Page History

Versions Compared

Old Version 8

New Version 9

Key

Table: csm_user

Anchor1.15. Table: csm_user_group1.15. Table: csm_user_group Anchor_bookmark16_bookmark16 Anchor_bookmark16_bookmark16Table: csm_user_group

Anchor1.17. Table: csm_user_pe1.17. Table: csm_user_pe Anchor_bookmark18_bookmark18 Anchor_bookmark18_bookmark18Table: csm_user_pe

Table: ct_image

Anchor1.19. Table: custom_series_list1.19. Table: custom_series_list Anchor_bookmark20_bookmark20 Anchor_bookmark20_bookmark20Table: custom_series_list

Table: custom_series_list_attribute

Table: databasechangelog

Table: databasechangeloglock

Table: deletion_audit_trail

Table: download_data_history

Table: download_history

Table: general_equipment

Table: general_image

Table: general_series

Table: gui_action_history

Table: hibernate_unique_key

Table: login_history

Table: modality_descriptions

Table: mr_image

Table: patient

Table: qc_status_history

Table: query_history

Table: saved_query_attribute

Anchor1.41. Table: species1.41. Table: species Anchor_bookmark42_bookmark42 Anchor_bookmark42_bookmark42Table: species

Anchor1.43. Table: submission_history1.43. Table: submission_history Anchor_bookmark44_bookmark44 Anchor_bookmark44_bookmark44Table: submission_history

Anchor1.44. Table: trial_data_provenance1.44. Table: trial_data_provenance Anchor_bookmark45_bookmark45 Anchor_bookmark45_bookmark45Table: trial_data_provenance

Anchor1.46. Table: workflow1.46. Table: workflow Anchor_bookmark47_bookmark47 Anchor_bookmark47_bookmark47Table: workflow

Views

View: dicom_image

View: dicom_series

View: dicom_study

Anchor2.4. View: manufacturer2.4. View: manufacturer Anchor_bookmark52_bookmark52 Anchor_bookmark52_bookmark52View: manufacturer

Anchor2.5. View: manufacturer_model_software2.5. View: manufacturer_model_software Anchor_bookmark53_bookmark53 Anchor_bookmark53_bookmark53View: manufacturer_model_software

Anchor2.6. View: number_month2.6. View: number_month Anchor_bookmark54_bookmark54 Anchor_bookmark54_bookmark54View: number_month

Anchor2.7. View: saved_query_last_exec2.7. View: saved_query_last_exec Anchor_bookmark55_bookmark55 Anchor_bookmark55_bookmark55View: saved_query_last_exec

Anchor2.8. View: software_versions2.8. View: software_versions Anchor_bookmark56_bookmark56 Anchor_bookmark56_bookmark56View: software_versions

Anchor
1.15. Table: csm_user_group
1.15. Table: csm_user_group
Anchor
_bookmark16
_bookmark16
Anchor
_bookmark16
_bookmark16
Table: csm_user_group

Anchor
1.17. Table: csm_user_pe
1.17. Table: csm_user_pe
Anchor
_bookmark18
_bookmark18
Anchor
_bookmark18
_bookmark18
Table: csm_user_pe

Anchor
1.19. Table: custom_series_list
1.19. Table: custom_series_list
Anchor
_bookmark20
_bookmark20
Anchor
_bookmark20
_bookmark20
Table: custom_series_list

Anchor
1.41. Table: species
1.41. Table: species
Anchor
_bookmark42
_bookmark42
Anchor
_bookmark42
_bookmark42
Table: species

Anchor
1.43. Table: submission_history
1.43. Table: submission_history
Anchor
_bookmark44
_bookmark44
Anchor
_bookmark44
_bookmark44
Table: submission_history

Anchor
1.44. Table: trial_data_provenance
1.44. Table: trial_data_provenance
Anchor
_bookmark45
_bookmark45
Anchor
_bookmark45
_bookmark45
Table: trial_data_provenance

Anchor
1.46. Table: workflow
1.46. Table: workflow
Anchor
_bookmark47
_bookmark47
Anchor
_bookmark47
_bookmark47
Table: workflow

Anchor
2.4. View: manufacturer
2.4. View: manufacturer
Anchor
_bookmark52
_bookmark52
Anchor
_bookmark52
_bookmark52
View: manufacturer

Anchor
2.5. View: manufacturer_model_software
2.5. View: manufacturer_model_software
Anchor
_bookmark53
_bookmark53
Anchor
_bookmark53
_bookmark53
View: manufacturer_model_software

Anchor
2.6. View: number_month
2.6. View: number_month
Anchor
_bookmark54
_bookmark54
Anchor
_bookmark54
_bookmark54
View: number_month

Anchor
2.7. View: saved_query_last_exec
2.7. View: saved_query_last_exec
Anchor
_bookmark55
_bookmark55
Anchor
_bookmark55
_bookmark55
View: saved_query_last_exec

Anchor
2.8. View: software_versions
2.8. View: software_versions
Anchor
_bookmark56
_bookmark56
Anchor
_bookmark56
_bookmark56
View: software_versions