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
	User-defined one to one relation
	Input
	Output
	Input/Output
	Uses dependency
	User-defined uses dependency
	Used by dependency
	User-defined used by dependency

Tables

Columns for Table: collection_descriptions

Key	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

Key	Columns	Name / Description
	collection_descriptions_pk_id	PRIMARY
	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

Columns for Table: csm_application

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

Key	Columns	Name / Description
	APPLICATION_ID	PRIMARY
	APPLICATION_NAME	UQ_APPLICATION_NAME

Table: csm_configuration_props

Columns

Key	Name	Data type	Description / Attributes
	PROPERTY_KEY	varchar(300)	-
-	PROPERTY_VALUE	varchar(3000)	Nullable

Unique keys

Key	Columns	Name / Description
	PROPERTY_KEY	PRIMARY

Table: csm_filter_clause

Columns

Key	Name	Data type	Description / Attributes
	FILTER_CLAUSE_ID	bigint(19, 0)	Identity / Auto increment
_	CLASS_NAME	varchar(100)	_
_	FILTER_CHAIN	varchar(2000)	_
_	TARGET_CLASS_NAME	varchar(100)	_
_	TARGET_CLASS_ATTRIBUTE_NAME	varchar(100)	_
_	TARGET_CLASS_ATTRIBUTE_TYPE	varchar(100)	_
_	TARGET_CLASS_ALIAS	varchar(100)	Nullable
_	TARGET_CLASS_ATTRIBUTE_ALIAS	varchar(100)	Nullable
_	GENERATED_SQL_USER	varchar(4000)	_
_	APPLICATION_ID	bigint(19, 0)	_
_	UPDATE_DATE	date	_
_	GENERATED_SQL_GROUP	varchar(4000)	_

Unique keys

Key	Columns	Name / Description
	FILTER_CLAUSE_ID	PRIMARY

Table: csm_group

Columns

Key	Name	Data type	Description / Attributes
	GROUP_ID	bigint(19, 0)	Identity / Auto increment
	GROUP_NAME	varchar(255)	_
_	GROUP_DESC	varchar(200)	Nullable
_	UPDATE_DATE	date	Default: 1950-01-01
	APPLICATION_ID	bigint(19, 0)	References: csm_application

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
	GROUP_ID	PRIMARY
	APPLICATION_ID, GROUP_NAME	UQ_GROUP_GROUP_NAM_

Table: csm_mapping

Columns

Key	Name	Data type	Description / Attributes
	MAPPING_ID	bigint(19, 0)	Identity _/ Auto increment
	APPLICATION_ID	bigint(19, 0)	References: csm_application
_	OBJECT_NAME	varchar(100)	_
	ATTRIBUTE_NAME	varchar(100)	_
_	OBJECT_PACKAGE_NAME	varchar(100)	Nullable
_	TABLE_NAME	varchar(100)	Nullable
_	TABLE_NAME_GROUP	varchar(100)	Nullable
_	TABLE_NAME_USER	varchar(100)	Nullable
_	VIEW_NAME_GROUP	varchar(100)	Nullable
_	VIEW_NAME_USER	varchar(100)	Nullable
_	ACTIVE_FLAG	tinyint(3, 0)	Default: 0
_	MAINTAINED_FLAG	tinyint(3, 0)	Default: 0

Links to

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

Unique keys

Key	Columns	Name / Description
	MAPPING_ID	PRIMARY
	OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID	UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

Table: csm_password_history

Columns

Key	Name	Data type	Description / Attributes
	CSM_PASSWORD_HISTORY_ID	bigint(19, 0)	Identity / Auto increment
_	LOGIN_NAME	varchar(500)	Nullable
_	PASSWORD	varchar(255)	Nullable

Unique keys

Key	Columns	Name / Description
	CSM_PASSWORD_HISTORY_ID	PRIMARY

Table: csm_pg_pe

Columns

