Error rendering macro 'rw-search'

null

Page History

Versions Compared

Key

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

...

Columns for Table: collection_descriptions

Name	Data type	Description / Attributes
collection_descriptions_pk_id	bigint(19, 0)
collection_name	varchar(64)	Nullable
user_name	varchar(20)	Nullable
description	mediumtext	Nullable
collection_descriptions_timest	date	Nullable

Unique keys

Icon1	Columns	Name / Description
	collection_descriptions_pk_id	PRIMARY
	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

...

Name	Data type	Description / Attributes
APPLICATION_ID	bigint(19, 0)	Identity / Auto increment
APPLICATION_NAME	varchar(255)
APPLICATION_DESCRIPTION	varchar(200)
DECLARATIVE_FLAG	tinyint(3, 0)	Default: 0
ACTIVE_FLAG	tinyint(3, 0)	Default: 0
UPDATE_DATE	date	Default: 1950-01-01
DATABASE_URL	varchar(100)	Nullable
DATABASE_USER_NAME	varchar(100)	Nullable
DATABASE_PASSWORD	varchar(100)	Nullable
DATABASE_DIALECT	varchar(100)	Nullable
DATABASE_DRIVER	varchar(100)	Nullable
CSM_VERSION	varchar(20)	Nullable

Linked from

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

Unique keys

	Columns	Name / Description
	APPLICATION_ID	PRIMARY
	APPLICATION_NAME	UQ_APPLICATION_NAME

...

Name	Data type	Description / Attributes
PROTECTION_GROUP_ID	bigint(19, 0)	Identity / Auto increment
PROTECTION_GROUP_NAME	varchar(100)
PROTECTION_GROUP_DESCRIPTIO N	varchar(200)	Nullable
APPLICATION_ID	bigint(19, 0)	References: csm_application
LARGE_ELEMENT_COUNT_FLAG	tinyint(3, 0)
UPDATE_DATE	date	Default: 1950-01-01
PARENT_PROTECTION_GROUP_ID	bigint(19, 0)	Nullable References: csm_protection_group

Links to

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

Linked from

Table	Join	Title / Name / Description
csm_protection_group	csm_protection_group.PROTECTION_ GROUP_ID = csm_protection_group.PARENT_PROT ECTION_GROUP_ID	FK_PROTECTION_GROUP
csm_pg_pe	csm_protection_group.PROTECTION_ GROUP_ID = csm_pg_pe.PROTECTION_GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT
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

Unique keys

	Columns	Name / Description
	PROTECTION_GROUP_ID	PRIMARY
	APPLICATION_ID, PROTECTION_GROUP_NAME	UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

...

Table: csm_role

...

Columns

Name	Data type	Description / Attributes
ROLE_ID	bigint(19, 0)	Identity / Auto increment
ROLE_NAME	varchar(100)
ROLE_DESCRIPTION	varchar(200)	Nullable
APPLICATION_ID	bigint(19, 0)	References: csm_application
ACTIVE_FLAG	tinyint(3, 0)
UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Linked from

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

Unique keys

	Columns	Name / Description
	ROLE_ID	PRIMARY
	APPLICATION_ID, ROLE_NAME	UQ_ROLE_ROLE_NAME

...

Table: csm_role_privilege

...

Columns

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

Links to

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

Unique keys

	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
Image Added	Image Added	USER_ID

...

Image Removed

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_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

...

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

Linked from

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

Unique keys

	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
...
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
Unique keys

Columns
Name / Description

ID, AUTHOR, FILENAME
PRIMARY
...

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
Unique keys

Columns
Name / Description

ID
PRIMARY
...
...

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

Unique keys

	Columns	Name / Description
	deletion_pk_id	PRIMARY

...

Table: download_data_history

...

Columns

Name
Data type
...
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
Unique keys

Columns
Name / Description

download_data_history_pk_id
PRIMARY
...
...

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

Unique keys

	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

Linked from

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

Unique keys

	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

...

	Columns	Name / Description
	modality_descriptions_pk_id	PRIMARY
	modality_descriptions_pk_id	MD_COLLECTION_DESC_PK_ID

...

_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

...

_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
	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
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

...

	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

...

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

...

Content

Space Tools

Page History

Versions Compared

Old Version 7

New Version 8

Key

Columns for Table: collection_descriptions

Unique keys

Linked from

Unique keys

Links to

Linked from

Unique keys

Table: csm_role

Columns

Links to

Linked from

Unique keys

Table: csm_role_privilege

Columns

Links to

Unique keys

Table: csm_user

Table: ct_image

Table: custom_series_list_attribute

Table: databasechangelog

Table: databasechangeloglock

...ColumnsNameData typeDescription / AttributesIDint(10, 0)LOCKEDtinyint(3, 0)LOCKGRANTEDdatetimeNullableLOCKEDBYvarchar(255)NullableUnique keysColumnsName / DescriptionIDPRIMARY......

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

Table: saved_query_attribute

View: dicom_study

...

Columns

Name
Data type
Description / Attributes

ID
int(10, 0)

LOCKED
tinyint(3, 0)

LOCKGRANTED
datetime
Nullable

LOCKEDBY
varchar(255)
Nullable
Unique keys

Columns
Name / Description

ID
PRIMARY
...
...