Page History

Versions Compared

Key

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

Table of Contents

...

NBIA

...

Legend

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 Added Input
Image Added Output
Image Added Input/Output
Image Added Uses dependency
Image Added User-defined uses dependency Image Added Used by dependency
Image Added User-defined used by dependency
NBIA

Tables

Columns for Table: collection_descriptions

...

Name
Data type
Description / Attributes

Image Modified

Image Modified
collection_descriptions_pk_id
bigint(19, 0)

Image Modified

collection_name
varchar(64)
Nullable

Image Modified

user_name
varchar(20)
Nullable

Image Modified

description
mediumtext
Nullable

Image Modified

collection_descriptions_timest
date
Nullable

		Name	Data type	Description / Attributes
Image Modified	Image Modified	collection_descriptions_pk_id	bigint(19, 0)

Unique keys

...

Columns
Name / Description

Image Modified
collection_descriptions_pk_id
PRIMARY

Image Modified
collection_descriptions_pk_id
PK_COLLECTION_DESC_PK_ID
...

	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

		Name	Data type	Description / Attributes
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	APPLICATION_NAME	varchar(255)


Image Modified

APPLICATION_DESCRIPTION

varchar(200)


Image Modified

		DECLARATIVE_FLAG	tinyint(3, 0)	Default: 0
Image Modified

		ACTIVE_FLAG	tinyint(3, 0)	Default: 0
Image Modified

		UPDATE_DATE	date	Default: 1950-01-01
Image Modified

		DATABASE_URL	varchar(100)	Nullable
Image Modified

		DATABASE_USER_NAME	varchar(100)	Nullable
Image Modified

		DATABASE_PASSWORD	varchar(100)	Nullable
Image Modified

		DATABASE_DIALECT	varchar(100)	Nullable
Image Modified

		DATABASE_DRIVER	varchar(100)	Nullable
Image Modified

CSM_VERSION

varchar(20)

Nullable

Linked from

...

	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

...

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

Anchor
1.3. Table: csm_configuration_props
1.3. Table: csm_configuration_props
Anchor
_bookmark4
_bookmark4
Anchor
_bookmark4
_bookmark4
Table: csm_configuration_props

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	PROPERTY_KEY	varchar(300)


Image Modified

PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	PROPERTY_KEY	PRIMARY

Anchor
1.4. Table: csm_filter_clause
1.4. Table: csm_filter_clause
Anchor
_bookmark5
_bookmark5
Anchor
_bookmark5
_bookmark5
Table: csm_filter_clause

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	FILTER_CLAUSE_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

CLASS_NAME

varchar(100)


Image Modified

FILTER_CHAIN

varchar(2000)


Image Modified

TARGET_CLASS_NAME

varchar(100)


Image Modified

TARGET_CLASS_ATTRIBUTE_NAME

varchar(100)


Image Modified

TARGET_CLASS_ATTRIBUTE_TYPE

varchar(100)


Image Modified

		TARGET_CLASS_ALIAS	varchar(100)	Nullable
Image Modified

		TARGET_CLASS_ATTRIBUTE_ALIAS	varchar(100)	Nullable
Image Modified

GENERATED_SQL_USER

varchar(4000)


Image Modified

APPLICATION_ID

bigint(19, 0)


Image Modified

UPDATE_DATE

date


Image Modified

GENERATED_SQL_GROUP

varchar(4000)

Unique keys

...

	Columns	Name / Description
Image Modified	FILTER_CLAUSE_ID	PRIMARY

Anchor
1.5. Table: csm_group
1.5. Table: csm_group
Anchor
_bookmark6
_bookmark6
Anchor
_bookmark6
_bookmark6
Table: csm_group

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	GROUP_NAME	varchar(255)


Image Modified

		GROUP_DESC	varchar(200)	Nullable
Image Modified

		UPDATE_DATE	date	Default: 1950-01-01
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)	References: csm_application

Links to

...

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

Linked from

...

	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

...

	Columns	Name / Description
Image Modified	GROUP_ID	PRIMARY
Image Modified	APPLICATION_ID, GROUP_NAME	UQ_GROUP_GROUP_NAME

Anchor
1.6. Table: csm_mapping
1.6. Table: csm_mapping
Anchor
_bookmark7
_bookmark7
Anchor
_bookmark7
_bookmark7
Table: csm_mapping

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	MAPPING_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Modified	Image Modified	OBJECT_NAME	varchar(100)


Image Modified	Image Modified	ATTRIBUTE_NAME	varchar(100)


Image Modified

		OBJECT_PACKAGE_NAME	varchar(100)	Nullable
Image Modified

		TABLE_NAME	varchar(100)	Nullable
Image Modified

		TABLE_NAME_GROUP	varchar(100)	Nullable
Image Modified

		TABLE_NAME_USER	varchar(100)	Nullable
Image Modified

		VIEW_NAME_GROUP	varchar(100)	Nullable
Image Modified

		VIEW_NAME_USER	varchar(100)	Nullable
Image Modified

		ACTIVE_FLAG	tinyint(3, 0)	Default: 0
Image Modified

MAINTAINED_FLAG

tinyint(3, 0)

Default: 0

Links to

...

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

Unique keys

...

	Columns	Name / Description
Image Modified	MAPPING_ID	PRIMARY
Image Modified	OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID	UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

Anchor
1.7. Table: csm_password_history
1.7. Table: csm_password_history
Anchor
_bookmark8
_bookmark8
Anchor
_bookmark8
_bookmark8
Table: csm_password_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	CSM_PASSWORD_HISTORY_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

		LOGIN_NAME	varchar(500)	Nullable
Image Modified

PASSWORD

varchar(255)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	CSM_PASSWORD_HISTORY_ID	PRIMARY

Anchor
1.8. Table: csm_pg_pe
1.8. Table: csm_pg_pe
Anchor
_bookmark9
_bookmark9
Anchor
_bookmark9
_bookmark9
Table: csm_pg_pe

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	PG_PE_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
Image Modified	Image Modified	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Links to

...

	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

...

	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

Anchor
1.9. Table: csm_privilege
1.9. Table: csm_privilege
Anchor
_bookmark10
_bookmark10
Anchor
_bookmark10
_bookmark10
Table: csm_privilege

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	PRIVILEGE_NAME	varchar(100)


Image Modified

		PRIVILEGE_DESCRIPTION	varchar(200)	Nullable
Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Linked from

...

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

Unique keys

...

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

Anchor
1.10. Table: csm_protection_element
1.10. Table: csm_protection_element
Anchor
_bookmark11
_bookmark11
Anchor
_bookmark11
_bookmark11
Table: csm_protection_element

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

PROTECTION_ELEMENT_NAME

varchar(100)


Image Modified

		PROTECTION_ELEMENT_DESCRIPTI ON	varchar(200)	Nullable
Image Modified	Image Modified	OBJECT_ID	varchar(100)


Image Modified	Image Modified	ATTRIBUTE	varchar(100)	Nullable
Image Modified

		PROTECTION_ELEMENT_TYPE	varchar(100)	Nullable
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)


Image Modified

		UPDATE_DATE	date	Default: 1950-01-01
Image Modified	Image Modified	ATTRIBUTE_VALUE	varchar(100)	Nullable

Linked from

...

	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

...

	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

Anchor
1.11. Table: csm_protection_group
1.11. Table: csm_protection_group
Anchor
_bookmark12
_bookmark12
Anchor
_bookmark12
_bookmark12
Table: csm_protection_group

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	PROTECTION_GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	PROTECTION_GROUP_NAME	varchar(100)


Image Modified

		PROTECTION_GROUP_DESCRIPTIO N	varchar(200)	Nullable
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Modified

LARGE_ELEMENT_COUNT_FLAG

tinyint(3, 0)


Image Modified

		UPDATE_DATE	date	Default: 1950-01-01
Image Modified

PARENT_PROTECTION_GROUP_ID

bigint(19, 0)

Nullable
References: csm_protection_group

Links to

...

	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

...

	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

...

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

Anchor
1.12. Table: csm_role
1.12. Table: csm_role
Anchor
_bookmark13
_bookmark13
Anchor
_bookmark13
_bookmark13
Table: csm_role

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	ROLE_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	ROLE_NAME	varchar(100)


Image Modified

		ROLE_DESCRIPTION	varchar(200)	Nullable
Image Modified	Image Modified	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Modified

ACTIVE_FLAG

tinyint(3, 0)


Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Links to

...

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

Linked from

...

	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

...

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

