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
Image Modified	Uses dependency
Image Modified	User-defined uses dependency
Image Modified	Used by dependency
Image Modified	User-defined used by dependency

Tables

Columns for Table: collection_descriptions

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

Key	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 RemovedImage Added	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 RemovedImage Added	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_NAME

...

NAM_

...

Table: csm_mapping

...

Columns

Key

...

	Name	Data type	Description / Attributes
Image RemovedImage RemovedImage Added	MAPPING_ID	bigint(19, 0)	Identity _/ Auto increment
Image RemovedImage RemovedImage Added	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image RemovedImage 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 Added	Image Removed 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 AddedImage Removed	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 RemovedImage Added	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 RemovedImage Added	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 Added

...

Name	Data type	Description / Attributes	Image RemovedImage Removed	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 RemovedImage Added	ROLE_ID	bigint(19, 0)	References: csm_role
Image RemovedImage RemovedImage Added	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 RemovedImage Added
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

...

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

...

Data

Name	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 RemovedImage Added	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 RemovedImage Added	ID	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 AddedImage Removed	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 RemovedImage Added	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

...

Data

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

...

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

...

Columns

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

...

Name

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

Key	Name	Data type	Description / Attributes
Image Added

Columns

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

...

VIEW
Columns

Name	Data type	Description / Attributes
IMAGE_PK_ID	bigint(19, 0)
INSTANCE_NUMBER	bigint(19, 0)	Nullable

Image Removed

Name	Data type	Description / Attributes	IMAGE_PK_ID	bigint(19, 0)	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
II_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

Name	Data type	Description / Attributes

Name	Data type	Description / Attributes	Image Removed GENERAL_SERIES_PK_ID	bigint(19, 0)	Image Removed -
BODY_PART_EXAMINED	varchar(16)	Nullable Image Removed
FRAME_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
Image Removed MANUFACTURER	varchar(64)	Nullable

...

View: manufacturer_model_software

VIEW
Columns

...

Name	Data type	Description / Attributes

Image Removed

ID	bigint(19, 0)

Image Removed

-
MANUFACTURER	varchar(64)	Nullable

Image Removed

MODEL

varchar(64)

Nullable

Image Removed


SOFTWARE	varchar(64)	Nullable

...

View: number_month

...

...
VIEW
Columns
Image RemovedImage Removed
Name
Data type
Description / Attributes
PATIENT_ID
bigint(19, 0)
Nullable
NUMBER_MONTH
bigint(19, 0)
Nullable
...
19, 0)
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

Image Removed

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

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

Content

Space Tools

Page History

Versions Compared

Old Version 6

New Version Current

Key

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

...VIEWColumnsImage RemovedImage RemovedNameData typeDescription / AttributesPATIENT_IDbigint(19, 0)NullableNUMBER_MONTHbigint(19, 0)Nullable...19, 0)NullableNUMBER_MONTHbigint(19, 0)Nullable...

View: saved_query_last_exec

View: software_versions

View: study_series_number

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