Page History

Versions Compared

Key

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

Panel

Table of Contents

Legend

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

...

Columns for Table: collection_descriptions

Icon1	Icon2Key	Name	Data type
Image RemovedImage RemovedImage Added	collection_descriptions_pk_id	bigint(19, 0)	-
- Image Removed	collection_name	varchar(64)	Nullable
Image Removed -	user_name	varchar(20)	Nullable
Image Removed -	description	mediumtext	Nullable
Image Removed -	collection_descriptions_timest	date	Nullable

Unique keys

Icon1Key	Columns	Name / Description
Image Modified	collection_descriptions_pk_id	PRIMARY
Image Modified	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

Columns for Table: csm_application

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	APPLICATION_ID	PRIMARY
Image Modified	APPLICATION_NAME	UQ_APPLICATION_NAME

Table: csm_configuration_props

Columns

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

Key

Name

Data type

Description / Attributes

Image RemovedImage RemovedImage Added

PROPERTY_KEY

varchar(300)

Image Removed

PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	PROPERTY_KEY	PRIMARY

Table: csm_filter_clause

Columns

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

Unique keys

Key	Columns	Name / Description
Image Modified	FILTER_CLAUSE_ID	PRIMARY

Table: csm_group

Columns

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

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	GROUP_ID	PRIMARY
Image Modified	APPLICATION_ID, GROUP_NAME	UQ_GROUP_GROUP_NAMENAM_

Table: csm_mapping

Columns

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	MAPPING_ID	PRIMARY
Image Modified	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
Image RemovedImage RemovedImage Added	CSM_PASSWORD_HISTORY_ID	bigint(19, 0)	Identity / Auto increment
Image Removed _	LOGIN_NAME	varchar(500)	Nullable
Image Removed _	PASSWORD	varchar(255)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	CSM_PASSWORD_HISTORY_ID	PRIMARY

Table: csm_pg_pe

Columns

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	PG_PE_ID	PRIMARY	Columns	Name / Description
Image Modified	PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID	UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	PRIVILEGE_ID	PRIMARY
Image Modified	PRIVILEGE_NAME	UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	PROTECTION_ELEMENT_ID	PRIMARY
Image Modified	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
Image RemovedImage AddedImage Removed	PROTECTION_GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image RemovedImage AddedImage Removed	PROTECTION_GROUP_NAME	varchar(100)
Image Removed _	PROTECTION_GROUP_DESCRIPTIO N	varchar(200)	Nullable
Image RemovedImage RemovedImage Added	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Removed _	LARGE_ELEMENT_COUNT_FLAG	tinyint(3, 0)
Image Removed _	UPDATE_DATE	date	Default: 1950-01-01
Image Removed _	PARENT_PROTECTION_GROUP_ID	bigint(19, 0)	Nullable References: csm_protection_group

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	PROTECTION_GROUP_ID	PRIMARY
Image Modified	APPLICATION_ID, PROTECTION_GROUP_NAME	UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns

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

Links to

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

Linked from

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

Unique keys

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

Table: csm_role_privilege

Columns

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	ROLE_PRIVILEGE_ID	PRIMARY
Image Modified	PRIVILEGE_ID, ROLE_ID	UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user

Columns

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	USER_ID	PRIMARY

...

Table: csm_user_group

...

Columns

Key	Name	Data type	Description / Attributes
Image Added

...

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	USER_GROUP_ID	PRIMARY

...

Table: csm_user_group_role_pg

...

Columns

...

Key

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	USER_GROUP_ROLE_PG_ID	PRIMARY

...

Table: csm_user_pe

...

Columns

...

Key

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	USER_PROTECTION_ELEMENT_ID	PRIMARYColumns	Name / Description
Image Modified	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	ct_image_pk_id	PRIMARY
Image Modified	ct_image_pk_id	PK_CT_IMAGE_PK_ID

...

Table: custom_series_list

...

Columns

Key

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
Image Modified	CUSTOM_SERIES_LIST_PK_ID	CUSTOM_SERIES_LIST_PK_ID

Table: custom_series_list_attribute

Columns

Key

Name

Data type

Description / Attributes

Image RemovedImage RemovedImage Added

custom_series_list_attribute_p