Key	Name	Data type	Description / Attributes
	PG_PE_ID	bigint(19, 0)	Identity / Auto increment
	PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
_	UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Unique keys

Key	Columns	Name / Description
	PG_PE_ID	PRIMARY
	PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID	UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns

Key	Name	Data type	Description / Attributes
	PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
	PRIVILEGE_NAME	varchar(100)	-
_	PRIVILEGE_DESCRIPTION	varchar(200)	Nullable
_	UPDATE_DATE	date	Default: 1950-01-01

Linked from

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

Unique keys

Key	Columns	Name / Description
	PRIVILEGE_ID	PRIMARY
	PRIVILEGE_NAME	UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

Key	Name	Data type	Description / Attributes
	PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
_	PROTECTION_ELEMENT_NAME	varchar(100)
_	PROTECTION_ELEMENT_DESCRIPTI ON	varchar(200)	Nullable
	OBJECT_ID	varchar(100)
	ATTRIBUTE	varchar(100)	Nullable
_	PROTECTION_ELEMENT_TYPE	varchar(100)	Nullable
	APPLICATION_ID	bigint(19, 0)
_	UPDATE_DATE	date	Default: 1950-01-01
	ATTRIBUTE_VALUE	varchar(100)	Nullable

Linked from

Relationship	Table	Join	Title / Name / Description
	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
	csm_user_pe	csm_protection_element.PROTECTION _ELEMENT_ID = csm_user_pe.PROTECTION_ELEMENT_ ID	FK_PROTECTION_ELEMENT_USER

Unique keys

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

Table: csm_protection_group

Columns

Key	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

Relationship	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

Key	Columns	Name / Description
	PROTECTION_GROUP_ID	PRIMARY
	APPLICATION_ID, PROTECTION_GROUP_NAME	UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns

Key	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

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

Linked from

Relationship	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

Key	Columns	Name / Description
	ROLE_ID	PRIMARY
	APPLICATION_ID, ROLE_NAME	UQ_ROLE_ROLE_NAME

Table: csm_role_privilege

Columns

Key	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

Relationship	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

Key	Columns	Name / Description
	ROLE_PRIVILEGE_ID	PRIMARY
	PRIVILEGE_ID, ROLE_ID	UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user

Columns

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

Linked from

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

Unique keys

Key	Columns	Name / Description
	USER_ID	PRIMARY

Table: csm_user_group

Columns

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

Icon	Table	Join	Title / Name / Description
	csm_group	csm_user_group.GROUP_ID = csm_group.GROUP_ID	FK_UG_GROUP
	csm_user	csm_user_group.USER_ID = csm_user.USER_ID	FK_USER_GROUP

Unique keys

Icon	Columns	Name / Description
	USER_GROUP_ID	PRIMARY

Table: csm_user_group_role_pg

Columns

Key	Name	Data type	Description / Attributes
	USER_GROUP_ROLE_PG_ID	bigint(19, 0)	Identity / Auto increment
_	USER_ID	bigint(19, 0)	Nullable References: csm_user
_	GROUP_ID	bigint(19, 0)	Nullable References: csm_group
_	ROLE_ID	bigint(19, 0)	References: csm_role
_	PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
_	UPDATE_DATE	date	Default: 1950-01-01

Links to

Table	Join	Title / Name / Description
csm_group	csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
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
csm_role	csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE
csm_user	csm_user_group_role_pg.USER_ID = csm_user.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

Unique keys

Key	Columns	Name / Description
	USER_GROUP_ROLE_PG_ID	PRIMARY

Table: csm_user_pe

Columns

Key	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

Links to

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

Unique keys

Key	Columns	Name / Description
	USER_PROTECTION_ELEMENT_ID	PRIMARY
	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

Key	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

Links to

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

Unique keys

Key	Columns	Name / Description
	ct_image_pk_id	PRIMARY
	ct_image_pk_id	PK_CT_IMAGE_PK_ID

