Error rendering macro 'rw-search'

null

Page History

Versions Compared

Key

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

...

	Columns	Name / Description
	USER_ID	PRIMARY

Table: csm_user_group

(CKK: Start here)
Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	USER_GROUP_ID	bigint(19, 0)	Identity / Auto increment
	USER_ID	bigint(19, 0)	References: csm_user
	GROUP_ID	bigint(19, 0)	References: csm_group

Links to

	Table	Join	Title / Name / Description
	csm_group	csm_user_group.GROUP_ID = csm_group.GROUP_ID	FK_UG_GROUP
	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

...

Table: csm_user_group_role_pg

Columns

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

	Columns	Name / Description
Image Modified	USER_GROUP_ROLE_PG_ID	PRIMARY

...

Table: csm_user_pe

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	USER_PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
	PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
	USER_ID	bigint(19, 0)	References: csm_user
	UPDATE_DATE	date	Default: 1950-01-01

Links to

	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

	Columns	Name / Description
Image Modified	USER_PROTECTION_ELEMENT_ID	PRIMARY
	Columns	Name / Description
	USER_ID, PROTECTION_ELEMENT_ID	UQ_USER_PROTECTION_ELEMENT_PROTECTION_ELEMENT_ID

Table: ct_image

Columns

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

Links to

	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

	Columns	Name / Description
	ct_image_pk_id	PRIMARY
	ct_image_pk_id	PK_CT_IMAGE_PK_ID

...

Table: custom_series_list

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)
	NAME	varchar(200)	Nullable
	comment_	varchar(200)	Nullable
	HYPERLINK	varchar(200)	Nullable
	CUSTOM_SERIES_LIST_TIMESTAMP	date	Nullable
	USER_NAME	varchar(20)	Nullable
	usage_count	unsigned int(10, 0)	Nullable Default: 0

...

	Columns	Name / Description
Image Modified	CUSTOM_SERIES_LIST_PK_ID	PRIMARY
	CUSTOM_SERIES_LIST_PK_ID	CUSTOM_SERIES_LIST_PK_ID

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	custom_series_list_attribute_p	bigint(19, 0)
	SERIES_INSTANCE_UID	varchar(200)	Nullable
	CUSTOM_SERIES_LIST_PK_ID	bigint(19, 0)	References: custom_series_list

Links to

	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

	Columns	Name / Description
Image Modified	custom_series_list_attribute_p	PRIMARY
	custom_series_list_attribute_p	CUSTOM_SERIES_LIST_ATTRIBUTE_PK_ID

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	ID	varchar(63)
Image RemovedImage Added	AUTHOR	varchar(63)
Image RemovedImage Added	FILENAME	varchar(200)
	DATEEXECUTED	datetime
	MD5SUM	varchar(32)	Nullable
	DESCRIPTION	varchar(255)	Nullable
	COMMENTS	varchar(255)	Nullable
	TAG	varchar(255)	Nullable
	LIQUIBASE	varchar(10)	Nullable

...

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

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	ID	int(10, 0)
	LOCKED	tinyint(3, 0)
	LOCKGRANTED	datetime	Nullable
	LOCKEDBY	varchar(255)	Nullable

...

	Columns	Name / Description
Image Modified	ID	PRIMARY

Table: deletion_audit_trail

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	deletion_pk_id	bigint(19, 0)
	data_id	varchar(64)	Nullable
	data_type	varchar(50)	Nullable
	total_image	bigint(19, 0)	Nullable
	user_name	varchar(50)	Nullable
	time_stamp	datetime	Nullable

...

	Columns	Name / Description
Image Modified	deletion_pk_id	PRIMARY

Table: download_data_history

CKK: Start here
Columns

Name	Data type	Description / Attributes
download_data_history_pk_id	bigint(19, 0)
series_instance_uid	varchar(64)	Nullable
login_name	varchar(100)	Nullable
download_timestamp	date	Nullable
download_type	varchar(20)	Nullable
size_	decimal(22, 2)	Nullable

...

Content

Space Tools

Versions Compared

Old Version 12

New Version 13

Key

Table: csm_user_group

Table: csm_user_group_role_pg

Table: csm_user_pe

Table: ct_image

Table: custom_series_list

Table: deletion_audit_trail

Table: download_data_history