bigint(19, 0)

Image Removed

SERIES_INSTANCE_UID

varchar(200)

Nullable

Image Removed

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	custom_series_list_attribute_p	PRIMARY
Image Modified	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	ID	varchar(63)	Image Removed _
Image RemovedImage Added	AUTHOR	varchar(63)	Image Removed _
Image RemovedImage Added	FILENAME	varchar(200)	_
Image Removed _	DATEEXECUTED	datetime	_
Image Removed _	MD5SUM	varchar(32)	Nullable
Image Removed _	DESCRIPTION	varchar(255)	Nullable
Image Removed _	COMMENTS	varchar(255)	Nullable
Image Removed -	TAG	varchar(255)	Nullable
Image Removed -	LIQUIBASE	varchar(10)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	ID, AUTHOR, FILENAME	PRIMARY

Table: databasechangeloglock

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	IDID	int(10, 0)	-
Image Removed -	LOCKED	tinyint(3, 0)	-
- Image Removed	LOCKGRANTED	datetime	Nullable
Image Removed -	LOCKEDBY	varchar(255)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	ID	PRIMARY

Table: deletion_audit_trail

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage RemovedImage Added	deletion_pk_id	bigint(19, 0)	-
Image Removed -	data_id	varchar(64)	Nullable
Image Removed -	data_type	varchar(50)	Nullable
Image Removed -	total_image	bigint(19, 0)	Nullable
Image Removed -	user_name	varchar(50)	Nullable
Image Removed -	time_stamp	datetime	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	deletion_pk_id	PRIMARY

Table: download_data_history

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage RemovedImage Added	download_data_history_pk_id	bigint(19, 0)	-
- Image Removed	series_instance_uid	varchar(64)	Nullable
Image Removed -	login_name	varchar(100)	Nullable
Image Removed -	download_timestamp	date	Nullable
Image Removed -	download_type	varchar(20)	Nullable
Image Removed -	size_	decimal(22, 2)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	download_data_history_pk_id	PRIMARY

Table: download_history

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	download_history_pk_id	bigint(19, 0)	-
Image Removed -	user_id	bigint(19, 0)	Nullable
Image Removed -	timestamp	datetime	Nullable
Image Removed -	total_file_size	decimal(22, 2)	Nullable
Image Removed -	download_file_name	varchar(300)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	download_history_pk_id	PRIMARY

Table: general_equipment

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	general_equipment_pk_id	bigint(19, 0)	-
Image Removed -	manufacturer	varchar(64)	Nullable
Image Removed -	institution_name	varchar(64)	Nullable
Image Removed -	manufacturer_model_name	varchar(64)	Nullable
Image Removed -	software_versions	varchar(64)	Nullable
Image Removed -	institution_address	varchar(1024)	Nullable
Image Removed -	station_name	varchar(16)	Nullable
Image Removed -	device_serial_number	varchar(64)	Nullable

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	general_equipment_pk_id	PRIMARY
Image Modified	general_equipment_pk_id	PK_G_EQUIPMENT_ID