Anchor
1.13. Table: csm_role_privilege
1.13. Table: csm_role_privilege
Anchor
_bookmark14
_bookmark14
Anchor
_bookmark14
_bookmark14
Table: csm_role_privilege

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	ROLE_PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	ROLE_ID	bigint(19, 0)	References: csm_role
Image Modified	Image Modified	PRIVILEGE_ID	bigint(19, 0)	References: csm_privilege
Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Links to

...

	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

...

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

Anchor
1.14. Table: csm_user
1.14. Table: csm_user
Anchor
_bookmark15
_bookmark15
Anchor
_bookmark15
_bookmark15
Table: csm_user

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	USER_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

		LOGIN_NAME	varchar(500)	Nullable
Image Modified

FIRST_NAME

varchar(100)


Image Modified

LAST_NAME

varchar(100)


Image Modified

		ORGANIZATION	varchar(500)	Nullable
Image Modified

		DEPARTMENT	varchar(100)	Nullable
Image Modified

		TITLE	varchar(100)	Nullable
Image Modified

		PHONE_NUMBER	varchar(100)	Nullable
Image Modified

		PASSWORD	varchar(100)	Nullable
Image Modified

		EMAIL_ID	varchar(100)	Nullable
Image Modified

		START_DATE	date	Nullable
Image Modified

		END_DATE	date	Nullable
Image Modified

		UPDATE_DATE	date	Default: 1950-01-01
Image Modified

		MIDDLE_NAME	varchar(100)	Nullable
Image Modified

		FAX	varchar(20)	Nullable
Image Modified

		ADDRESS	varchar(200)	Nullable
Image Modified

		CITY	varchar(100)	Nullable
Image Modified

		STATE	varchar(100)	Nullable
Image Modified

		COUNTRY	varchar(100)	Nullable
Image Modified

		POSTAL_CODE	varchar(10)	Nullable
Image Modified

		MIGRATED_FLAG	tinyint(3, 0)	Default: 0
Image Modified

		PREMGRT_LOGIN_NAME	varchar(100)	Nullable
Image Modified

		PASSWORD_EXPIRED	tinyint(3, 0)	Nullable Default: 0
Image Modified

FIRST_TIME_LOGIN

tinyint(3, 0)

Nullable Default: 0


	Name	Data type	Description / Attributes
Image Modified

		ACTIVE_FLAG	tinyint(3, 0)	Nullable Default: 1
Image Modified

PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10

Linked from

...

	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

...

	Columns	Name / Description
Image Modified	USER_ID	PRIMARY

Anchor
1.15. Table: csm_user_group
1.15. Table: csm_user_group
Anchor
_bookmark16
_bookmark16
Anchor
_bookmark16
_bookmark16
Table: csm_user_group

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	USER_GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

		USER_ID	bigint(19, 0)	References: csm_user
Image Modified

GROUP_ID

bigint(19, 0)

References: csm_group

Links to

...

	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

...

	Columns	Name / Description
Image Modified	USER_GROUP_ID	PRIMARY

Anchor
1.16. Table: csm_user_group_role_pg
1.16. Table: csm_user_group_role_pg
Anchor
_bookmark17
_bookmark17
Anchor
_bookmark17
_bookmark17
Table: csm_user_group_role_pg

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	USER_GROUP_ROLE_PG_ID	bigint(19, 0)	Identity / Auto increment


	Name	Data type	Description / Attributes
Image Modified

		USER_ID	bigint(19, 0)	Nullable References: csm_user
Image Modified

		GROUP_ID	bigint(19, 0)	Nullable References: csm_group
Image Modified

		ROLE_ID	bigint(19, 0)	References: csm_role
Image Modified

		PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Links to

...

	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

...

	Columns	Name / Description
Image Modified	USER_GROUP_ROLE_PG_ID	PRIMARY

Anchor
1.17. Table: csm_user_pe
1.17. Table: csm_user_pe
Anchor
_bookmark18
_bookmark18
Anchor
_bookmark18
_bookmark18
Table: csm_user_pe

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	USER_PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
Image Modified	Image Modified	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
Image Modified	Image Modified	USER_ID	bigint(19, 0)	References: csm_user
Image Modified

UPDATE_DATE

date

Default: 1950-01-01

Links to

...

	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

...

	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

Anchor
1.18. Table: ct_image
1.18. Table: ct_image
Anchor
_bookmark19
_bookmark19
Anchor
_bookmark19
_bookmark19
Table: ct_image

Columns

...

		Name	Data type	Description / Attributes
Image Modified

		kvp	decimal(22, 6)	Nullable
Image Modified

		scan_options	varchar(16)	Nullable
Image Modified

		data_collection_diameter	decimal(22, 6)	Nullable
Image Modified

		reconstruction_diameter	decimal(22, 6)	Nullable
Image Modified

		gantry_detector_tilt	decimal(22, 6)	Nullable
Image Modified

		exposure_time	decimal(22, 6)	Nullable
Image Modified

		x_ray_tube_current	decimal(22, 6)	Nullable
Image Modified

		exposure	decimal(22, 6)	Nullable
Image Modified

		exposure_in_microas	decimal(22, 6)	Nullable
Image Modified

		convolution_kernel	varchar(16)	Nullable
Image Modified

		revolution_time	decimal(22, 6)	Nullable
Image Modified

		single_collimation_width	decimal(22, 6)	Nullable
Image Modified

		total_collimation_width	decimal(22, 6)	Nullable
Image Modified

		table_speed	decimal(22, 6)	Nullable
Image Modified

		table_feed_per_rotation	decimal(22, 6)	Nullable
Image Modified

		ct_pitch_factor	decimal(22, 6)	Nullable
Image Modified

		anatomic_region_seq	varchar(500)	Nullable
Image Modified

		image_pk_id	bigint(19, 0)	References: general_image
Image Modified	Image Modified	ct_image_pk_id	bigint(19, 0)


Image Modified

general_series_pk_id

bigint(19, 0)

Nullable
References: general_series

Links to

...

	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

...

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

Anchor
1.19. Table: custom_series_list
1.19. Table: custom_series_list
Anchor
_bookmark20
_bookmark20
Anchor
_bookmark20
_bookmark20
Table: custom_series_list

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)


Image Modified

		NAME	varchar(200)	Nullable
Image Modified

		comment_	varchar(200)	Nullable
Image Modified

		HYPERLINK	varchar(200)	Nullable
Image Modified

		CUSTOM_SERIES_LIST_TIMESTAMP	date	Nullable
Image Modified

		USER_NAME	varchar(20)	Nullable
Image Modified

usage_count

unsigned int(10, 0)

Nullable Default: 0

Linked from

...

	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

...

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

Anchor
1.20. Table: custom_series_list_attrib
1.20. Table: custom_series_list_attrib
Anchor
_bookmark21
_bookmark21
Anchor
_bookmark21
_bookmark21
Table: custom_series_list_attribute

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	custom_series_list_attribute_p	bigint(19, 0)


Image Modified

		SERIES_INSTANCE_UID	varchar(200)	Nullable
Image Modified

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

...

	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

...

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

Anchor
1.21. Table: databasechangelog
1.21. Table: databasechangelog
Anchor
_bookmark22
_bookmark22
Anchor
_bookmark22
_bookmark22
Table: databasechangelog

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	ID	varchar(63)


Image Modified	Image Modified	AUTHOR	varchar(63)


Image Modified	Image Modified	FILENAME	varchar(200)


Image Modified

DATEEXECUTED

datetime


Image Modified

		MD5SUM	varchar(32)	Nullable
Image Modified

		DESCRIPTION	varchar(255)	Nullable
Image Modified

		COMMENTS	varchar(255)	Nullable
Image Modified

		TAG	varchar(255)	Nullable
Image Modified

LIQUIBASE

varchar(10)

Nullable

Unique keys

...

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

Anchor
1.22. Table: databasechangeloglock
1.22. Table: databasechangeloglock
Anchor
_bookmark23
_bookmark23
Anchor
_bookmark23
_bookmark23
Table: databasechangeloglock

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	ID	int(10, 0)


Image Modified

LOCKED

tinyint(3, 0)


Image Modified

		LOCKGRANTED	datetime	Nullable
Image Modified

LOCKEDBY

varchar(255)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	ID	PRIMARY

Anchor
1.23. Table: deletion_audit_trail
1.23. Table: deletion_audit_trail
Anchor
_bookmark24
_bookmark24
Anchor
_bookmark24
_bookmark24
Table: deletion_audit_trail

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	deletion_pk_id	bigint(19, 0)


Image Modified

		data_id	varchar(64)	Nullable
Image Modified

		data_type	varchar(50)	Nullable
