Error rendering macro 'rw-search'

null

Page History

Versions Compared

Key

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

Anchor

	Data Dictionary
	Data Dictionary

Lite Edition

NBIA

Data Dictionary

6/17/2020 12:00:00 AM

Generated with
Image Added
Table of contents
NBIA 7

Tables 7
Views 33
1. View: dicom_image 33
2. View: dicom_series 35
3. View: dicom_study 35
4. View: manufacturer 36
5. View: manufacturer_model_software 36
6. View: number_month 36
7. View: saved_query_last_exec 36
8. View: software_versions 37
9. View: study_series_number 37Legend
  Image Added Primary key
  Image Added Primary key disabled
  Image Added User-defined primary key Image Added Unique key
  Image Added Unique key disabled
  Image Added User-defined unique key Image Added Active trigger
  Image AddedImage Added Disabled trigger Many to one relation
  Image AddedImage Added User-defined many to one relation One to many relation
  Image AddedImage Added User-defined one to many relation One to one relation
  Image Added 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
  Anchor
  NBIA
  NBIA
  Anchor
  _bookmark0
  _bookmark0
  NBIA
  Anchor
  1. Tables
  1. Tables
  Anchor
  _bookmark1
  _bookmark1
  Anchor
  _bookmark1
  _bookmark1
  Tables

Anchor
1.1. Table: collection_descriptions
1.1. Table: collection_descriptions
Anchor
_bookmark2
_bookmark2
Anchor
_bookmark2
_bookmark2
Table: collection_descriptions

Columns

		Name	Data type	Description / Attributes
Image Added	Image Added	collection_descriptions_pk_id	bigint(19, 0)
Image Added		collection_name	varchar(64)	Nullable
Image Added		user_name	varchar(20)	Nullable
Image Added		description	mediumtext	Nullable
Image Added		collection_descriptions_timest	date	Nullable

Unique keys

	Columns	Name / Description
Image Added	collection_descriptions_pk_id	PRIMARY
Image Added	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

Anchor
1.2. Table: csm_application
1.2. Table: csm_application
Anchor
_bookmark3
_bookmark3
Anchor
_bookmark3
_bookmark3
Table: csm_application

Columns

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

Linked from

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

Unique keys

	Columns	Name / Description
Image Added	APPLICATION_ID	PRIMARY
Image Added	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 Added	Image Added	PROPERTY_KEY	varchar(300)
Image Added		PROPERTY_VALUE	varchar(3000)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	FILTER_CLAUSE_ID	bigint(19, 0)	Identity / Auto increment
Image Added		CLASS_NAME	varchar(100)
Image Added		FILTER_CHAIN	varchar(2000)
Image Added		TARGET_CLASS_NAME	varchar(100)
Image Added		TARGET_CLASS_ATTRIBUTE_NAME	varchar(100)
Image Added		TARGET_CLASS_ATTRIBUTE_TYPE	varchar(100)
Image Added		TARGET_CLASS_ALIAS	varchar(100)	Nullable
Image Added		TARGET_CLASS_ATTRIBUTE_ALIAS	varchar(100)	Nullable
Image Added		GENERATED_SQL_USER	varchar(4000)
Image Added		APPLICATION_ID	bigint(19, 0)
Image Added		UPDATE_DATE	date
Image Added		GENERATED_SQL_GROUP	varchar(4000)

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	GROUP_NAME	varchar(255)
Image Added		GROUP_DESC	varchar(200)	Nullable
Image Added		UPDATE_DATE	date	Default: 1950-01-01
Image Added	Image Added	APPLICATION_ID	bigint(19, 0)	References: csm_application

Links to

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

Linked from

	Table	Join	Title / Name / Description
Image Added	csm_user_group	csm_group.GROUP_ID = csm_user_group.GROUP_ID	FK_UG_GROUP
Image Added	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 Added	GROUP_ID	PRIMARY
Image Added	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 Added	Image Added	MAPPING_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Added	Image Added	OBJECT_NAME	varchar(100)
Image Added	Image Added	ATTRIBUTE_NAME	varchar(100)
Image Added		OBJECT_PACKAGE_NAME	varchar(100)	Nullable
Image Added		TABLE_NAME	varchar(100)	Nullable
Image Added		TABLE_NAME_GROUP	varchar(100)	Nullable
Image Added		TABLE_NAME_USER	varchar(100)	Nullable
Image Added		VIEW_NAME_GROUP	varchar(100)	Nullable
Image Added		VIEW_NAME_USER	varchar(100)	Nullable
Image Added		ACTIVE_FLAG	tinyint(3, 0)	Default: 0
Image Added		MAINTAINED_FLAG	tinyint(3, 0)	Default: 0