Table: general_image

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	image_pk_id	bigint(19, 0)	-
Image Removed -	instance_number	bigint(19, 0)	Nullable
Image Removed -	content_date	date	Nullable
Image Removed -	content_time	varchar(16)	Nullable
Image Removed -	image_type	varchar(16)	Nullable
Image Removed -	acquisition_date	date	Nullable
Image Removed -	acquisition_time	varchar(16)	Nullable
Image Removed -	acquisition_number	decimal(22, 6)	Nullable
Image Removed -	lossy_image_compression	varchar(16)	Nullable
Image Removed -	pixel_spacing	decimal(22, 6)	Nullable
Image Removed -	image_orientation_patient	varchar(200)	Nullable
Image Removed -	image_position_patient	varchar(200)	Nullable
Image Removed -	slice_thickness	decimal(22, 6)	Nullable
Image Removed -	slice_location	decimal(22, 6)	Nullable
Image Removed -	i_rows	decimal(22, 6)	Nullable
Image Removed -	i_columns	decimal(22, 6)	Nullable
Image Removed -	contrast_bolus_agent	varchar(64)	Nullable
Image Removed -	contrast_bolus_route	varchar(64)	Nullable
Image Removed -	sop_class_uid	varchar(64)	Nullable
Image RemovedImage AddedImage Removed	sop_instance_uid	varchar(64)	Nullable
Image Removed -	general_series_pk_id	bigint(19, 0)	Nullable References: general_series
Image Removed -	patient_position	varchar(16)	Nullable
Image Removed -	source_to_detector_distance	decimal(22, 6)	Nullable
Image Removed -	source_subject_distance	decimal(22, 6)	Nullable
Image Removed -	focal_spot_size	decimal(22, 6)	Nullable
-	Name	Data type	Description / Attributes
Image Removed -	storage_media_file_set_uid	varchar(64)	Nullable
Image Removed -	dicom_file_uri	varchar(2000)	Nullable
Image Removed -	acquisition_datetime	varchar(50)	Nullable
Image Removed -	image_comments	varchar(4000)	Nullable
Image Removed -	image_receiving_timestamp	datetime	Nullable
Image Removed -	curation_timestamp	datetime	Nullable
Image Removed -	annotation	varchar(20)	Nullable
Image RemovedImage AddedImage Removed	submission_date	date	Nullable
Image Removed -	dicom_size	decimal(22, 6)	Nullable
Image Removed -	image_laterality	varchar(16)	Nullable
Image Removed -	trial_dp_pk_id	bigint(19, 0)	Nullable
Image Removed -	patient_id	varchar(64)	Nullable
Image Removed -	study_instance_uid	varchar(500)	Nullable
Image Removed -	series_instance_uid	varchar(64)	Nullable
Image Removed -	patient_pk_id	bigint(19, 0)	Nullable References: patient
Image Removed -	study_pk_id	bigint(19, 0)	Nullable References: study
Image Removed -	project	varchar(200)	Nullable
Image Removed -	acquisition_matrix	decimal(22, 6)	Nullable Default: 0.000000
Image Removed -	dx_data_collection_diameter	decimal(22, 6)	Nullable Default: 0.000000
Image Removed -	md5_digest	varchar(50)	Nullable
Image Removed -	US_FRAME_NUMBER	varchar(50)	Nullable
Image Removed -	US_COLOR_DATA_PRESENT	varchar(50)	Nullable
Image Removed -	US_MULTI_MODALITY	varchar(50)	Nullable

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	image_pk_id	PRIMARY
Image Modified	image_pk_id, submission_date	Image_Visibility_Submitted_IDX
Image Modified	image_pk_id	PK_IMAGE_PK_ID
Image Modified	sop_instance_uid	sop_instance_uid

Table: general_series

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	general_series_pk_id	bigint(19, 0)	-
- Image Removed	modality	varchar(16)	Image Removed -
Image RemovedImage Added	series_instance_uid	varchar(64)	Nullable
Image Removed -	series_laterality	varchar(16)	Nullable
Image Removed -	series_date	date	Nullable
Image Removed -	protocol_name	varchar(64)	Nullable
Image Removed -	series_desc	varchar(64)	Nullable
Image Removed -	body_part_examined	varchar(16)	Nullable
Image Removed -	study_pk_id	bigint(19, 0)	Nullable References: study
Image Removed -	general_equipment_pk_id	bigint(19, 0)	Nullable References: general_equipment
Image Removed -	trial_protocol_id	varchar(64)	Nullable
Image Removed -	trial_protocol_name	varchar(64)	Nullable
Image Removed -	trial_site_name	varchar(64)	Nullable
Image Removed -	study_date	date	Nullable
Image Removed -	study_desc	varchar(64)	Nullable
Image Removed -	admitting_diagnoses_desc	varchar(64)	Nullable
Image Removed -	patient_age	varchar(4)	Nullable
Image Removed -	patient_sex	varchar(16)	Nullable
Image Removed -	patient_weight	decimal(22, 6)	Nullable
Image Removed -	age_group	varchar(10)	Nullable
Image Removed -	patient_pk_id	bigint(19, 0)	Nullable
Image Removed -	series_number	decimal(22, 6)	Nullable
Image Removed -	sync_frame_of_ref_uid	varchar(64)	Nullable
Image Removed -	patient_id	varchar(64)	Nullable
Image Removed -	frame_of_reference_uid	varchar(64)	Nullable
Image Removed -	visibility	varchar(5)	Nullable
Image Removed -	security_group	varchar(50)	Nullable
Image Removed -	annotations_flag	varchar(5)	Nullable
-	Name	Data type	Description / Attributes
Image Removed -	project	varchar(200)	Nullable
Image Removed -	site	varchar(40)	Nullable
Image Removed -	study_instance_uid	varchar(500)	Nullable
Image Removed -	max_submission_timestamp	datetime	Nullable
Image Removed -	batchNum	int(10, 0)	Nullable
Image Removed -	submission_type	varchar(100)	Nullable
Image Removed -	released_status	varchar(50)	Nullable
Image Removed -	third_party_analysis	varchar(4)	Nullable
Image Removed -	description_uri	varchar(500)	Nullable

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	general_series_pk_id	PRIMARY
Image Modified	general_series_pk_id	PK_G_SERIES_PK_ID
Image Modified	series_instance_uid	series_instance_uid