Image Modified

		total_image	bigint(19, 0)	Nullable
Image Modified

		user_name	varchar(50)	Nullable
Image Modified

time_stamp

datetime

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	deletion_pk_id	PRIMARY

Anchor
1.24. Table: download_data_history
1.24. Table: download_data_history
Anchor
_bookmark25
_bookmark25
Anchor
_bookmark25
_bookmark25
Table: download_data_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	download_data_history_pk_id	bigint(19, 0)


Image Modified

		series_instance_uid	varchar(64)	Nullable
Image Modified

		login_name	varchar(100)	Nullable
Image Modified

		download_timestamp	date	Nullable
Image Modified

		download_type	varchar(20)	Nullable
Image Modified

size_

decimal(22, 2)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	download_data_history_pk_id	PRIMARY

Anchor
1.25. Table: download_history
1.25. Table: download_history
Anchor
_bookmark26
_bookmark26
Anchor
_bookmark26
_bookmark26
Table: download_history

...

...

Columns

Name
Data type
Description / Attributes

Image Modified

Image Modified
download_history_pk_id
bigint(19, 0)

Image Modified

user_id
bigint(19, 0)
Nullable

Image Modified

timestamp
datetime
Nullable

Image Modified

total_file_size
decimal(22, 2)
Nullable

Image Modified

download_file_name
varchar(300)
Nullable
Unique keys
...

Columns
Name / Description

Image Modified
download_history_pk_id
PRIMARY

Anchor
1.26. Table: general_equipment
1.26. Table: general_equipment
Anchor
_bookmark27
_bookmark27
Anchor
_bookmark27
_bookmark27
Table: general_equipment

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	general_equipment_pk_id	bigint(19, 0)


Image Modified

		manufacturer	varchar(64)	Nullable
Image Modified

		institution_name	varchar(64)	Nullable
Image Modified

		manufacturer_model_name	varchar(64)	Nullable
Image Modified

		software_versions	varchar(64)	Nullable
Image Modified

		institution_address	varchar(1024)	Nullable
Image Modified

		station_name	varchar(16)	Nullable
Image Modified

device_serial_number

varchar(64)

Nullable

Linked from

...

	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

...

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

Anchor
1.27. Table: general_image
1.27. Table: general_image
Anchor
_bookmark28
_bookmark28
Anchor
_bookmark28
_bookmark28
Table: general_image

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	image_pk_id	bigint(19, 0)


Image Modified

		instance_number	bigint(19, 0)	Nullable
Image Modified

		content_date	date	Nullable
Image Modified

		content_time	varchar(16)	Nullable
Image Modified

		image_type	varchar(16)	Nullable
Image Modified

		acquisition_date	date	Nullable
Image Modified

		acquisition_time	varchar(16)	Nullable
Image Modified

		acquisition_number	decimal(22, 6)	Nullable
Image Modified

		lossy_image_compression	varchar(16)	Nullable
Image Modified

		pixel_spacing	decimal(22, 6)	Nullable
Image Modified

		image_orientation_patient	varchar(200)	Nullable
Image Modified

		image_position_patient	varchar(200)	Nullable
Image Modified

		slice_thickness	decimal(22, 6)	Nullable
Image Modified

		slice_location	decimal(22, 6)	Nullable
Image Modified

		i_rows	decimal(22, 6)	Nullable
Image Modified

		i_columns	decimal(22, 6)	Nullable
Image Modified

		contrast_bolus_agent	varchar(64)	Nullable
Image Modified

		contrast_bolus_route	varchar(64)	Nullable
Image Modified

		sop_class_uid	varchar(64)	Nullable
Image Modified	Image Modified	sop_instance_uid	varchar(64)	Nullable
Image Modified

		general_series_pk_id	bigint(19, 0)	Nullable References: general_series
Image Modified

		patient_position	varchar(16)	Nullable
Image Modified

		source_to_detector_distance	decimal(22, 6)	Nullable
Image Modified

		source_subject_distance	decimal(22, 6)	Nullable
Image Modified

focal_spot_size

decimal(22, 6)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		storage_media_file_set_uid	varchar(64)	Nullable
Image Modified

		dicom_file_uri	varchar(2000)	Nullable
Image Modified

		acquisition_datetime	varchar(50)	Nullable
Image Modified

		image_comments	varchar(4000)	Nullable
Image Modified

		image_receiving_timestamp	datetime	Nullable
Image Modified

		curation_timestamp	datetime	Nullable
Image Modified

		annotation	varchar(20)	Nullable
Image Modified	Image Modified	submission_date	date	Nullable
Image Modified

		dicom_size	decimal(22, 6)	Nullable
Image Modified

		image_laterality	varchar(16)	Nullable
Image Modified

		trial_dp_pk_id	bigint(19, 0)	Nullable
Image Modified

		patient_id	varchar(64)	Nullable
Image Modified

		study_instance_uid	varchar(500)	Nullable
Image Modified

		series_instance_uid	varchar(64)	Nullable
Image Modified

		patient_pk_id	bigint(19, 0)	Nullable References: patient
Image Modified

		study_pk_id	bigint(19, 0)	Nullable References: study
Image Modified

		project	varchar(200)	Nullable
Image Modified

		acquisition_matrix	decimal(22, 6)	Nullable Default: 0.000000
Image Modified

		dx_data_collection_diameter	decimal(22, 6)	Nullable Default: 0.000000
Image Modified

		md5_digest	varchar(50)	Nullable
Image Modified

		US_FRAME_NUMBER	varchar(50)	Nullable
Image Modified

		US_COLOR_DATA_PRESENT	varchar(50)	Nullable
Image Modified

US_MULTI_MODALITY

varchar(50)

Nullable

Links to

...

	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

...

	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

...

	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

Anchor
1.28. Table: general_series
1.28. Table: general_series
Anchor
_bookmark29
_bookmark29
Anchor
_bookmark29
_bookmark29
Table: general_series

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	general_series_pk_id	bigint(19, 0)


Image Modified

modality

varchar(16)


Image Modified	Image Modified	series_instance_uid	varchar(64)	Nullable
Image Modified

		series_laterality	varchar(16)	Nullable
Image Modified

		series_date	date	Nullable
Image Modified

		protocol_name	varchar(64)	Nullable
Image Modified

		series_desc	varchar(64)	Nullable
Image Modified

		body_part_examined	varchar(16)	Nullable
Image Modified

		study_pk_id	bigint(19, 0)	Nullable References: study
Image Modified

		general_equipment_pk_id	bigint(19, 0)	Nullable References: general_equipment
Image Modified

		trial_protocol_id	varchar(64)	Nullable
Image Modified

		trial_protocol_name	varchar(64)	Nullable
Image Modified

		trial_site_name	varchar(64)	Nullable
Image Modified

		study_date	date	Nullable
Image Modified

		study_desc	varchar(64)	Nullable
Image Modified

		admitting_diagnoses_desc	varchar(64)	Nullable
Image Modified

		patient_age	varchar(4)	Nullable
Image Modified

		patient_sex	varchar(16)	Nullable
Image Modified

		patient_weight	decimal(22, 6)	Nullable
Image Modified

		age_group	varchar(10)	Nullable
Image Modified

		patient_pk_id	bigint(19, 0)	Nullable
Image Modified

		series_number	decimal(22, 6)	Nullable
Image Modified

		sync_frame_of_ref_uid	varchar(64)	Nullable
Image Modified

		patient_id	varchar(64)	Nullable
Image Modified

		frame_of_reference_uid	varchar(64)	Nullable
Image Modified

		visibility	varchar(5)	Nullable
Image Modified

		security_group	varchar(50)	Nullable
Image Modified

annotations_flag

varchar(5)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		project	varchar(200)	Nullable
Image Modified

		site	varchar(40)	Nullable
Image Modified

		study_instance_uid	varchar(500)	Nullable
Image Modified

		max_submission_timestamp	datetime	Nullable
Image Modified

		batchNum	int(10, 0)	Nullable
Image Modified

		submission_type	varchar(100)	Nullable
Image Modified

		released_status	varchar(50)	Nullable
Image Modified

		third_party_analysis	varchar(4)	Nullable
Image Modified

description_uri

varchar(500)

Nullable

Links to

...

	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

...

	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

...

	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

Anchor
1.29. Table: gui_action_history
1.29. Table: gui_action_history
Anchor
_bookmark30
_bookmark30
Anchor
_bookmark30
_bookmark30
Table: gui_action_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	GUI_ACTION_HISTORY_PK_ID	bigint(19, 0)	Default: 0
Image Modified

		ACTION_TIMESTAMP	date	Nullable