Links to

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

Unique keys

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

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	PG_PE_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
Image Added	Image Added	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Links to

	Table	Join	Title / Name / Description
Image Added	csm_protection_element	csm_pg_pe.PROTECTION_ELEMENT_I D = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_PROTECTION_GROUP
Image Added	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 Added	PG_PE_ID	PRIMARY
	Columns	Name / Description
Image Added	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 Added	Image Added	PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	PRIVILEGE_NAME	varchar(100)
Image Added		PRIVILEGE_DESCRIPTION	varchar(200)	Nullable
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Linked from

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

Unique keys

	Columns	Name / Description
Image Added	PRIVILEGE_ID	PRIMARY
Image Added	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 Added	Image Added	PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
Image Added		PROTECTION_ELEMENT_NAME	varchar(100)
Image Added		PROTECTION_ELEMENT_DESCRIPTI ON	varchar(200)	Nullable
Image Added	Image Added	OBJECT_ID	varchar(100)
Image Added	Image Added	ATTRIBUTE	varchar(100)	Nullable
Image Added		PROTECTION_ELEMENT_TYPE	varchar(100)	Nullable
Image Added	Image Added	APPLICATION_ID	bigint(19, 0)
Image Added		UPDATE_DATE	date	Default: 1950-01-01
Image Added	Image Added	ATTRIBUTE_VALUE	varchar(100)	Nullable

Linked from

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

Links to

	Table	Join	Title / Name / Description
Image Added	csm_application	csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID	FK_PG_APPLICATION
Image Added	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 Added	csm_protection_group	csm_protection_group.PROTECTION_ GROUP_ID = csm_protection_group.PARENT_PROT ECTION_GROUP_ID	FK_PROTECTION_GROUP
Image Added	csm_pg_pe	csm_protection_group.PROTECTION_ GROUP_ID = csm_pg_pe.PROTECTION_GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT
Image Added	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 Added	PROTECTION_GROUP_ID	PRIMARY
Image Added	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 Added	Image Added	ROLE_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	ROLE_NAME	varchar(100)
Image Added		ROLE_DESCRIPTION	varchar(200)	Nullable
Image Added	Image Added	APPLICATION_ID	bigint(19, 0)	References: csm_application
Image Added		ACTIVE_FLAG	tinyint(3, 0)
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Linked from

	Table	Join	Title / Name / Description
Image Added	csm_role_privilege	csm_role.ROLE_ID = csm_role_privilege.ROLE_ID	FK_ROLE
Image Added	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 Added	ROLE_ID	PRIMARY
Image Added	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 Added	Image Added	ROLE_PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	ROLE_ID	bigint(19, 0)	References: csm_role
Image Added	Image Added	PRIVILEGE_ID	bigint(19, 0)	References: csm_privilege
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Unique keys

	Columns	Name / Description
Image Added	ROLE_PRIVILEGE_ID	PRIMARY
Image Added	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 Added	Image Added	USER_ID	bigint(19, 0)	Identity / Auto increment
Image Added		LOGIN_NAME	varchar(500)	Nullable
Image Added		FIRST_NAME	varchar(100)
Image Added		LAST_NAME	varchar(100)
Image Added		ORGANIZATION	varchar(500)	Nullable
Image Added		DEPARTMENT	varchar(100)	Nullable
Image Added		TITLE	varchar(100)	Nullable
Image Added		PHONE_NUMBER	varchar(100)	Nullable
Image Added		PASSWORD	varchar(100)	Nullable
Image Added		EMAIL_ID	varchar(100)	Nullable
Image Added		START_DATE	date	Nullable
Image Added		END_DATE	date	Nullable
Image Added		UPDATE_DATE	date	Default: 1950-01-01
Image Added		MIDDLE_NAME	varchar(100)	Nullable
Image Added		FAX	varchar(20)	Nullable
Image Added		ADDRESS	varchar(200)	Nullable
Image Added		CITY	varchar(100)	Nullable
Image Added		STATE	varchar(100)	Nullable
Image Added		COUNTRY	varchar(100)	Nullable
Image Added		POSTAL_CODE	varchar(10)	Nullable
Image Added		MIGRATED_FLAG	tinyint(3, 0)	Default: 0
Image Added		PREMGRT_LOGIN_NAME	varchar(100)	Nullable
Image Added		PASSWORD_EXPIRED	tinyint(3, 0)	Nullable Default: 0
Image Added		FIRST_TIME_LOGIN	tinyint(3, 0)	Nullable Default: 0
		Name	Data type	Description / Attributes