Table: gui_action_history

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage AddedImage Removed	GUI_ACTION_HISTORY_PK_ID	bigint(19, 0)	Default: 0
Image Removed -	ACTION_TIMESTAMP	date	Nullable
Image Removed -	ACTION	varchar(255)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	GUI_ACTION_HISTORY_PK_ID	PRIMARY

Table: hibernate_unique_key

Columns

Key	Name	Data type	Description / Attributes
Image Removed -	next_hi	bigint(19, 0)	-

Table: login_history

Columns

Key	Name	Data type	Description / Attributes
Image RemovedImage RemovedImage Added	login_history_pk_id	bigint(19, 0)	-
Image Removed -	login_timestamp	datetime	Nullable
Image Removed -	ip_address	varchar(15)	Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	login_history_pk_id	PRIMARY
Image Modified	login_history_pk_id	PK_LOGIN_HISTORY_PK_ID

Table: modality_descriptions

Columns

Key

Name

Data type

Description / Attributes

Image RemovedImage RemovedImage Added

modality_descriptions_pk_id

bigint(19, 0)

Image Removed

modality_name

varchar(20)

Nullable

Image Removed

description

mediumtext

Nullable

Unique keys

Key	Columns	Name / Description
Image Modified	modality_descriptions_pk_id	PRIMARY
Image Modified	modality_descriptions_pk_id	MD_COLLECTION_DESC_PK_ID

Table: mr_image

Columns

Key	Name	Data type	Description / Attributes
Image Removed -	IMAGE_TYPE_VALUE_3	varchar(16)	-
Image Removed -	SCANNING_SEQUENCE	varchar(126)	-
Image Removed -	SEQUENCE_VARIANT	varchar(126)	-
Image Removed -	REPETITION_TIME	decimal(22, 10)	Nullable
Image Removed -	ECHO_TIME	decimal(22, 10)	Nullable
Image Removed -	INVERSION_TIME	decimal(22, 10)	Nullable
Image Removed -	SEQUENCE_NAME	varchar(64)	Nullable	Name
-	Data type	Description / Attributes	Image Removed IMAGED_NUCLEUS	varchar(64)	Nullable
Image Removed -	MAGNETIC_FIELD_STRENGTH	decimal(22, 10)	Nullable
Image Removed -	SAR	decimal(22, 10)	Nullable
Image Removed -	DB_DT	decimal(22, 10)	Nullable
Image Removed -	TRIGGER_TIME	decimal(22, 10)	Nullable
Image Removed -	ANGIO_FLAG	varchar(1)	Nullable
Image Removed -	IMAGE_PK_ID	bigint(19, 0)	References: general_image
Image RemovedImage AddedImage Removed	MR_IMAGE_PK_ID	bigint(19, 0)	Identity / Auto increment
Image Removed -	GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable References: general_series

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	MR_IMAGE_PK_ID	PRIMARY

Table: patient

Columns

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

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	patient_pk_id	PRIMARY
Image Modified	patient_pk_id	PK_PATINET_PK_ID

Table: qc_status_history

Columns

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

Unique keys

Key	Columns	Name / Description
Image Modified	qc_status_history_pk_id	PRIMARY
Image Modified	qc_status_history_pk_id	PK_QC_STATUS_HISTORY_PK_ID

