Error rendering macro 'rw-search'

null

Page History

Versions Compared

Key

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

...

Table: csm_user_group

Columns

Image Removed

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

Icon1

Icon2Key

Name

Data type

Description / Attributes

USER_GROUP_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

USER_ID

bigint(19, 0)

References: csm_user

Image Removed

GROUP_ID

bigint(19, 0)

References: csm_group

...

Table: csm_user_group_role_pg

Columns

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

Links to

Table	Join	Title / Name / Description
csm_group	csm_user_group_role_pg.GROUP_ID = csm_group.GROUP_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_GROUPS
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
csm_role	csm_user_group_role_pg.ROLE_ID = csm_role.ROLE_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_ROLE
csm_user	csm_user_group_role_pg.USER_ID = csm_user.USER_ID	FK_USER_GROUP_ROLE_PROTECTION_GROUP_USER

Unique keys

IconKey	Columns	Name / Description
	USER_GROUP_ROLE_PG_ID	PRIMARY

Table: csm_user_pe

Columns

Image Removed

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

Links to

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

Unique keys

IconKey	Columns	Name / Description
	USER_PROTECTION_ELEMENT_ID	PRIMARY
	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

Image Removed

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

Links to

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

Unique keys

IconKey	Columns	Name / Description
	ct_image_pk_id	PRIMARY
	ct_image_pk_id	PK_CT_IMAGE_PK_ID

Table: custom_series_list

Columns

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

Linked from

IconRelationship	Table	Join	Title / Name / Description
	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

IconKey	Columns	Name / Description
	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
	CUSTOM_SERIES_LIST_PK_ID	CUSTOM_SERIES_LIST_PK_ID

Table: custom_series_list_attribute

Columns

Image Removed

Icon1	Icon2Key	Name	Data type	Description / Attributes
	custom_series_list_attribute_p	bigint(19, 0)	_ Image Removed
_	SERIES_INSTANCE_UID	varchar(200)	Nullable Image Removed
_	CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)	References: custom_series_list

Icon1

Icon2Key

Name

Data type

Description / Attributes

custom_series_list_attribute_p

bigint(19, 0)

Image Removed

SERIES_INSTANCE_UID

varchar(200)

Nullable

Image Removed

CUSTOM_SERIES_LIST_PK_ID

bigint(19, 0)

References: custom_series_list

Links to

IconRelationship	Table	Join	Title / Name / Description
	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

IconKey	Columns	Name / Description
	custom_series_list_attribute_p	PRIMARY
	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

Table: databasechangelog

Columns

Icon1	Icon2Key	Name	Data type
Image Removed	ID	varchar(63)	_ Image Removed
	AUTHOR	varchar(63)	_ Image Removed
	FILENAME	varchar(200)	_ Image Removed
_	DATEEXECUTED	datetime	_ Image Removed
_	MD5SUM	varchar(32)	Nullable Image Removed
_	DESCRIPTION	varchar(255)	Nullable Image Removed
_	COMMENTS	varchar(255)	Nullable
Image Removed -	TAG	varchar(255)	Nullable
Image Removed -	LIQUIBASE	varchar(10)	Nullable

Unique keys

IconKey	Columns	Name / Description
	ID, AUTHOR, FILENAME	PRIMARY

Table: databasechangeloglock

Columns

Icon1Key	Icon2	Name	Data type	Description / Attributes
Image Removed		ID	int(10, 0)	-
Image Removed -	LOCKED	tinyint(3, 0)	-
Image Removed -	LOCKGRANTED	datetime	Nullable
Image Removed -	LOCKEDBY	varchar(255)	Nullable

Unique keys

IconKey	Columns	Name / Description
	ID	PRIMARY

Table: deletion_audit_trail

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	deletion_pk_id	bigint(19, 0)	-
Image Removed -	data_id	varchar(64)	Nullable
Image Removed -	data_type	varchar(50)	Nullable
Image Removed -	total_image	bigint(19, 0)	Nullable
Image Removed -	user_name	varchar(50)	Nullable
Image Removed -	time_stamp	datetime	Nullable

Unique keys

IconKey	Columns	Name / Description
	deletion_pk_id	PRIMARY

Table: download_data_history

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	download_data_history_pk_id	bigint(19, 0)	-
- Image Removed	series_instance_uid	varchar(64)	Nullable
Image Removed -	login_name	varchar(100)	Nullable
Image Removed -	download_timestamp	date	Nullable
Image Removed -	download_type	varchar(20)	Nullable
Image Removed -	size_	decimal(22, 2)	Nullable

Unique keys

IconKey	Columns	Name / Description
	download_data_history_pk_id	PRIMARY

Table: download_history

Columns

Image Removed

Icon1	Icon2Key	Name	Data type
	download_history_pk_id	bigint(19, 0)	-
Image Removed -	user_id	bigint(19, 0)	Nullable
Image Removed -	timestamp	datetime	Nullable
Image Removed -	total_file_size	decimal(22, 2)	Nullable
Image Removed -	download_file_name	varchar(300)	Nullable

Unique keys

IconKey	Columns	Name / Description
	download_history_pk_id	PRIMARY

...

Content

Space Tools

Versions Compared

Old Version 22

New Version 23

Key

Table: csm_user_group

Table: csm_user_group_role_pg

Table: csm_user_pe

Table: ct_image

Table: custom_series_list

Table: custom_series_list_attribute

Table: databasechangelog

Table: databasechangeloglock

Table: deletion_audit_trail

Table: download_data_history

Table: download_history