Image Modified

ACTION

varchar(255)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	GUI_ACTION_HISTORY_PK_ID	PRIMARY

Anchor
1.30. Table: hibernate_unique_key
1.30. Table: hibernate_unique_key
Anchor
_bookmark31
_bookmark31
Anchor
_bookmark31
_bookmark31
Table: hibernate_unique_key

Columns

...

		Name	Data type	Description / Attributes
Image Modified

next_hi

bigint(19, 0)

Anchor
1.31. Table: login_history
1.31. Table: login_history
Anchor
_bookmark32
_bookmark32
Anchor
_bookmark32
_bookmark32
Table: login_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	login_history_pk_id	bigint(19, 0)


Image Modified

		login_timestamp	datetime	Nullable
Image Modified

ip_address

varchar(15)

Nullable

Unique keys

...

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

Anchor
1.32. Table: modality_descriptions
1.32. Table: modality_descriptions
Anchor
_bookmark33
_bookmark33
Anchor
_bookmark33
_bookmark33
Table: modality_descriptions

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	modality_descriptions_pk_id	bigint(19, 0)


Image Modified

		modality_name	varchar(20)	Nullable
Image Modified

description

mediumtext

Nullable

Unique keys

...

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

Anchor
1.33. Table: mr_image
1.33. Table: mr_image
Anchor
_bookmark34
_bookmark34
Anchor
_bookmark34
_bookmark34
Table: mr_image

Columns

...

		Name	Data type	Description / Attributes
Image Modified

IMAGE_TYPE_VALUE_3

varchar(16)


Image Modified

SCANNING_SEQUENCE

varchar(126)


Image Modified

SEQUENCE_VARIANT

varchar(126)


Image Modified

		REPETITION_TIME	decimal(22, 10)	Nullable
Image Modified

		ECHO_TIME	decimal(22, 10)	Nullable
Image Modified

		INVERSION_TIME	decimal(22, 10)	Nullable
Image Modified

SEQUENCE_NAME

varchar(64)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		IMAGED_NUCLEUS	varchar(64)	Nullable
Image Modified

		MAGNETIC_FIELD_STRENGTH	decimal(22, 10)	Nullable
Image Modified

		SAR	decimal(22, 10)	Nullable
Image Modified

		DB_DT	decimal(22, 10)	Nullable
Image Modified

		TRIGGER_TIME	decimal(22, 10)	Nullable
Image Modified

		ANGIO_FLAG	varchar(1)	Nullable
Image Modified

		IMAGE_PK_ID	bigint(19, 0)	References: general_image
Image Modified	Image Modified	MR_IMAGE_PK_ID	bigint(19, 0)	Identity / Auto increment
Image Modified

GENERAL_SERIES_PK_ID

bigint(19, 0)

Nullable
References: general_series

Links to

...

	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

...

	Columns	Name / Description
Image Modified	MR_IMAGE_PK_ID	PRIMARY

Anchor
1.34. Table: patient
1.34. Table: patient
Anchor
_bookmark35
_bookmark35
Anchor
_bookmark35
_bookmark35
Table: patient

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	patient_pk_id	bigint(19, 0)


Image Modified

		patient_id	varchar(64)	Nullable
Image Modified

		patient_name	varchar(250)	Nullable
Image Modified

		patient_birth_date	date	Nullable
Image Modified

		patient_sex	varchar(16)	Nullable
Image Modified

		ethnic_group	varchar(16)	Nullable
Image Modified

		trial_dp_pk_id	bigint(19, 0)	Nullable References: trial_data_provenance
Image Modified

		trial_subject_id	varchar(64)	Nullable
Image Modified

		trial_subject_reading_id	varchar(255)	Nullable
Image Modified

		trial_site_pk_id	bigint(19, 0)	Nullable
Image Modified

		species_code	varchar(100)	Nullable
Image Modified

		species_description	varchar(100)	Nullable
Image Modified

qc_subject

varchar(4)

Nullable

Links to

...

	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

...

	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

...

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

Anchor
1.35. Table: qc_status_history
1.35. Table: qc_status_history
Anchor
_bookmark36
_bookmark36
Anchor
_bookmark36
_bookmark36
Table: qc_status_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	qc_status_history_pk_id	bigint(19, 0)


Image Modified

series_instance_uid

varchar(64)


Image Modified

		user_id	varchar(100)	Nullable
Image Modified

		comment_	varchar(4000)	Nullable
Image Modified

		history_timestamp	datetime	Nullable
Image Modified

		new_value	varchar(100)	Nullable
Image Modified

		old_value	varchar(100)	Nullable
Image Modified

		oldBatch	varchar(20)	Nullable
Image Modified

		newBatch	varchar(20)	Nullable
Image Modified

		oldSubmissionType	varchar(100)	Nullable
Image Modified

		newSubmissionType	varchar(100)	Nullable
Image Modified

		oldReleasedStatus	varchar(50)	Nullable
Image Modified

newReleasedStatus

varchar(50)

Nullable

Unique keys

...

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

Anchor
1.36. Table: query_history
1.36. Table: query_history
Anchor
_bookmark37
_bookmark37
Anchor
_bookmark37
_bookmark37
Table: query_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	query_history_pk_id	bigint(19, 0)


Image Modified

		user_id	bigint(19, 0)	Nullable References: csm_user
Image Modified

		query_execute_timestamp	datetime	Nullable
Image Modified

		query_elapsed_time	bigint(19, 0)	Nullable
Image Modified

		saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
Image Modified

tool

varchar(100)

Nullable

Links to

...

	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

...

	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

...

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

Anchor
1.37. Table: query_history_attribute
1.37. Table: query_history_attribute
Anchor
_bookmark38
_bookmark38
Anchor
_bookmark38
_bookmark38
Table: query_history_attribute

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	query_history_attribute_pk_id	bigint(19, 0)


Image Modified

		attribute_name	varchar(300)	Nullable
Image Modified

		subattribute_name	varchar(300)	Nullable
Image Modified

		attribute_value	varchar(300)	Nullable
Image Modified

		query_history_pk_id	bigint(19, 0)	Nullable References: query_history
Image Modified

instance_number

bigint(19, 0)

Nullable

Links to

...

	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

...

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

Anchor
1.38. Table: saved_query
1.38. Table: saved_query
Anchor
_bookmark39
_bookmark39
Anchor
_bookmark39
_bookmark39
Table: saved_query

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	saved_query_pk_id	bigint(19, 0)


Image Modified

		user_id	bigint(19, 0)	Nullable References: csm_user
Image Modified

		query_name	varchar(200)	Nullable
Image Modified

		new_data_flag	varchar(5)	Nullable
Image Modified

		active	varchar(5)	Nullable
Image Modified

query_execute_timestamp

datetime

Nullable

Links to

...

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

Linked from

...

	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

...

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

Anchor
1.39. Table: saved_query_attribute
1.39. Table: saved_query_attribute
Anchor
_bookmark40
_bookmark40
Anchor
_bookmark40
_bookmark40
Table: saved_query_attribute

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	saved_query_attribute_pk_id	bigint(19, 0)


Image Modified

		attribute_name	varchar(300)	Nullable
Image Modified

		subattribute_name	varchar(300)	Nullable
Image Modified

		attribute_value	varchar(300)	Nullable
Image Modified

saved_query_pk_id

bigint(19, 0)

Nullable
References: saved_query


	Name	Data type	Description / Attributes
Image Modified

instance_number

bigint(19, 0)

Nullable

Links to

...

	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

...

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

Anchor
1.40. Table: site
1.40. Table: site
Anchor
_bookmark41
_bookmark41
Anchor
_bookmark41
_bookmark41
Table: site

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	site_pk_id	bigint(19, 0)


Image Modified

		dp_site_name	varchar(40)	Nullable
Image Modified

		dp_site_id	varchar(64)	Nullable
Image Modified

trial_dp_pk_id

bigint(19, 0)

References: trial_data_provenance

Links to

...

	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

...

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

Anchor
1.41. Table: species
1.41. Table: species
Anchor
_bookmark42
_bookmark42
Anchor
_bookmark42
_bookmark42
Table: species

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	species_code	varchar(64)


Image Modified

species_description

varchar(500)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	species_code	PRIMARY

Anchor
1.42. Table: study
1.42. Table: study
Anchor
_bookmark43
_bookmark43
Anchor
_bookmark43
_bookmark43
Table: study

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	study_pk_id	bigint(19, 0)


Image Modified	Image Modified	study_instance_uid	varchar(500)	Nullable
Image Modified