Table: query_history

Columns

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

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	query_history_pk_id	PRIMARY
Image Modified	query_history_pk_id	PK_QUERY_HISTORY_PK_ID

...

Table: query_history_attribute

...

Columns

...

Key

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	query_history_attribute_pk_id	PRIMARY
Image Modified	query_history_attribute_pk_id	PK_Q_H_A_PK_ID

Table: saved_query

Columns

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

Links to

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	saved_query_pk_id	PRIMARY
Image Modified	saved_query_pk_id	PK_SAVED_Q_PK_ID

Table: saved_query_attribute

Columns

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	saved_query_attribute_pk_id	PRIMARY
Image Modified	saved_query_attribute_pk_id	PK_S_Q_A_PK_ID

...

Table: site

...

Columns

...

Key

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

Links to

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

Unique keys

Key	Columns	Name / Description
Image Modified	site_pk_id	PRIMARY
Image Modified	site_pk_id	SITE_PK_ID

...

Table: species

...

Columns

...

Key

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

Unique keys

Key	Columns	Name / Description
Image Modified	species_code	PRIMARY

...

Table: study

...

Columns

...

Columns

Key

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

Links to

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

Linked from

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

Unique keys

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

...

Table: submission_history

...

Columns

Key	Name	Data type

...

Columns

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

Unique keys

Key	Columns	Name / Description
Image Modified	submission_history_pk_id	submission_history_pk_id

...

Table: trial_data_provenance

...

Columns

Key

...

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

Linked from

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

Unique keys

Key	Columns	Name / Description
Image Modified	trial_dp_pk_id	PRIMARY
Image Modified	trial_dp_pk_id	PK_TRIAL_DP_PK_ID

...

Table: trial_site

...

Columns
...
Key
Image Removed
Name
Data type
Description / Attributes
Image Removed
Image Added
trial_site_pk_id
bigint(19, 0)
-
Image Removed
-
trial_site_id
varchar(64)
Nullable
Name
Data type
Description / Attributes
Image Removed
-
trial_site_name
varchar(64)
Nullable
Image Removed
-
trial_pk_id
bigint(19, 0)
Nullable

Unique keys
Key
Columns
Name / Description
Image Modified
trial_site_pk_id
PRIMARY

Image Modified
trial_site_pk_id
PK_TRIAL_SITE_PK_ID
...
...

Table: workflow

...

Columns

Key

...

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

Unique keys

Key	Columns	Name / Description
Image Modified	WORKFLOW_ID	PRIMARY

...

Views

View: dicom_image

...

VIEW
Columns

Image Removed