Image Added		ACTIVE_FLAG	tinyint(3, 0)	Nullable Default: 1
Image Added		PASSWORD_EXPIRY_DATE	date	Nullable Default: 2012-10-10

Linked from

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

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	USER_GROUP_ID	bigint(19, 0)	Identity / Auto increment
Image Added		USER_ID	bigint(19, 0)	References: csm_user
Image Added		GROUP_ID	bigint(19, 0)	References: csm_group

Links to

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

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	USER_GROUP_ROLE_PG_ID	bigint(19, 0)	Identity / Auto increment
		Name	Data type	Description / Attributes
Image Added		USER_ID	bigint(19, 0)	Nullable References: csm_user
Image Added		GROUP_ID	bigint(19, 0)	Nullable References: csm_group
Image Added		ROLE_ID	bigint(19, 0)	References: csm_role
Image Added		PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Links to

	Table	Join	Title / Name / Description
Image Added	csm_group	csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
Image Added	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 Added	csm_role	csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE
Image Added	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 Added	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 Added	Image Added	USER_PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
Image Added	Image Added	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
Image Added	Image Added	USER_ID	bigint(19, 0)	References: csm_user
Image Added		UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Unique keys

	Columns	Name / Description
Image Added	USER_PROTECTION_ELEMENT_ID	PRIMARY
	Columns	Name / Description
Image Added	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 Added		kvp	decimal(22, 6)	Nullable
Image Added		scan_options	varchar(16)	Nullable
Image Added		data_collection_diameter	decimal(22, 6)	Nullable
Image Added		reconstruction_diameter	decimal(22, 6)	Nullable
Image Added		gantry_detector_tilt	decimal(22, 6)	Nullable
Image Added		exposure_time	decimal(22, 6)	Nullable
Image Added		x_ray_tube_current	decimal(22, 6)	Nullable
Image Added		exposure	decimal(22, 6)	Nullable
Image Added		exposure_in_microas	decimal(22, 6)	Nullable
Image Added		convolution_kernel	varchar(16)	Nullable
Image Added		revolution_time	decimal(22, 6)	Nullable
Image Added		single_collimation_width	decimal(22, 6)	Nullable
Image Added		total_collimation_width	decimal(22, 6)	Nullable
Image Added		table_speed	decimal(22, 6)	Nullable
Image Added		table_feed_per_rotation	decimal(22, 6)	Nullable
Image Added		ct_pitch_factor	decimal(22, 6)	Nullable
Image Added		anatomic_region_seq	varchar(500)	Nullable
Image Added		image_pk_id	bigint(19, 0)	References: general_image
Image Added	Image Added	ct_image_pk_id	bigint(19, 0)
Image Added		general_series_pk_id	bigint(19, 0)	Nullable References: general_series

Links to

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

Unique keys

	Columns	Name / Description
Image Added	ct_image_pk_id	PRIMARY
Image Added	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 Added	Image Added	CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)
Image Added		NAME	varchar(200)	Nullable
Image Added		comment_	varchar(200)	Nullable
Image Added		HYPERLINK	varchar(200)	Nullable
Image Added		CUSTOM_SERIES_LIST_TIMESTAMP	date	Nullable
Image Added		USER_NAME	varchar(20)	Nullable
Image Added		usage_count	unsigned int(10, 0)	Nullable Default: 0

Linked from

	Table	Join	Title / Name / Description
Image Added	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 Added	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
Image Added	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 Added	Image Added	custom_series_list_attribute_p	bigint(19, 0)
Image Added		SERIES_INSTANCE_UID	varchar(200)	Nullable
Image Added		CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)	References: custom_series_list

Links to

	Table	Join	Title / Name / Description
