Page History

Versions Compared

Key

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

...

Icon2	Name	Data type	Description / Attributes
Image RemovedImage Added	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

...

Icon1	Columns	Name / Description
Image Modified	collection_descriptions_pk_id	PRIMARY
	collection_descriptions_pk_id	PK_COLLECTION_DESC_PK_ID

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	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

...

	Columns	Name / Description
Image Modified	APPLICATION_ID	PRIMARY
	APPLICATION_NAME	UQ_APPLICATION_NAME

...

		Name	Data type	Description / Attributes
	Image RemovedImage Added	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
Image RemovedImage Added	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
Image Modified	FILTER_CLAUSE_ID	PRIMARY

Table: csm_group

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	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
Image Modified	GROUP_ID	PRIMARY
	APPLICATION_ID, GROUP_NAME	UQ_GROUP_GROUP_NAME

Table: csm_mapping

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	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
Image Modified	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
Image RemovedImage Added	CSM_PASSWORD_HISTORY_ID	bigint(19, 0)	Identity / Auto increment
	LOGIN_NAME	varchar(500)	Nullable
	PASSWORD	varchar(255)	Nullable

Unique keys

	Columns	Name / Description
Image Modified	CSM_PASSWORD_HISTORY_ID	PRIMARY

Table: csm_pg_pe

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	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
Image Modified	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
Image RemovedImage Added	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
Image Modified	PRIVILEGE_ID	PRIMARY
	PRIVILEGE_NAME	UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

	Name	Data type	Description / Attributes
Image RemovedImage Added	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
Image RemovedImage Added	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

...

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

...

	Name	Data type	Description / Attributes
Image RemovedImage Added	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

...

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

Table: csm_user

Columns

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

Linked from

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

Unique keys

	Columns	Name / Description
Image Modified	USER_ID	PRIMARY

...

Table: csm_user_group

...

(CKK: Start here)

Columns

Name	Data type	Description / Attributes
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

...

Content

Space Tools

Versions Compared

Old Version 11

New Version 12

Key

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_user

Table: csm_user_group