Page History

Versions Compared

Key

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

...

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

Unique keys

Icon1	Columns	Name / Description
	collection_descriptions_pk_id	PRIMARY
	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

...

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

Linked from

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

Unique keys

	Columns	Name / Description
	APPLICATION_ID	PRIMARY
	APPLICATION_NAME	UQ_APPLICATION_NAME

Table: csm_configuration_props

Columns

		Name	Data type	Description / Attributes
		PROPERTY_KEY	varchar(300)
		PROPERTY_VALUE	varchar(3000)	Nullable

Unique keys

	Columns	Name / Description
	PROPERTY_KEY	PRIMARY

Table: csm_filter_clause

Columns

Name	Data type	Description / Attributes
FILTER_CLAUSE_ID	bigint(19, 0)	Identity / Auto increment
CLASS_NAME	varchar(100)
FILTER_CHAIN	varchar(2000)
TARGET_CLASS_NAME	varchar(100)
TARGET_CLASS_ATTRIBUTE_NAME	varchar(100)
TARGET_CLASS_ATTRIBUTE_TYPE	varchar(100)
TARGET_CLASS_ALIAS	varchar(100)	Nullable
TARGET_CLASS_ATTRIBUTE_ALIAS	varchar(100)	Nullable
GENERATED_SQL_USER	varchar(4000)
APPLICATION_ID	bigint(19, 0)
UPDATE_DATE	date
GENERATED_SQL_GROUP	varchar(4000)

Unique keys

	Columns	Name / Description
	FILTER_CLAUSE_ID	PRIMARY

Table: csm_group

Columns

Name	Data type	Description / Attributes
GROUP_ID	bigint(19, 0)	Identity / Auto increment
GROUP_NAME	varchar(255)
GROUP_DESC	varchar(200)	Nullable
UPDATE_DATE	date	Default: 1950-01-01
APPLICATION_ID	bigint(19, 0)	References: csm_application

Links to

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

Linked from

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

Table: csm_mapping

Columns

Name	Data type	Description / Attributes
MAPPING_ID	bigint(19, 0)	Identity / Auto increment
APPLICATION_ID	bigint(19, 0)	References: csm_application
OBJECT_NAME	varchar(100)
ATTRIBUTE_NAME	varchar(100)
OBJECT_PACKAGE_NAME	varchar(100)	Nullable
TABLE_NAME	varchar(100)	Nullable
TABLE_NAME_GROUP	varchar(100)	Nullable
TABLE_NAME_USER	varchar(100)	Nullable
VIEW_NAME_GROUP	varchar(100)	Nullable
VIEW_NAME_USER	varchar(100)	Nullable
ACTIVE_FLAG	tinyint(3, 0)	Default: 0
MAINTAINED_FLAG	tinyint(3, 0)	Default: 0

Links to

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

Unique keys

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

Table: csm_password_history

Columns

Name	Data type	Description / Attributes
CSM_PASSWORD_HISTORY_ID	bigint(19, 0)	Identity / Auto increment
LOGIN_NAME	varchar(500)	Nullable
PASSWORD	varchar(255)	Nullable

Unique keys

	Columns	Name / Description
	CSM_PASSWORD_HISTORY_ID	PRIMARY

Table: csm_pg_pe

Columns

Name	Data type	Description / Attributes
PG_PE_ID	bigint(19, 0)	Identity / Auto increment
PROTECTION_GROUP_ID	bigint(19, 0)	References: csm_protection_group
PROTECTION_ELEMENT_ID	bigint(19, 0)	References: csm_protection_element
UPDATE_DATE	date	Default: 1950-01-01

Links to

Table	Join	Title / Name / Description
csm_protection_element	csm_pg_pe.PROTECTION_ELEMENT_I D = csm_protection_element.PROTECTION _ELEMENT_ID	FK_PROTECTION_ELEMENT_PROTECTION_GROUP
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
	PG_PE_ID	PRIMARY
	Columns	Name / Description
	PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID	UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns

Name	Data type	Description / Attributes
PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
PRIVILEGE_NAME	varchar(100)
PRIVILEGE_DESCRIPTION	varchar(200)	Nullable
UPDATE_DATE	date	Default: 1950-01-01

Linked from

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

Unique keys

	Columns	Name / Description
	PRIVILEGE_ID	PRIMARY
	PRIVILEGE_NAME	UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