Table: custom_series_list

Columns

Key	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

Relationship	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

Key	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

Key	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

Links to

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

Unique keys

Key	Columns	Name / Description
	custom_series_list_attribute_p	PRIMARY
	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Key	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

Key	Columns	Name / Description
	ID, AUTHOR, FILENAME	PRIMARY

Table: databasechangeloglock

Columns

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

Unique keys

Key	Columns	Name / Description
	ID	PRIMARY

Table: deletion_audit_trail

Columns

Key	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

Key	Columns	Name / Description
	deletion_pk_id	PRIMARY

Table: download_data_history

Columns

Key	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

Key	Columns	Name / Description
	download_data_history_pk_id	PRIMARY

Table: download_history

Columns

Key	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

Key	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

Icon	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

Icon	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

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

Icon	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

Icon	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

Links to

Icon	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

Icon	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

Unique keys

Icon	Columns	Name / Description
	GUI_ACTION_HISTORY_PK_ID	PRIMARY

Table: hibernate_unique_key

Columns

Icon1	Icon2	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

Unique keys

Icon	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

Icon	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

Icon	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

Icon	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

Links to

Icon	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

Icon	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

Icon	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

Unique keys

Icon	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

Links to

Icon	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

Icon	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

Icon	Columns	Name / Description
	query_history_pk_id	PRIMARY
	query_history_pk_id	PK_QUERY_HISTORY_PK_ID

Table: query_history_attribute

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

Links to

Icon	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

Icon	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

Links to

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

Linked from

Icon	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

Icon	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

Links to

Icon	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

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

Icon	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

Icon	Columns	Name / Description
	site_pk_id	PRIMARY
	site_pk_id	SITE_PK_ID

Table: species

Columns

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

Unique keys

Icon	Columns	Name / Description
	species_code	PRIMARY

Table: study

Columns

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

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

Linked from

Icon	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

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

Icon	Columns	Name / Description
	submission_history_pk_id	submission_history_pk_id

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

Linked from

Icon	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

Icon	Columns	Name / Description
	trial_dp_pk_id	PRIMARY
	trial_dp_pk_id	PK_TRIAL_DP_PK_ID

Table: trial_site

Columns

Name	Data type	Description / Attributes
trial_site_pk_id	bigint(19, 0)
trial_site_id	varchar(64)	Nullable
Name	Data type	Description / Attributes
trial_site_name	varchar(64)	Nullable
trial_pk_id	bigint(19, 0)	Nullable

Unique keys

Icon	Columns	Name / Description
	trial_site_pk_id	PRIMARY
	trial_site_pk_id	PK_TRIAL_SITE_PK_ID

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

Unique keys

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

View: manufacturer

VIEW
Columns

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

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

View: number_month

VIEW
Columns

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

View: saved_query_last_exec

VIEW
Columns

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

View: software_versions

VIEW
Columns

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

View: study_series_number

VIEW
Columns

Name	Data type	Description / Attributes
PATIENT_PK_ID	bigint(19, 0)	Nullable
PATIENT_ID	varchar(64)	Nullable
PROJECT	varchar(50)	Nullable
STUDY_NUMBER	bigint(19, 0)	Default: 0
SERIES_NUMBER	bigint(19, 0)	Default: 0

Content

Space Tools

NBIA Data Dictionary

Legend

Tables

Columns for Table: collection_descriptions

Columns for Table: csm_application

Table: csm_configuration_props

Table: csm_filter_clause

Table: csm_group

Table: csm_mapping

Table: csm_password_history

Table: csm_pg_pe

Table: csm_privilege

Table: csm_protection_element

Table: csm_protection_group

Table: csm_role

Table: csm_role_privilege

Table: csm_user

Table: csm_user_group

Table: csm_user_group_role_pg

Table: csm_user_pe

Table: ct_image

Table: 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: 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

Views

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