Name	Data type	Description / Attributes
IMAGE_PK_ID	bigint(19, 0) Image Removed
INSTANCE_NUMBER	bigint(19, 0)	Nullable Image Removed
CONTENT_DATE	date	Nullable Image Removed
CONTENT_TIME	varchar(16)	Nullable Image Removed
IMAGE_TYPE	varchar(16)	Nullable Image Removed
ACQUISITION_DATE	date	Nullable Image Removed
ACQUISITION_TIME	varchar(16)	Nullable Image Removed
ACQUISITION_NUMBER	decimal(22, 6)	Nullable Image Removed
LOSSY_IMAGE_COMPRESSION	varchar(16)	Nullable Image Removed
PIXEL_SPACING	decimal(22, 6)	Nullable Image Removed
IMAGE_ORIENTATION_PATIENT	varchar(200)	Nullable Image Removed
IMAGE_POSITION_PATIENT	varchar(200)	Nullable	Name	Data type	Description / Attributes	Image Removed
SLICE_THICKNESS	decimal(22, 6)	Nullable Image Removed
SLICE_LOCATION	decimal(22, 6)	Nullable Image Removed
I_ROWS	decimal(22, 6)	Nullable Image Removed
I_COLUMNS	decimal(22, 6)	Nullable Image Removed
CONTRAST_BOLUS_AGENT	varchar(64)	Nullable Image Removed
CONTRAST_BOLUS_ROUTE	varchar(64)	Nullable Image Removed
SOP_CLASS_UID	varchar(64)	Nullable Image Removed
SOP_INSTANCE_UID	varchar(64)	Nullable Image Removed
GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable Image Removed
PATIENT_POSITION	varchar(16)	Nullable Image Removed
SOURCE_TO_DETECTOR_DISTANCE	decimal(22, 6)	Nullable Image Removed
SOURCE_SUBJECT_DISTANCE	decimal(22, 6)	Nullable Image Removed
FOCAL_SPOT_SIZE	decimal(22, 6)	Nullable Image Removed
STORAGE_MEDIA_FILE_SET_UID	varchar(64)	Nullable Image Removed
DICOM_FILE_URI	varchar(2000)	Nullable Image Removed
ACQUISITION_DATETIME	varchar(50)	Nullable Image Removed
IMAGE_COMMENTS	varchar(4000)	Nullable Image Removed
IMAGE_RECEIVING_TIMESTAMP	datetime	Nullable Image Removed
CURATION_TIMESTAMP	datetime	Nullable Image Removed
ANNOTATION	varchar(20)	Nullable Image Removed
SUBMISSION_DATE	date	Nullable Image Removed
DICOM_SIZE	decimal(22, 6)	Nullable Image Removed
IMAGE_LATERALITY	varchar(16)	Nullable Image Removed
TRIAL_DP_PK_ID	bigint(19, 0)	Nullable Image Removed
PATIENT_ID	varchar(64)	Nullable Image Removed
STUDY_INSTANCE_UID	varchar(500)	Nullable Image Removed
SERIES_INSTANCE_UID	varchar(64)	Nullable Image Removed
PATIENT_PK_ID	bigint(19, 0)	Nullable Image Removed
STUDY_PK_ID	bigint(19, 0)	Nullable Image Removed
PROJECT	varchar(200)	Nullable Image Removed
ACQUISITION_MATRIX	decimal(22, 6)	Nullable Default: 0.000000 Image Removed
DX_DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Default: 0.000000 Image Removed
KVP	decimal(22, 6)	Nullable Image Removed
SCAN_OPTIONS	varchar(16)	Nullable Image Removed
DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Image Removed
RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable Image Removed
GANTRY_DETECTOR_TILT	decimal(22, 6)	Nullable
Name	Data type	Description / Attributes Image Removed
EXPOSURE_TIME	decimal(22, 6)	Nullable Image Removed
X_RAY_TUBE_CURRENT	decimal(22, 6)	Nullable Image Removed
EXPOSURE	decimal(22, 6)	Nullable Image Removed
EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable Image Removed
CONVOLUTION_KERNEL	varchar(16)	Nullable Image Removed
REVOLUTION_TIME	decimal(22, 6)	Nullable Image Removed
SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable Image Removed
TOTAL_COLLIMATION_WIDTH	decimal(22, 6)	Nullable Image Removed
TABLE_SPEED	decimal(22, 6)	Nullable Image Removed
TABLE_FEED_PER_ROTATION	decimal(22, 6)	Nullable Image Removed
CT_PITCH_FACTOR	decimal(22, 6)	Nullable Image Removed
ANATOMIC_REGION_SEQ	varchar(500)	Nullable

...

View: dicom_series

VIEW
Columns

Image Removed

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

View: dicom_study

VIEW
Columns

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

...

View: manufacturer

...

VIEW
Columns

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

...

View: manufacturer_model_software

VIEW
Columns

Name	Data type	Description / Attributes

Image Removed

...

VIEW
Columns

Name

Data type

Description / Attributes

Image Removed

bigint(19, 0)

Image Removed

MANUFACTURER

varchar(64)

Nullable

Image Removed


ID	bigint(19, 0)	-
MANUFACTURER	varchar(64)	Nullable

...

MODEL

varchar(64)

Nullable

Image Removed


SOFTWARE	varchar(64)	Nullable

...

View: number_month

...

VIEW
Columns

Image Removed

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

...

)	Nullable
NUMBER_MONTH	bigint(19, 0)	Nullable

...

View: saved_query_last_exec

VIEW
Columns

Image Removed

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

...

View: software_versions

...

VIEW
Columns

Image Removed

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

...

View: study_series_number

VIEW
Columns

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

Content

Space Tools

Page History

Versions Compared

Old Version 8

New Version Current

Key

Legend

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