Name	Data type	Description / Attributes
PROTECTION_ELEMENT_ID	bigint(19, 0)	Identity / Auto increment
PROTECTION_ELEMENT_NAME	varchar(100)
PROTECTION_ELEMENT_DESCRIPTI ON	varchar(200)	Nullable
OBJECT_ID	varchar(100)
ATTRIBUTE	varchar(100)	Nullable
PROTECTION_ELEMENT_TYPE	varchar(100)	Nullable
APPLICATION_ID	bigint(19, 0)
UPDATE_DATE	date	Default: 1950-01-01
ATTRIBUTE_VALUE	varchar(100)	Nullable

Linked from

Table	Join	Title / Name / Description
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
csm_user_pe	csm_protection_element.PROTECTION _ELEMENT_ID = csm_user_pe.PROTECTION_ELEMENT_ ID	FK_PROTECTION_ELEMENT_USER

Unique keys

	Columns	Name / Description
	PROTECTION_ELEMENT_ID	PRIMARY
	OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID	UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

Table: csm_protection_group

Columns

Name	Data type	Description / Attributes
PROTECTION_GROUP_ID	bigint(19, 0)	Identity / Auto increment
PROTECTION_GROUP_NAME	varchar(100)
PROTECTION_GROUP_DESCRIPTIO N	varchar(200)	Nullable
APPLICATION_ID	bigint(19, 0)	References: csm_application
LARGE_ELEMENT_COUNT_FLAG	tinyint(3, 0)
UPDATE_DATE	date	Default: 1950-01-01
PARENT_PROTECTION_GROUP_ID	bigint(19, 0)	Nullable References: csm_protection_group

Links to

	Table	Join	Title / Name / Description
	csm_application	csm_protection_group.APPLICATION_I D = csm_application.APPLICATION_ID	FK_PG_APPLICATION
	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
csm_protection_group	csm_protection_group.PROTECTION_ GROUP_ID = csm_protection_group.PARENT_PROT ECTION_GROUP_ID	FK_PROTECTION_GROUP
csm_pg_pe	csm_protection_group.PROTECTION_ GROUP_ID = csm_pg_pe.PROTECTION_GROUP_ID	FK_PROTECTION_GROUP_PROTECTION_ELEMENT
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
	PROTECTION_GROUP_ID	PRIMARY
	APPLICATION_ID, PROTECTION_GROUP_NAME	UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns

Name	Data type	Description / Attributes
ROLE_ID	bigint(19, 0)	Identity / Auto increment
ROLE_NAME	varchar(100)
ROLE_DESCRIPTION	varchar(200)	Nullable
APPLICATION_ID	bigint(19, 0)	References: csm_application
ACTIVE_FLAG	tinyint(3, 0)
UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Linked from

	Table	Join	Title / Name / Description
	csm_role_privilege	csm_role.ROLE_ID = csm_role_privilege.ROLE_ID	FK_ROLE
	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
	ROLE_ID	PRIMARY
	APPLICATION_ID, ROLE_NAME	UQ_ROLE_ROLE_NAME

Table: csm_role_privilege

Columns

Name	Data type	Description / Attributes
ROLE_PRIVILEGE_ID	bigint(19, 0)	Identity / Auto increment
ROLE_ID	bigint(19, 0)	References: csm_role
PRIVILEGE_ID	bigint(19, 0)	References: csm_privilege
UPDATE_DATE	date	Default: 1950-01-01

Links to

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

Unique keys

	Columns	Name / Description
	ROLE_PRIVILEGE_ID	PRIMARY
	PRIVILEGE_ID, ROLE_ID	UQ_ROLE_PRIVILEGE_ROLE_ID

...

		Name	Data type	Description / Attributes
		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
PATIENT_PK_ID	bigint(19, 0)	Nullable
PATIENT_ID	varchar(64)	Nullable
PROJECT	varchar(50)	Nullable
STUDY_NUMBER	bigint(19, 0)	Default: 0
SERIES_NUMBER	bigint(19, 0)	Default: 0

Content

Space Tools

Versions Compared

Old Version 10

New Version 11

Key

Table: csm_configuration_props

Table: csm_filter_clause

Table: csm_group

Table: csm_mapping

Table: csm_password_history

Table: csm_pg_pe

Table: csm_privilege

Table: csm_protection_element

Table: csm_protection_group

Table: csm_role

Table: csm_role_privilege

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

Content

Space Tools

Page History

Versions Compared

Old Version 10

New Version 11

Key

Table: csm_configuration_props

Table: csm_filter_clause

Table: csm_group

Table: csm_mapping

Table: csm_password_history

Table: csm_pg_pe

Table: csm_privilege

Table: csm_protection_element

Table: csm_protection_group

Table: csm_role

Table: csm_role_privilege

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

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