study_date

date


Image Modified

		study_time	varchar(16)	Nullable
Image Modified

		study_desc	varchar(64)	Nullable
Image Modified

		admitting_diagnoses_desc	varchar(64)	Nullable
Image Modified

		admitting_diagnoses_code_seq	varchar(500)	Nullable
Image Modified

		patient_pk_id	bigint(19, 0)	Nullable References: patient
Image Modified

		study_id	varchar(16)	Nullable
Image Modified

		trial_time_point_id	varchar(64)	Nullable
Image Modified

		trial_time_point_desc	varchar(1024)	Nullable
Image Modified

		patient_age	varchar(4)	Nullable
Image Modified

		age_group	varchar(10)	Nullable
Image Modified

		patient_size	decimal(22, 6)	Nullable
Image Modified

		patient_weight	decimal(22, 6)	Nullable
Image Modified

		occupation	varchar(16)	Nullable
Image Modified

additional_patient_history

varchar(4000)

Nullable

Links to

...

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

Linked from

...

	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

...

	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

Anchor
1.43. Table: submission_history
1.43. Table: submission_history
Anchor
_bookmark44
_bookmark44
Anchor
_bookmark44
_bookmark44
Table: submission_history

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	submission_history_pk_id	bigint(19, 0)	Identity / Auto increment
Image Modified

		patient_id	varchar(64)	Nullable
Image Modified

		study_instance_uid	varchar(500)	Nullable
Image Modified

		series_instance_uid	varchar(64)	Nullable
Image Modified

		sop_instance_uid	varchar(64)	Nullable
Image Modified

		submission_timestamp	datetime	Nullable
Image Modified

		project	varchar(200)	Nullable
Image Modified

		site	varchar(40)	Nullable
Image Modified

operation_type

smallint(5, 0)

Unique keys

...

	Columns	Name / Description
Image Modified	submission_history_pk_id	submission_history_pk_id

Anchor
1.44. Table: trial_data_provenance
1.44. Table: trial_data_provenance
Anchor
_bookmark45
_bookmark45
Anchor
_bookmark45
_bookmark45
Table: trial_data_provenance

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	trial_dp_pk_id	bigint(19, 0)


Image Modified

		dp_site_name	varchar(40)	Nullable
Image Modified

		dp_site_id	varchar(64)	Nullable
Image Modified

project

varchar(50)

Nullable

Linked from

...

	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

...

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

Anchor
1.45. Table: trial_site
1.45. Table: trial_site
Anchor
_bookmark46
_bookmark46
Anchor
_bookmark46
_bookmark46
Table: trial_site

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	trial_site_pk_id	bigint(19, 0)


Image Modified

trial_site_id

varchar(64)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		trial_site_name	varchar(64)	Nullable
Image Modified

trial_pk_id

bigint(19, 0)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	trial_site_pk_id	PRIMARY
Image Modified	trial_site_pk_id	PK_TRIAL_SITE_PK_ID

Anchor
1.46. Table: workflow
1.46. Table: workflow
Anchor
_bookmark47
_bookmark47
Anchor
_bookmark47
_bookmark47
Table: workflow

Columns

...

		Name	Data type	Description / Attributes
Image Modified	Image Modified	WORKFLOW_ID	bigint(19, 0)


Image Modified

		NAME	varchar(50)	Nullable
Image Modified

		COLLECTION	varchar(200)	Nullable
Image Modified

		SITE	varchar(200)	Nullable
Image Modified

		URL	varchar(255)	Nullable
Image Modified

WORKFLOW_TYPE

varchar(50)

Nullable

Unique keys

...

	Columns	Name / Description
Image Modified	WORKFLOW_ID	PRIMARY

Anchor
2. Views
2. Views
Anchor
_bookmark48
_bookmark48
Anchor
_bookmark48
_bookmark48
Views

Anchor
2.1. View: dicom_image
2.1. View: dicom_image
Anchor
_bookmark49
_bookmark49
Anchor
_bookmark49
_bookmark49
View: dicom_image

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

IMAGE_PK_ID

bigint(19, 0)


Image Modified

		INSTANCE_NUMBER	bigint(19, 0)	Nullable
Image Modified

		CONTENT_DATE	date	Nullable
Image Modified

		CONTENT_TIME	varchar(16)	Nullable
Image Modified

		IMAGE_TYPE	varchar(16)	Nullable
Image Modified

		ACQUISITION_DATE	date	Nullable
Image Modified

		ACQUISITION_TIME	varchar(16)	Nullable
Image Modified

		ACQUISITION_NUMBER	decimal(22, 6)	Nullable
Image Modified

		LOSSY_IMAGE_COMPRESSION	varchar(16)	Nullable
Image Modified

		PIXEL_SPACING	decimal(22, 6)	Nullable
Image Modified

		IMAGE_ORIENTATION_PATIENT	varchar(200)	Nullable
Image Modified

IMAGE_POSITION_PATIENT

varchar(200)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		SLICE_THICKNESS	decimal(22, 6)	Nullable
Image Modified

		SLICE_LOCATION	decimal(22, 6)	Nullable
Image Modified

		I_ROWS	decimal(22, 6)	Nullable
Image Modified

		I_COLUMNS	decimal(22, 6)	Nullable
Image Modified

		CONTRAST_BOLUS_AGENT	varchar(64)	Nullable
Image Modified

		CONTRAST_BOLUS_ROUTE	varchar(64)	Nullable
Image Modified

		SOP_CLASS_UID	varchar(64)	Nullable
Image Modified

		SOP_INSTANCE_UID	varchar(64)	Nullable
Image Modified

		GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable
Image Modified

		PATIENT_POSITION	varchar(16)	Nullable
Image Modified

		SOURCE_TO_DETECTOR_DISTANCE	decimal(22, 6)	Nullable
Image Modified

		SOURCE_SUBJECT_DISTANCE	decimal(22, 6)	Nullable
Image Modified

		FOCAL_SPOT_SIZE	decimal(22, 6)	Nullable
Image Modified

		STORAGE_MEDIA_FILE_SET_UID	varchar(64)	Nullable
Image Modified

		DICOM_FILE_URI	varchar(2000)	Nullable
Image Modified

		ACQUISITION_DATETIME	varchar(50)	Nullable
Image Modified

		IMAGE_COMMENTS	varchar(4000)	Nullable
Image Modified

		IMAGE_RECEIVING_TIMESTAMP	datetime	Nullable
Image Modified

		CURATION_TIMESTAMP	datetime	Nullable
Image Modified

		ANNOTATION	varchar(20)	Nullable
Image Modified

		SUBMISSION_DATE	date	Nullable
Image Modified

		DICOM_SIZE	decimal(22, 6)	Nullable
Image Modified

		IMAGE_LATERALITY	varchar(16)	Nullable
Image Modified

		TRIAL_DP_PK_ID	bigint(19, 0)	Nullable
Image Modified

		PATIENT_ID	varchar(64)	Nullable
Image Modified

		STUDY_INSTANCE_UID	varchar(500)	Nullable
Image Modified

		SERIES_INSTANCE_UID	varchar(64)	Nullable
Image Modified

		PATIENT_PK_ID	bigint(19, 0)	Nullable
Image Modified

		STUDY_PK_ID	bigint(19, 0)	Nullable
Image Modified

		PROJECT	varchar(200)	Nullable
Image Modified

		ACQUISITION_MATRIX	decimal(22, 6)	Nullable Default: 0.000000
Image Modified

		DX_DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Default: 0.000000
Image Modified

		KVP	decimal(22, 6)	Nullable
Image Modified

		SCAN_OPTIONS	varchar(16)	Nullable
Image Modified

		DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable
Image Modified

		RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable
Image Modified

GANTRY_DETECTOR_TILT

decimal(22, 6)

Nullable


	Name	Data type	Description / Attributes
Image Modified

		EXPOSURE_TIME	decimal(22, 6)	Nullable
Image Modified

		X_RAY_TUBE_CURRENT	decimal(22, 6)	Nullable
Image Modified

		EXPOSURE	decimal(22, 6)	Nullable
Image Modified

		EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable
Image Modified

		CONVOLUTION_KERNEL	varchar(16)	Nullable
Image Modified

		REVOLUTION_TIME	decimal(22, 6)	Nullable
Image Modified

		SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
Image Modified

		TOTAL_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
Image Modified

		TABLE_SPEED	decimal(22, 6)	Nullable
Image Modified

		TABLE_FEED_PER_ROTATION	decimal(22, 6)	Nullable
Image Modified

		CT_PITCH_FACTOR	decimal(22, 6)	Nullable