Image Added	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 Added	custom_series_list_attribute_p	PRIMARY
Image Added	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 Added	Image Added	ID	varchar(63)
Image Added	Image Added	AUTHOR	varchar(63)
Image Added	Image Added	FILENAME	varchar(200)
Image Added		DATEEXECUTED	datetime
Image Added		MD5SUM	varchar(32)	Nullable
Image Added		DESCRIPTION	varchar(255)	Nullable
Image Added		COMMENTS	varchar(255)	Nullable
Image Added		TAG	varchar(255)	Nullable
Image Added		LIQUIBASE	varchar(10)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	ID	int(10, 0)
Image Added		LOCKED	tinyint(3, 0)
Image Added		LOCKGRANTED	datetime	Nullable
Image Added		LOCKEDBY	varchar(255)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	deletion_pk_id	bigint(19, 0)
Image Added		data_id	varchar(64)	Nullable
Image Added		data_type	varchar(50)	Nullable
Image Added		total_image	bigint(19, 0)	Nullable
Image Added		user_name	varchar(50)	Nullable
Image Added		time_stamp	datetime	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	download_data_history_pk_id	bigint(19, 0)
Image Added		series_instance_uid	varchar(64)	Nullable
Image Added		login_name	varchar(100)	Nullable
Image Added		download_timestamp	date	Nullable
Image Added		download_type	varchar(20)	Nullable
Image Added		size_	decimal(22, 2)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	download_history_pk_id	bigint(19, 0)
Image Added		user_id	bigint(19, 0)	Nullable
Image Added		timestamp	datetime	Nullable
Image Added		total_file_size	decimal(22, 2)	Nullable
Image Added		download_file_name	varchar(300)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	general_equipment_pk_id	bigint(19, 0)
Image Added		manufacturer	varchar(64)	Nullable
Image Added		institution_name	varchar(64)	Nullable
Image Added		manufacturer_model_name	varchar(64)	Nullable
Image Added		software_versions	varchar(64)	Nullable
Image Added		institution_address	varchar(1024)	Nullable
Image Added		station_name	varchar(16)	Nullable
Image Added		device_serial_number	varchar(64)	Nullable

Linked from

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

Links to

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

Linked from

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

Unique keys

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

Links to

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

Linked from

	Table	Join	Title / Name / Description
Image Added	ct_image	general_series.general_series_pk_id = ct_image.general_series_pk_id	ct_image_ibfk_1
Image Added	general_image	general_series.general_series_pk_id = general_image.general_series_pk_id	fk_g_series_pk_id
Image Added	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 Added	general_series_pk_id	PRIMARY
Image Added	general_series_pk_id	PK_G_SERIES_PK_ID
Image Added	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 Added	Image Added	GUI_ACTION_HISTORY_PK_ID	bigint(19, 0)	Default: 0
Image Added		ACTION_TIMESTAMP	date	Nullable
Image Added		ACTION	varchar(255)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added		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 Added	Image Added	login_history_pk_id	bigint(19, 0)
Image Added		login_timestamp	datetime	Nullable
Image Added		ip_address	varchar(15)	Nullable

Unique keys

	Columns	Name / Description
Image Added	login_history_pk_id	PRIMARY
Image Added	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 Added	Image Added	modality_descriptions_pk_id	bigint(19, 0)
Image Added		modality_name	varchar(20)	Nullable
Image Added		description	mediumtext	Nullable

Unique keys

	Columns	Name / Description
Image Added	modality_descriptions_pk_id	PRIMARY
Image Added	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 Added		IMAGE_TYPE_VALUE_3	varchar(16)
Image Added		SCANNING_SEQUENCE	varchar(126)
Image Added		SEQUENCE_VARIANT	varchar(126)
Image Added		REPETITION_TIME	decimal(22, 10)	Nullable
Image Added		ECHO_TIME	decimal(22, 10)	Nullable
Image Added		INVERSION_TIME	decimal(22, 10)	Nullable
Image Added		SEQUENCE_NAME	varchar(64)	Nullable
		Name	Data type	Description / Attributes
Image Added		IMAGED_NUCLEUS	varchar(64)	Nullable
Image Added		MAGNETIC_FIELD_STRENGTH	decimal(22, 10)	Nullable
Image Added		SAR	decimal(22, 10)	Nullable
Image Added		DB_DT	decimal(22, 10)	Nullable
Image Added		TRIGGER_TIME	decimal(22, 10)	Nullable
Image Added		ANGIO_FLAG	varchar(1)	Nullable
Image Added		IMAGE_PK_ID	bigint(19, 0)	References: general_image
Image Added	Image Added	MR_IMAGE_PK_ID	bigint(19, 0)	Identity / Auto increment
Image Added		GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable References: general_series

