Page History

Versions Compared

Key

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

Panel

Table of Contents

Legend

Icon	Description
Image Modified	Primary key
Image Modified	Primary key disabled
Image Modified	User-defined primary key
Image Modified	Unique key
Image Modified	Unique key disabled
Image Modified	User-defined unique key
Image Modified	Active trigger
Image ModifiedImage Modified	Disabled trigger Many to one relation
Image ModifiedImage Modified	User-defined many to one relation One to many relation
Image ModifiedImage Modified	User-defined one to many

...

relation One to one relation

Image Modified

...

	User-defined one to one relation
Image Modified	Input
Image Modified	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 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 AddedImage Removed	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_	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_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 AddedImage Removed	APPLICATIONAPPLICATION_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 Added

...

Name	Data type	Description / Attributes	Image RemovedImage 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
...
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 RemovedImage Added
OBJECT_ID
varchar(100)

Image RemovedImage RemovedImage Added
ATTRIBUTE
varchar(100)
Nullable
Image Removed
_
PROTECTION_ELEMENT_TYPE
varchar(100)
Nullable

Image RemovedImage RemovedImage Added
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
...
...

	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 RemovedImage Added	OBJECT_ID	varchar(100)
Image RemovedImage RemovedImage Added	ATTRIBUTE	varchar(100)	Nullable
Image Removed _	PROTECTION_ELEMENT_TYPE	varchar(100)	Nullable
Image RemovedImage RemovedImage Added	APPLICATION_ID	bigint(19, 0)
Image Removed _	UPDATE_DATE	date	Default: 1950-01-01
Image RemovedImage RemovedImage Added	ATTRIBUTE_VALUE	varchar(100)	Nullable

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

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 RemovedImage Added	PROTECTION_GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image RemovedImage AddedImage Removed	PROTECTIONPROTECTION_GROUP_NAME	varchar(100)
Image Removed _	PROTECTION_GROUP_DESCRIPTIO N	varchar(200)	Nullable
Image RemovedImage AddedImage Removed	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 AddedImage Removed	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 Added	ROLE_

...

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

...

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

USER

Image Removed

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

Columns

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

...

Data

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

...

Table: login_history

...

Columns

Key

...

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

...

Columns

Key

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

query_history_attribute

...

_pk_id

bigint

...

Image Removed

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

Key

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

...

Columns

Key

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

Image Removed

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

VIEW
Columns

Data

Image Removed

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

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

...

	bigint(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

	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

Content

Space Tools

Page History

Versions Compared

Old Version 3

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

Columns...KeyNameData typeDescription / AttributesImage RemovedImage RemovedImage Addedspecies_codevarchar(64)-Image Removed-species_descriptionvarchar(500)NullableUnique keysKeyColumnsName / DescriptionImage Modifiedspecies_codePRIMARY......

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

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