Image Modified

ANATOMIC_REGION_SEQ

varchar(500)

Nullable

Anchor
2.2. View: dicom_series
2.2. View: dicom_series
Anchor
_bookmark50
_bookmark50
Anchor
_bookmark50
_bookmark50
View: dicom_series

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

GENERAL_SERIES_PK_ID

bigint(19, 0)


Image Modified

		BODY_PART_EXAMINED	varchar(16)	Nullable
Image Modified

		FRAME_OF_REFERENCE_UID	varchar(64)	Nullable
Image Modified

		SERIES_LATERALITY	varchar(16)	Nullable
Image Modified

MODALITY

varchar(16)


Image Modified

		PROTOCOL_NAME	varchar(64)	Nullable
Image Modified

		SERIES_DATE	date	Nullable
Image Modified

		SERIES_DESC	varchar(64)	Nullable
Image Modified

		SERIES_INSTANCE_UID	varchar(64)	Nullable
Image Modified

		SERIES_NUMBER	decimal(22, 6)	Nullable
Image Modified

		SYNC_FRAME_OF_REF_UID	varchar(64)	Nullable
Image Modified

		STUDY_PK_ID	bigint(19, 0)	Nullable
Image Modified

GENERAL_EQUIPMENT_PK_ID

bigint(19, 0)

Nullable

Anchor
2.3. View: dicom_study
2.3. View: dicom_study
Anchor
_bookmark51
_bookmark51
Anchor
_bookmark51
_bookmark51
View: dicom_study

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

STUDY_PK_ID

bigint(19, 0)


Image Modified

		STUDY_INSTANCE_UID	varchar(500)	Nullable
Image Modified

		ADDITIONAL_PATIENT_HISTORY	varchar(4000)	Nullable
Image Modified

STUDY_DATE

date


	Name	Data type	Description / Attributes
Image Modified

		STUDY_DESC	varchar(64)	Nullable
Image Modified

		ADMITTING_DIAGNOSES_DESC	varchar(64)	Nullable
Image Modified

		ADMITTING_DIAGNOSES_CODE_S EQ	varchar(500)	Nullable
Image Modified

		OCCUPATION	varchar(16)	Nullable
Image Modified

		PATIENT_AGE	varchar(4)	Nullable
Image Modified

		PATIENT_SIZE	decimal(22, 6)	Nullable
Image Modified

		PATIENT_WEIGHT	decimal(22, 6)	Nullable
Image Modified

		STUDY_ID	varchar(16)	Nullable
Image Modified

		STUDY_TIME	varchar(16)	Nullable
Image Modified

		TRIAL_TIME_POINT_ID	varchar(64)	Nullable
Image Modified

		TRIAL_TIME_POINT_DESC	varchar(1024)	Nullable
Image Modified

PATIENT_PK_ID

bigint(19, 0)

Nullable

Anchor
2.4. View: manufacturer
2.4. View: manufacturer
Anchor
_bookmark52
_bookmark52
Anchor
_bookmark52
_bookmark52
View: manufacturer

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

MANUFACTURER

varchar(64)

Nullable

Anchor
2.5. View: manufacturer_model_software
2.5. View: manufacturer_model_software
Anchor
_bookmark53
_bookmark53
Anchor
_bookmark53
_bookmark53
View: manufacturer_model_software

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

bigint(19, 0)


Image Modified

		MANUFACTURER	varchar(64)	Nullable
Image Modified

		MODEL	varchar(64)	Nullable
Image Modified

SOFTWARE

varchar(64)

Nullable

Anchor
2.6. View: number_month
2.6. View: number_month
Anchor
_bookmark54
_bookmark54
Anchor
_bookmark54
_bookmark54
View: number_month

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

		PATIENT_ID	bigint(19, 0)	Nullable
Image Modified

NUMBER_MONTH

bigint(19, 0)

Nullable

Anchor
2.7. View: saved_query_last_exec
2.7. View: saved_query_last_exec
Anchor
_bookmark55
_bookmark55
Anchor
_bookmark55
_bookmark55
View: saved_query_last_exec

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

		SAVED_QUERY_PK_ID	bigint(19, 0)	Nullable
Image Modified

LAST_EXECUTE_DATE

datetime

Nullable

Anchor
2.8. View: software_versions
2.8. View: software_versions
Anchor
_bookmark56
_bookmark56
Anchor
_bookmark56
_bookmark56
View: software_versions

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

SOFTWARE_VERSIONS

varchar(64)

Nullable

Anchor
2.9. View: study_series_number
2.9. View: study_series_number
Anchor
_bookmark57
_bookmark57
Anchor
_bookmark57
_bookmark57
View: study_series_number

VIEW
Columns

...

		Name	Data type	Description / Attributes
Image Modified

		PATIENT_PK_ID	bigint(19, 0)	Nullable
Image Modified

		PATIENT_ID	varchar(64)	Nullable
Image Modified

		PROJECT	varchar(50)	Nullable
Image Modified

		STUDY_NUMBER	bigint(19, 0)	Default: 0
Image Modified

SERIES_NUMBER

bigint(19, 0)

Default: 0

Content

Space Tools

Page History

Versions Compared

Old Version 2

New Version 3

Key

NBIA

Legend

Tables

Columns for Table: collection_descriptions

Unique keys

ColumnsName / DescriptionImage Modifiedcollection_descriptions_pk_idPRIMARYImage Modifiedcollection_descriptions_pk_idPK_COLLECTION_DESC_PK_ID...

Columns for Table: csm_

application

Anchor1.3. Table: csm_configuration_props1.3. Table: csm_configuration_props Anchor_bookmark4_bookmark4 Anchor_bookmark4_bookmark4Table: csm_configuration_props

Anchor1.4. Table: csm_filter_clause1.4. Table: csm_filter_clause Anchor_bookmark5_bookmark5 Anchor_bookmark5_bookmark5Table: csm_filter_clause

Anchor1.5. Table: csm_group1.5. Table: csm_group Anchor_bookmark6_bookmark6 Anchor_bookmark6_bookmark6Table: csm_group

Anchor1.6. Table: csm_mapping1.6. Table: csm_mapping Anchor_bookmark7_bookmark7 Anchor_bookmark7_bookmark7Table: csm_mapping

Anchor1.7. Table: csm_password_history1.7. Table: csm_password_history Anchor_bookmark8_bookmark8 Anchor_bookmark8_bookmark8Table: csm_password_history

Anchor1.8. Table: csm_pg_pe1.8. Table: csm_pg_pe Anchor_bookmark9_bookmark9 Anchor_bookmark9_bookmark9Table: csm_pg_pe

Anchor1.9. Table: csm_privilege1.9. Table: csm_privilege Anchor_bookmark10_bookmark10 Anchor_bookmark10_bookmark10Table: csm_privilege

Anchor1.10. Table: csm_protection_element1.10. Table: csm_protection_element Anchor_bookmark11_bookmark11 Anchor_bookmark11_bookmark11Table: csm_protection_element

Anchor1.11. Table: csm_protection_group1.11. Table: csm_protection_group Anchor_bookmark12_bookmark12 Anchor_bookmark12_bookmark12Table: csm_protection_group

Anchor1.12. Table: csm_role1.12. Table: csm_role Anchor_bookmark13_bookmark13 Anchor_bookmark13_bookmark13Table: csm_role

Anchor1.13. Table: csm_role_privilege1.13. Table: csm_role_privilege Anchor_bookmark14_bookmark14 Anchor_bookmark14_bookmark14Table: csm_role_privilege

Anchor1.14. Table: csm_user1.14. Table: csm_user Anchor_bookmark15_bookmark15 Anchor_bookmark15_bookmark15Table: csm_user

Anchor1.15. Table: csm_user_group1.15. Table: csm_user_group Anchor_bookmark16_bookmark16 Anchor_bookmark16_bookmark16Table: csm_user_group

Anchor1.16. Table: csm_user_group_role_pg1.16. Table: csm_user_group_role_pg Anchor_bookmark17_bookmark17 Anchor_bookmark17_bookmark17Table: csm_user_group_role_pg

Anchor1.17. Table: csm_user_pe1.17. Table: csm_user_pe Anchor_bookmark18_bookmark18 Anchor_bookmark18_bookmark18Table: csm_user_pe

Anchor1.18. Table: ct_image1.18. Table: ct_image Anchor_bookmark19_bookmark19 Anchor_bookmark19_bookmark19Table: ct_image

Anchor1.19. Table: custom_series_list1.19. Table: custom_series_list Anchor_bookmark20_bookmark20 Anchor_bookmark20_bookmark20Table: custom_series_list