Links to

	Table	Join	Title / Name / Description
Image Added	general_image	mr_image.IMAGE_PK_ID = general_image.image_pk_id	FK_MR_GEN_IMAGE_PK_ID
Image Added	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 Added	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 Added	Image Added	patient_pk_id	bigint(19, 0)
Image Added		patient_id	varchar(64)	Nullable
Image Added		patient_name	varchar(250)	Nullable
Image Added		patient_birth_date	date	Nullable
Image Added		patient_sex	varchar(16)	Nullable
Image Added		ethnic_group	varchar(16)	Nullable
Image Added		trial_dp_pk_id	bigint(19, 0)	Nullable References: trial_data_provenance
Image Added		trial_subject_id	varchar(64)	Nullable
Image Added		trial_subject_reading_id	varchar(255)	Nullable
Image Added		trial_site_pk_id	bigint(19, 0)	Nullable
Image Added		species_code	varchar(100)	Nullable
Image Added		species_description	varchar(100)	Nullable
Image Added		qc_subject	varchar(4)	Nullable

Links to

	Table	Join	Title / Name / Description
Image Added	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 Added	general_image	patient.patient_pk_id = general_image.patient_pk_id	FK_general_image_patient
Image Added	study	patient.patient_pk_id = study.patient_pk_id	fk_patient_pk_id

Unique keys

	Columns	Name / Description
Image Added	patient_pk_id	PRIMARY
Image Added	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 Added	Image Added	qc_status_history_pk_id	bigint(19, 0)
Image Added		series_instance_uid	varchar(64)
Image Added		user_id	varchar(100)	Nullable
Image Added		comment_	varchar(4000)	Nullable
Image Added		history_timestamp	datetime	Nullable
Image Added		new_value	varchar(100)	Nullable
Image Added		old_value	varchar(100)	Nullable
Image Added		oldBatch	varchar(20)	Nullable
Image Added		newBatch	varchar(20)	Nullable
Image Added		oldSubmissionType	varchar(100)	Nullable
Image Added		newSubmissionType	varchar(100)	Nullable
Image Added		oldReleasedStatus	varchar(50)	Nullable
Image Added		newReleasedStatus	varchar(50)	Nullable

Unique keys

	Columns	Name / Description
Image Added	qc_status_history_pk_id	PRIMARY
Image Added	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 Added	Image Added	query_history_pk_id	bigint(19, 0)
Image Added		user_id	bigint(19, 0)	Nullable References: csm_user
Image Added		query_execute_timestamp	datetime	Nullable
Image Added		query_elapsed_time	bigint(19, 0)	Nullable
Image Added		saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
Image Added		tool	varchar(100)	Nullable

Links to

	Table	Join	Title / Name / Description
Image Added	csm_user	query_history.user_id = csm_user.USER_ID	FK_Q_H_USER_ID
Image Added	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 Added	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 Added	query_history_pk_id	PRIMARY
Image Added	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 Added	Image Added	query_history_attribute_pk_id	bigint(19, 0)
Image Added		attribute_name	varchar(300)	Nullable
Image Added		subattribute_name	varchar(300)	Nullable
Image Added		attribute_value	varchar(300)	Nullable
Image Added		query_history_pk_id	bigint(19, 0)	Nullable References: query_history
Image Added		instance_number	bigint(19, 0)	Nullable

Links to

	Table	Join	Title / Name / Description
Image Added	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 Added	query_history_attribute_pk_id	PRIMARY
Image Added	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 Added	Image Added	saved_query_pk_id	bigint(19, 0)
Image Added		user_id	bigint(19, 0)	Nullable References: csm_user
Image Added		query_name	varchar(200)	Nullable
Image Added		new_data_flag	varchar(5)	Nullable
Image Added		active	varchar(5)	Nullable
Image Added		query_execute_timestamp	datetime	Nullable

Links to

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

Linked from

	Table	Join	Title / Name / Description