Anchor1.20. Table: custom_series_list_attrib1.20. Table: custom_series_list_attrib Anchor_bookmark21_bookmark21 Anchor_bookmark21_bookmark21Table: custom_series_list_attribute

Anchor1.21. Table: databasechangelog1.21. Table: databasechangelog Anchor_bookmark22_bookmark22 Anchor_bookmark22_bookmark22Table: databasechangelog

Anchor1.22. Table: databasechangeloglock1.22. Table: databasechangeloglock Anchor_bookmark23_bookmark23 Anchor_bookmark23_bookmark23Table: databasechangeloglock

Anchor1.23. Table: deletion_audit_trail1.23. Table: deletion_audit_trail Anchor_bookmark24_bookmark24 Anchor_bookmark24_bookmark24Table: deletion_audit_trail

Anchor1.24. Table: download_data_history1.24. Table: download_data_history Anchor_bookmark25_bookmark25 Anchor_bookmark25_bookmark25Table: download_data_history

Anchor1.25. Table: download_history1.25. Table: download_history Anchor_bookmark26_bookmark26 Anchor_bookmark26_bookmark26Table: download_history

Anchor1.26. Table: general_equipment1.26. Table: general_equipment Anchor_bookmark27_bookmark27 Anchor_bookmark27_bookmark27Table: general_equipment

Anchor1.27. Table: general_image1.27. Table: general_image Anchor_bookmark28_bookmark28 Anchor_bookmark28_bookmark28Table: general_image

Anchor1.28. Table: general_series1.28. Table: general_series Anchor_bookmark29_bookmark29 Anchor_bookmark29_bookmark29Table: general_series

Anchor1.29. Table: gui_action_history1.29. Table: gui_action_history Anchor_bookmark30_bookmark30 Anchor_bookmark30_bookmark30Table: gui_action_history

Anchor1.30. Table: hibernate_unique_key1.30. Table: hibernate_unique_key Anchor_bookmark31_bookmark31 Anchor_bookmark31_bookmark31Table: hibernate_unique_key

Anchor1.31. Table: login_history1.31. Table: login_history Anchor_bookmark32_bookmark32 Anchor_bookmark32_bookmark32Table: login_history

Anchor1.32. Table: modality_descriptions1.32. Table: modality_descriptions Anchor_bookmark33_bookmark33 Anchor_bookmark33_bookmark33Table: modality_descriptions

Anchor1.33. Table: mr_image1.33. Table: mr_image Anchor_bookmark34_bookmark34 Anchor_bookmark34_bookmark34Table: mr_image

Anchor1.34. Table: patient1.34. Table: patient Anchor_bookmark35_bookmark35 Anchor_bookmark35_bookmark35Table: patient

Anchor1.35. Table: qc_status_history1.35. Table: qc_status_history Anchor_bookmark36_bookmark36 Anchor_bookmark36_bookmark36Table: qc_status_history

Anchor1.36. Table: query_history1.36. Table: query_history Anchor_bookmark37_bookmark37 Anchor_bookmark37_bookmark37Table: query_history

Anchor1.37. Table: query_history_attribute1.37. Table: query_history_attribute Anchor_bookmark38_bookmark38 Anchor_bookmark38_bookmark38Table: query_history_attribute

Anchor1.38. Table: saved_query1.38. Table: saved_query Anchor_bookmark39_bookmark39 Anchor_bookmark39_bookmark39Table: saved_query

Anchor1.39. Table: saved_query_attribute1.39. Table: saved_query_attribute Anchor_bookmark40_bookmark40 Anchor_bookmark40_bookmark40Table: saved_query_attribute

Anchor1.40. Table: site1.40. Table: site Anchor_bookmark41_bookmark41 Anchor_bookmark41_bookmark41Table: site

Anchor1.41. Table: species1.41. Table: species Anchor_bookmark42_bookmark42 Anchor_bookmark42_bookmark42Table: species

Anchor1.42. Table: study1.42. Table: study Anchor_bookmark43_bookmark43 Anchor_bookmark43_bookmark43Table: study

Anchor1.43. Table: submission_history1.43. Table: submission_history Anchor_bookmark44_bookmark44 Anchor_bookmark44_bookmark44Table: submission_history

Anchor1.44. Table: trial_data_provenance1.44. Table: trial_data_provenance Anchor_bookmark45_bookmark45 Anchor_bookmark45_bookmark45Table: trial_data_provenance

Anchor1.45. Table: trial_site1.45. Table: trial_site Anchor_bookmark46_bookmark46 Anchor_bookmark46_bookmark46Table: trial_site

Anchor1.46. Table: workflow1.46. Table: workflow Anchor_bookmark47_bookmark47 Anchor_bookmark47_bookmark47Table: workflow

Anchor2. Views2. Views Anchor_bookmark48_bookmark48 Anchor_bookmark48_bookmark48Views

Anchor2.1. View: dicom_image2.1. View: dicom_image Anchor_bookmark49_bookmark49 Anchor_bookmark49_bookmark49View: dicom_image

Anchor2.2. View: dicom_series2.2. View: dicom_series Anchor_bookmark50_bookmark50 Anchor_bookmark50_bookmark50View: dicom_series

Anchor2.3. View: dicom_study2.3. View: dicom_study Anchor_bookmark51_bookmark51 Anchor_bookmark51_bookmark51View: dicom_study

Anchor2.4. View: manufacturer2.4. View: manufacturer Anchor_bookmark52_bookmark52 Anchor_bookmark52_bookmark52View: manufacturer

Anchor2.5. View: manufacturer_model_software2.5. View: manufacturer_model_software Anchor_bookmark53_bookmark53 Anchor_bookmark53_bookmark53View: manufacturer_model_software

Anchor2.6. View: number_month2.6. View: number_month Anchor_bookmark54_bookmark54 Anchor_bookmark54_bookmark54View: number_month

Anchor2.7. View: saved_query_last_exec2.7. View: saved_query_last_exec Anchor_bookmark55_bookmark55 Anchor_bookmark55_bookmark55View: saved_query_last_exec

Anchor2.8. View: software_versions2.8. View: software_versions Anchor_bookmark56_bookmark56 Anchor_bookmark56_bookmark56View: software_versions

Anchor2.9. View: study_series_number2.9. View: study_series_number Anchor_bookmark57_bookmark57 Anchor_bookmark57_bookmark57View: study_series_number

Columns
Name / Description

Image Modified
collection_descriptions_pk_id
PRIMARY

Image Modified
collection_descriptions_pk_id
PK_COLLECTION_DESC_PK_ID
...

Anchor
1.3. Table: csm_configuration_props
1.3. Table: csm_configuration_props
Anchor
_bookmark4
_bookmark4
Anchor
_bookmark4
_bookmark4
Table: csm_configuration_props

Anchor
1.4. Table: csm_filter_clause
1.4. Table: csm_filter_clause
Anchor
_bookmark5
_bookmark5
Anchor
_bookmark5
_bookmark5
Table: csm_filter_clause

Anchor
1.5. Table: csm_group
1.5. Table: csm_group
Anchor
_bookmark6
_bookmark6
Anchor
_bookmark6
_bookmark6
Table: csm_group

Anchor
1.6. Table: csm_mapping
1.6. Table: csm_mapping
Anchor
_bookmark7
_bookmark7
Anchor
_bookmark7
_bookmark7
Table: csm_mapping

Anchor
1.7. Table: csm_password_history
1.7. Table: csm_password_history
Anchor
_bookmark8
_bookmark8
Anchor
_bookmark8
_bookmark8
Table: csm_password_history

Anchor
1.8. Table: csm_pg_pe
1.8. Table: csm_pg_pe
Anchor
_bookmark9
_bookmark9
Anchor
_bookmark9
_bookmark9
Table: csm_pg_pe

Anchor
1.9. Table: csm_privilege
1.9. Table: csm_privilege
Anchor
_bookmark10
_bookmark10
Anchor
_bookmark10
_bookmark10
Table: csm_privilege

Anchor
1.10. Table: csm_protection_element
1.10. Table: csm_protection_element
Anchor
_bookmark11
_bookmark11
Anchor
_bookmark11
_bookmark11
Table: csm_protection_element

Anchor
1.11. Table: csm_protection_group
1.11. Table: csm_protection_group
Anchor
_bookmark12
_bookmark12
Anchor
_bookmark12
_bookmark12
Table: csm_protection_group

Anchor
1.12. Table: csm_role
1.12. Table: csm_role
Anchor
_bookmark13
_bookmark13
Anchor
_bookmark13
_bookmark13
Table: csm_role

Anchor
1.13. Table: csm_role_privilege
1.13. Table: csm_role_privilege
Anchor
_bookmark14
_bookmark14
Anchor
_bookmark14
_bookmark14
Table: csm_role_privilege

Anchor
1.14. Table: csm_user
1.14. Table: csm_user
Anchor
_bookmark15
_bookmark15
Anchor
_bookmark15
_bookmark15
Table: csm_user

Anchor
1.15. Table: csm_user_group
1.15. Table: csm_user_group
Anchor
_bookmark16
_bookmark16
Anchor
_bookmark16
_bookmark16
Table: csm_user_group

Anchor
1.16. Table: csm_user_group_role_pg
1.16. Table: csm_user_group_role_pg
Anchor
_bookmark17
_bookmark17
Anchor
_bookmark17
_bookmark17
Table: csm_user_group_role_pg

Anchor
1.17. Table: csm_user_pe
1.17. Table: csm_user_pe
Anchor
_bookmark18
_bookmark18
Anchor
_bookmark18
_bookmark18
Table: csm_user_pe

Anchor
1.18. Table: ct_image
1.18. Table: ct_image
Anchor
_bookmark19
_bookmark19
Anchor
_bookmark19
_bookmark19
Table: ct_image

Anchor
1.19. Table: custom_series_list
1.19. Table: custom_series_list
Anchor
_bookmark20
_bookmark20
Anchor
_bookmark20
_bookmark20
Table: custom_series_list

Anchor
1.20. Table: custom_series_list_attrib
1.20. Table: custom_series_list_attrib
Anchor
_bookmark21
_bookmark21
Anchor
_bookmark21
_bookmark21
Table: custom_series_list_attribute

Anchor
1.21. Table: databasechangelog
1.21. Table: databasechangelog
Anchor
_bookmark22
_bookmark22
Anchor
_bookmark22
_bookmark22
Table: databasechangelog

Anchor
1.22. Table: databasechangeloglock
1.22. Table: databasechangeloglock
Anchor
_bookmark23
_bookmark23
Anchor
_bookmark23
_bookmark23
Table: databasechangeloglock

Anchor
1.23. Table: deletion_audit_trail
1.23. Table: deletion_audit_trail
Anchor
_bookmark24
_bookmark24
Anchor
_bookmark24
_bookmark24
Table: deletion_audit_trail

Anchor
1.24. Table: download_data_history
1.24. Table: download_data_history
Anchor
_bookmark25
_bookmark25
Anchor
_bookmark25
_bookmark25
Table: download_data_history

Anchor
1.25. Table: download_history
1.25. Table: download_history
Anchor
_bookmark26
_bookmark26
Anchor
_bookmark26
_bookmark26
Table: download_history

Anchor
1.26. Table: general_equipment
1.26. Table: general_equipment
Anchor
_bookmark27
_bookmark27
Anchor
_bookmark27
_bookmark27
Table: general_equipment

Anchor
1.27. Table: general_image
1.27. Table: general_image
Anchor
_bookmark28
_bookmark28
Anchor
_bookmark28
_bookmark28
Table: general_image

Anchor
1.28. Table: general_series
1.28. Table: general_series
Anchor
_bookmark29
_bookmark29
Anchor
_bookmark29
_bookmark29
Table: general_series

Anchor
1.29. Table: gui_action_history
1.29. Table: gui_action_history
Anchor
_bookmark30
_bookmark30
Anchor
_bookmark30
_bookmark30
Table: gui_action_history

Anchor
1.30. Table: hibernate_unique_key
1.30. Table: hibernate_unique_key
Anchor
_bookmark31
_bookmark31
Anchor
_bookmark31
_bookmark31
Table: hibernate_unique_key

Anchor
1.31. Table: login_history
1.31. Table: login_history
Anchor
_bookmark32
_bookmark32
Anchor
_bookmark32
_bookmark32
Table: login_history

Anchor
1.32. Table: modality_descriptions
1.32. Table: modality_descriptions
Anchor
_bookmark33
_bookmark33
Anchor
_bookmark33
_bookmark33
Table: modality_descriptions

Anchor
1.33. Table: mr_image
1.33. Table: mr_image
Anchor
_bookmark34
_bookmark34
Anchor
_bookmark34
_bookmark34
Table: mr_image

Anchor
1.34. Table: patient
1.34. Table: patient
Anchor
_bookmark35
_bookmark35
Anchor
_bookmark35
_bookmark35
Table: patient

Anchor
1.35. Table: qc_status_history
1.35. Table: qc_status_history
Anchor
_bookmark36
_bookmark36
Anchor
_bookmark36
_bookmark36
Table: qc_status_history

Anchor
1.36. Table: query_history
1.36. Table: query_history
Anchor
_bookmark37
_bookmark37
Anchor
_bookmark37
_bookmark37
Table: query_history

Anchor
1.37. Table: query_history_attribute
1.37. Table: query_history_attribute
Anchor
_bookmark38
_bookmark38
Anchor
_bookmark38
_bookmark38
Table: query_history_attribute

Anchor
1.38. Table: saved_query
1.38. Table: saved_query
Anchor
_bookmark39
_bookmark39
Anchor
_bookmark39
_bookmark39
Table: saved_query

Anchor
1.39. Table: saved_query_attribute
1.39. Table: saved_query_attribute
Anchor
_bookmark40
_bookmark40
Anchor
_bookmark40
_bookmark40
Table: saved_query_attribute

Anchor
1.40. Table: site
1.40. Table: site
Anchor
_bookmark41
_bookmark41
Anchor
_bookmark41
_bookmark41
Table: site

Anchor
1.41. Table: species
1.41. Table: species
Anchor
_bookmark42
_bookmark42
Anchor
_bookmark42
_bookmark42
Table: species

Anchor
1.42. Table: study
1.42. Table: study
Anchor
_bookmark43
_bookmark43
Anchor
_bookmark43
_bookmark43
Table: study

Anchor
1.43. Table: submission_history
1.43. Table: submission_history
Anchor
_bookmark44
_bookmark44
Anchor
_bookmark44
_bookmark44
Table: submission_history

Anchor
1.44. Table: trial_data_provenance
1.44. Table: trial_data_provenance
Anchor
_bookmark45
_bookmark45
Anchor
_bookmark45
_bookmark45
Table: trial_data_provenance

Anchor
1.45. Table: trial_site
1.45. Table: trial_site
Anchor
_bookmark46
_bookmark46
Anchor
_bookmark46
_bookmark46
Table: trial_site

Anchor
1.46. Table: workflow
1.46. Table: workflow
Anchor
_bookmark47
_bookmark47
Anchor
_bookmark47
_bookmark47
Table: workflow

Anchor
2. Views
2. Views
Anchor
_bookmark48
_bookmark48
Anchor
_bookmark48
_bookmark48
Views

Anchor
2.1. View: dicom_image
2.1. View: dicom_image
Anchor
_bookmark49
_bookmark49
Anchor
_bookmark49
_bookmark49
View: dicom_image

Anchor
2.2. View: dicom_series
2.2. View: dicom_series
Anchor
_bookmark50
_bookmark50
Anchor
_bookmark50
_bookmark50
View: dicom_series

Anchor
2.3. View: dicom_study
2.3. View: dicom_study
Anchor
_bookmark51
_bookmark51
Anchor
_bookmark51
_bookmark51
View: dicom_study

Anchor
2.4. View: manufacturer
2.4. View: manufacturer
Anchor
_bookmark52
_bookmark52
Anchor
_bookmark52
_bookmark52
View: manufacturer

Anchor
2.5. View: manufacturer_model_software
2.5. View: manufacturer_model_software
Anchor
_bookmark53
_bookmark53
Anchor
_bookmark53
_bookmark53
View: manufacturer_model_software

Anchor
2.6. View: number_month
2.6. View: number_month
Anchor
_bookmark54
_bookmark54
Anchor
_bookmark54
_bookmark54
View: number_month

Anchor
2.7. View: saved_query_last_exec
2.7. View: saved_query_last_exec
Anchor
_bookmark55
_bookmark55
Anchor
_bookmark55
_bookmark55
View: saved_query_last_exec

Anchor
2.8. View: software_versions
2.8. View: software_versions
Anchor
_bookmark56
_bookmark56
Anchor
_bookmark56
_bookmark56
View: software_versions

Anchor
2.9. View: study_series_number
2.9. View: study_series_number
Anchor
_bookmark57
_bookmark57
Anchor
_bookmark57
_bookmark57
View: study_series_number