Image Added	query_history	saved_query.saved_query_pk_id = query_history.saved_query_pk_id	fk_s_query_pk_id
Image Added	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 Added	saved_query_pk_id	PRIMARY
Image Added	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 Added	Image Added	saved_query_attribute_pk_id	bigint(19, 0)
Image Added		attribute_name	varchar(300)	Nullable
Image Added		subattribute_name	varchar(300)	Nullable
Image Added		attribute_value	varchar(300)	Nullable
Image Added		saved_query_pk_id	bigint(19, 0)	Nullable References: saved_query
		Name	Data type	Description / Attributes
Image Added		instance_number	bigint(19, 0)	Nullable

Links to

	Table	Join	Title / Name / Description
Image Added	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 Added	saved_query_attribute_pk_id	PRIMARY
Image Added	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 Added	Image Added	site_pk_id	bigint(19, 0)
Image Added		dp_site_name	varchar(40)	Nullable
Image Added		dp_site_id	varchar(64)	Nullable
Image Added		trial_dp_pk_id	bigint(19, 0)	References: trial_data_provenance

Links to

	Table	Join	Title / Name / Description
Image Added	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 Added	site_pk_id	PRIMARY
Image Added	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 Added	Image Added	species_code	varchar(64)
Image Added		species_description	varchar(500)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	study_pk_id	bigint(19, 0)
Image Added	Image Added	study_instance_uid	varchar(500)	Nullable
Image Added		study_date	date
Image Added		study_time	varchar(16)	Nullable
Image Added		study_desc	varchar(64)	Nullable
Image Added		admitting_diagnoses_desc	varchar(64)	Nullable
Image Added		admitting_diagnoses_code_seq	varchar(500)	Nullable
Image Added		patient_pk_id	bigint(19, 0)	Nullable References: patient
Image Added		study_id	varchar(16)	Nullable
Image Added		trial_time_point_id	varchar(64)	Nullable
Image Added		trial_time_point_desc	varchar(1024)	Nullable
Image Added		patient_age	varchar(4)	Nullable
Image Added		age_group	varchar(10)	Nullable
Image Added		patient_size	decimal(22, 6)	Nullable
Image Added		patient_weight	decimal(22, 6)	Nullable
Image Added		occupation	varchar(16)	Nullable
Image Added		additional_patient_history	varchar(4000)	Nullable

Links to

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

Linked from

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

Unique keys

	Columns	Name / Description
Image Added	study_pk_id	PRIMARY
Image Added	study_pk_id	PK_STUDY_PK_ID
Image Added	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 Added	Image Added	submission_history_pk_id	bigint(19, 0)	Identity / Auto increment
Image Added		patient_id	varchar(64)	Nullable
Image Added		study_instance_uid	varchar(500)	Nullable
Image Added		series_instance_uid	varchar(64)	Nullable
Image Added		sop_instance_uid	varchar(64)	Nullable
Image Added		submission_timestamp	datetime	Nullable
Image Added		project	varchar(200)	Nullable
Image Added		site	varchar(40)	Nullable
Image Added		operation_type	smallint(5, 0)

Unique keys

	Columns	Name / Description
Image Added	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 Added	Image Added	trial_dp_pk_id	bigint(19, 0)
Image Added		dp_site_name	varchar(40)	Nullable
Image Added		dp_site_id	varchar(64)	Nullable
Image Added		project	varchar(50)	Nullable

Linked from

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

Unique keys

	Columns	Name / Description
Image Added	trial_dp_pk_id	PRIMARY
Image Added	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 Added	Image Added	trial_site_pk_id	bigint(19, 0)
Image Added		trial_site_id	varchar(64)	Nullable
		Name	Data type	Description / Attributes
Image Added		trial_site_name	varchar(64)	Nullable
Image Added		trial_pk_id	bigint(19, 0)	Nullable

Unique keys

	Columns	Name / Description
Image Added	trial_site_pk_id	PRIMARY
Image Added	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 Added	Image Added	WORKFLOW_ID	bigint(19, 0)
Image Added		NAME	varchar(50)	Nullable
Image Added		COLLECTION	varchar(200)	Nullable
Image Added		SITE	varchar(200)	Nullable
Image Added		URL	varchar(255)	Nullable
Image Added		WORKFLOW_TYPE	varchar(50)	Nullable

Unique keys

	Columns	Name / Description
Image Added	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 Added	IMAGE_PK_ID	bigint(19, 0)
Image Added	INSTANCE_NUMBER	bigint(19, 0)	Nullable
Image Added	CONTENT_DATE	date	Nullable
Image Added	CONTENT_TIME	varchar(16)	Nullable
Image Added	IMAGE_TYPE	varchar(16)	Nullable
Image Added	ACQUISITION_DATE	date	Nullable
Image Added	ACQUISITION_TIME	varchar(16)	Nullable
Image Added	ACQUISITION_NUMBER	decimal(22, 6)	Nullable
Image Added	LOSSY_IMAGE_COMPRESSION	varchar(16)	Nullable
Image Added	PIXEL_SPACING	decimal(22, 6)	Nullable
Image Added	IMAGE_ORIENTATION_PATIENT	varchar(200)	Nullable
Image Added	IMAGE_POSITION_PATIENT	varchar(200)	Nullable
	Name	Data type	Description / Attributes
Image Added	SLICE_THICKNESS	decimal(22, 6)	Nullable
Image Added	SLICE_LOCATION	decimal(22, 6)	Nullable
Image Added	I_ROWS	decimal(22, 6)	Nullable
Image Added	I_COLUMNS	decimal(22, 6)	Nullable
Image Added	CONTRAST_BOLUS_AGENT	varchar(64)	Nullable
Image Added	CONTRAST_BOLUS_ROUTE	varchar(64)	Nullable
Image Added	SOP_CLASS_UID	varchar(64)	Nullable
Image Added	SOP_INSTANCE_UID	varchar(64)	Nullable
Image Added	GENERAL_SERIES_PK_ID	bigint(19, 0)	Nullable
Image Added	PATIENT_POSITION	varchar(16)	Nullable
Image Added	SOURCE_TO_DETECTOR_DISTANCE	decimal(22, 6)	Nullable
Image Added	SOURCE_SUBJECT_DISTANCE	decimal(22, 6)	Nullable
Image Added	FOCAL_SPOT_SIZE	decimal(22, 6)	Nullable
Image Added	STORAGE_MEDIA_FILE_SET_UID	varchar(64)	Nullable
Image Added	DICOM_FILE_URI	varchar(2000)	Nullable
Image Added	ACQUISITION_DATETIME	varchar(50)	Nullable
Image Added	IMAGE_COMMENTS	varchar(4000)	Nullable
Image Added	IMAGE_RECEIVING_TIMESTAMP	datetime	Nullable
Image Added	CURATION_TIMESTAMP	datetime	Nullable
Image Added	ANNOTATION	varchar(20)	Nullable
Image Added	SUBMISSION_DATE	date	Nullable
Image Added	DICOM_SIZE	decimal(22, 6)	Nullable
Image Added	IMAGE_LATERALITY	varchar(16)	Nullable
Image Added	TRIAL_DP_PK_ID	bigint(19, 0)	Nullable
Image Added	PATIENT_ID	varchar(64)	Nullable
Image Added	STUDY_INSTANCE_UID	varchar(500)	Nullable
Image Added	SERIES_INSTANCE_UID	varchar(64)	Nullable
Image Added	PATIENT_PK_ID	bigint(19, 0)	Nullable
Image Added	STUDY_PK_ID	bigint(19, 0)	Nullable
Image Added	PROJECT	varchar(200)	Nullable
Image Added	ACQUISITION_MATRIX	decimal(22, 6)	Nullable Default: 0.000000
Image Added	DX_DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable Default: 0.000000
Image Added	KVP	decimal(22, 6)	Nullable
Image Added	SCAN_OPTIONS	varchar(16)	Nullable
Image Added	DATA_COLLECTION_DIAMETER	decimal(22, 6)	Nullable
Image Added	RECONSTRUCTION_DIAMETER	decimal(22, 6)	Nullable
Image Added	GANTRY_DETECTOR_TILT	decimal(22, 6)	Nullable
	Name	Data type	Description / Attributes
Image Added	EXPOSURE_TIME	decimal(22, 6)	Nullable
Image Added	X_RAY_TUBE_CURRENT	decimal(22, 6)	Nullable
Image Added	EXPOSURE	decimal(22, 6)	Nullable
Image Added	EXPOSURE_IN_MICROAS	decimal(22, 6)	Nullable
Image Added	CONVOLUTION_KERNEL	varchar(16)	Nullable
Image Added	REVOLUTION_TIME	decimal(22, 6)	Nullable
Image Added	SINGLE_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
Image Added	TOTAL_COLLIMATION_WIDTH	decimal(22, 6)	Nullable
Image Added	TABLE_SPEED	decimal(22, 6)	Nullable
Image Added	TABLE_FEED_PER_ROTATION	decimal(22, 6)	Nullable
Image Added	CT_PITCH_FACTOR	decimal(22, 6)	Nullable
Image Added	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 Added	GENERAL_SERIES_PK_ID	bigint(19, 0)
Image Added	BODY_PART_EXAMINED	varchar(16)	Nullable
Image Added	FRAME_OF_REFERENCE_UID	varchar(64)	Nullable
Image Added	SERIES_LATERALITY	varchar(16)	Nullable
Image Added	MODALITY	varchar(16)
Image Added	PROTOCOL_NAME	varchar(64)	Nullable
Image Added	SERIES_DATE	date	Nullable
Image Added	SERIES_DESC	varchar(64)	Nullable
Image Added	SERIES_INSTANCE_UID	varchar(64)	Nullable
Image Added	SERIES_NUMBER	decimal(22, 6)	Nullable
Image Added	SYNC_FRAME_OF_REF_UID	varchar(64)	Nullable
Image Added	STUDY_PK_ID	bigint(19, 0)	Nullable
Image Added	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 Added	STUDY_PK_ID	bigint(19, 0)
Image Added	STUDY_INSTANCE_UID	varchar(500)	Nullable
Image Added	ADDITIONAL_PATIENT_HISTORY	varchar(4000)	Nullable
Image Added	STUDY_DATE	date
	Name	Data type	Description / Attributes
Image Added	STUDY_DESC	varchar(64)	Nullable
Image Added	ADMITTING_DIAGNOSES_DESC	varchar(64)	Nullable
Image Added	ADMITTING_DIAGNOSES_CODE_S EQ	varchar(500)	Nullable
Image Added	OCCUPATION	varchar(16)	Nullable
Image Added	PATIENT_AGE	varchar(4)	Nullable
Image Added	PATIENT_SIZE	decimal(22, 6)	Nullable
Image Added	PATIENT_WEIGHT	decimal(22, 6)	Nullable
Image Added	STUDY_ID	varchar(16)	Nullable
Image Added	STUDY_TIME	varchar(16)	Nullable
Image Added	TRIAL_TIME_POINT_ID	varchar(64)	Nullable
Image Added	TRIAL_TIME_POINT_DESC	varchar(1024)	Nullable
Image Added	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 Added		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 Added	ID	bigint(19, 0)
Image Added	MANUFACTURER	varchar(64)	Nullable
Image Added	MODEL	varchar(64)	Nullable
Image Added	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 Added	PATIENT_ID	bigint(19, 0)	Nullable
Image Added	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 Added	SAVED_QUERY_PK_ID	bigint(19, 0)	Nullable
Image Added	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 Added		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 Added	PATIENT_PK_ID	bigint(19, 0)	Nullable
Image Added	PATIENT_ID	varchar(64)	Nullable
Image Added	PROJECT	varchar(50)	Nullable
Image Added	STUDY_NUMBER	bigint(19, 0)	Default: 0
Image Added	SERIES_NUMBER	bigint(19, 0)	Default: 0

Content

Space Tools

Page History

Versions Compared

Old Version 1

New Version 2

Key

NBIA

Anchor1. Tables1. Tables Anchor_bookmark1_bookmark1 Anchor_bookmark1_bookmark1Tables

Anchor1.1. Table: collection_descriptions1.1. Table: collection_descriptions Anchor_bookmark2_bookmark2 Anchor_bookmark2_bookmark2Table: collection_descriptions

Anchor1.2. Table: csm_application1.2. Table: csm_application Anchor_bookmark3_bookmark3 Anchor_bookmark3_bookmark3Table: 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

Anchor
1. Tables
1. Tables
Anchor
_bookmark1
_bookmark1
Anchor
_bookmark1
_bookmark1
Tables

Anchor
1.1. Table: collection_descriptions
1.1. Table: collection_descriptions
Anchor
_bookmark2
_bookmark2
Anchor
_bookmark2
_bookmark2
Table: collection_descriptions

Anchor
1.2. Table: csm_application
1.2. Table: csm_application
Anchor
_bookmark3
_bookmark3
Anchor
_bookmark3
_bookmark3
Table: csm_application

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