NIH | National Cancer Institute | NCI Wiki  

Error rendering macro 'rw-search'

null

Versions Compared

Old Version 21

changes.mady.by.user Klinger, Carolyn (NIH/NCI) [C]

Saved on

compared with

New Version 22

changes.mady.by.user Klinger, Carolyn (NIH/NCI) [C]

Saved on

Key

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

...

Key

Name

Data type

Description / Attributes

Primary key

APPLICATION_ID

bigint(19, 0)

Identity / Auto increment

Unique key

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

Icon1Relationship

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



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

Icon1Key

Columns

Name / Description


Primary key

APPLICATION_ID

PRIMARY


Unique key

APPLICATION_NAME

UQ_APPLICATION_NAME

Table: csm_configuration_props

Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes

Image RemovedPrimary key

PROPERTY_KEY

varchar(300)

-

Image Removed

-

PROPERTY_VALUE

varchar(3000)

Nullable

Unique keys

IconKey

Columns

Name / Description

PROPERTY_KEY

PRIMARY

Table: csm_filter_clause

Columns

Image Removed

Icon1Key

Icon2

Name

Data type

Description / Attributes

Primary key

FILTER_CLAUSE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

CLASS_NAME

varchar(100)

_

Image Removed

_

FILTER_CHAIN

varchar(2000)

_

Image Removed

_

TARGET_CLASS_NAME

varchar(100)

_

Image Removed

_

TARGET_CLASS_ATTRIBUTE_NAME

varchar(100)

_

Image Removed

_

TARGET_CLASS_ATTRIBUTE_TYPE

varchar(100)

_

Image Removed

_

TARGET_CLASS_ALIAS

varchar(100)

Nullable

Image Removed

_

TARGET_CLASS_ATTRIBUTE_ALIAS

varchar(100)

Nullable

Image Removed

_

GENERATED_SQL_USER

varchar(4000)

_

Image Removed

_

APPLICATION_ID

bigint(19, 0)

_

Image Removed

_

UPDATE_DATE

date

_

Image Removed

_

GENERATED_SQL_GROUP

varchar(4000)

_

Unique keys

IconKey

Columns

Name / Description

Primary key

FILTER_CLAUSE_ID

PRIMARY

Table: csm_group

Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes


Image RemovedPrimary key

GROUP_ID

bigint(19, 0)

Identity / Auto increment


Image RemovedUnique key

GROUP_NAME

varchar(255)

_

Image Removed

_

GROUP_DESC

varchar(200)

Nullable

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Image Removed


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

Links to

IconRelationship

Table

Join

Title / Name / Description

csm_application

csm_group.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_GROUP

Linked from

IconRelationship

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

IconKey

Columns

Name / Description

Primary key

GROUP_ID

PRIMARY

Unique key

APPLICATION_ID, GROUP_NAME

UQ_GROUP_GROUP_NAM_

Table: csm_mapping

Columns

Icon1

Icon2Key

Name

Data type

Description / Attributes


Image RemovedPrimary key

MAPPING_ID

bigint(19, 0)

Identity _/ Auto increment


Image RemovedUnique key_

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed_

OBJECT_NAME

varchar(100)

_

Image RemovedUnique key

ATTRIBUTE_NAME

varchar(100)

_

Image Removed

_

OBJECT_PACKAGE_NAME

varchar(100)

Nullable

Image Removed

_

TABLE_NAME

varchar(100)

Nullable

Image Removed

_

TABLE_NAME_GROUP

varchar(100)

Nullable

Image Removed

_

TABLE_NAME_USER

varchar(100)

Nullable

Image Removed

_

VIEW_NAME_GROUP

varchar(100)

Nullable

Image Removed

_

VIEW_NAME_USER

varchar(100)

Nullable

Image Removed

_

ACTIVE_FLAG

tinyint(3, 0)

Default: 0

Image Removed

_

MAINTAINED_FLAG

tinyint(3, 0)

Default: 0

Links to

IconRelationship

Table

Join

Title / Name / Description

csm_application

csm_mapping.APPLICATION_ID = csm_application.APPLICATION_ID

FK_PE_APPLICATION

Unique keys

IconKey

Columns

Name / Description

Primary key

MAPPING_ID

PRIMARY

Unique key

OBJECT_NAME, ATTRIBUTE_NAME, APPLICATION_ID

UQ_MP_OBJ_NAME_ATTRI_NAME_APP_ID

Table: csm_password_history

Columns

Icon1

Icon2Key

Name

Data type

Description / Attributes


Image RemovedPrimary key

CSM_PASSWORD_HISTORY_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

LOGIN_NAME

varchar(500)

Nullable

Image Removed

_

PASSWORD

varchar(255)

Nullable

Unique keys

IconKey

Columns

Name / Description

Primary key

CSM_PASSWORD_HISTORY_ID

PRIMARY

Table: csm_pg_pe

Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes


Image RemovedPrimary key

PG_PE_ID

bigint(19, 0)

Identity / Auto increment


Image RemovedUnique key

PROTECTION_GROUP_ID

bigint(19, 0)

References: csm_protection_group


Image RemovedUnique key

PROTECTION_ELEMENT_ID

bigint(19, 0)

References: csm_protection_element

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Links to

IconRelationship

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

IconKey

Columns

Name / Description

Primary key

PG_PE_ID

PRIMARY

Unique key

PROTECTION_ELEMENT_ID, PROTECTION_GROUP_ID

UQ_PROTECTION_GROUP_PROTECTION_ELEMENT_PROTECTION_GROUP_ID

Table: csm_privilege

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment

Image Removed


Unique key

PRIVILEGE_NAME

varchar(100)

Image Removed

-

_

PRIVILEGE_DESCRIPTION

varchar(200)

Nullable

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Linked from

IconRelationship

Table

Join

Title / Name / Description

csm_role_privilege

csm_privilege.PRIVILEGE_ID = csm_role_privilege.PRIVILEGE_ID

FK_PRIVILEGE_ROLE

Unique keys

IconKey

Columns

Name / Description

Primary key

PRIVILEGE_ID

PRIMARY

Unique key

PRIVILEGE_NAME

UQ_PRIVILEGE_NAME

Table: csm_protection_element

Columns

Icon1Key

Icon2

Name

Data type

Description / Attributes

Image RemovedPrimary key

PROTECTION_ELEMENT_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

PROTECTION_ELEMENT_NAME

varchar(100)


Image Removed

_

PROTECTION_ELEMENT_DESCRIPTI ON

varchar(200)

Nullable

Image Removed


Unique key

OBJECT_ID

varchar(100)

Image Removed



Unique key

ATTRIBUTE

varchar(100)

Nullable

Image Removed

_

PROTECTION_ELEMENT_TYPE

varchar(100)

Nullable


Image RemovedUnique key

APPLICATION_ID

bigint(19, 0)


Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01


Image RemovedUnique key

ATTRIBUTE_VALUE

varchar(100)

Nullable

Linked from

IconRelationship

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

IconKey

Columns

Name / Description


PROTECTION_ELEMENT_ID

PRIMARY


Unique key

OBJECT_ID, ATTRIBUTE, ATTRIBUTE_VALUE, APPLICATION_ID

UQ_PE_PE_NAME_ATTRIBUTE_VALUE_APP_ID

Table: csm_protection_group

Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

PROTECTION_GROUP_ID

bigint(19, 0)

Identity / Auto increment

Image Removed


Unique key

PROTECTION_GROUP_NAME

varchar(100)

Image Removed


_

PROTECTION_GROUP_DESCRIPTIO N

varchar(200)

Nullable

Image Removed


Unique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed

_

LARGE_ELEMENT_COUNT_FLAG

tinyint(3, 0)

Image Removed


_

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

_

PARENT_PROTECTION_GROUP_ID

bigint(19, 0)

Nullable
References: csm_protection_group

Links to

IconRelationship

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

IconRelationship

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

IconKey

Columns

Name / Description


Primary key

PROTECTION_GROUP_ID

PRIMARY


Unique key

APPLICATION_ID, PROTECTION_GROUP_NAME

UQ_PROTECTION_GROUP_PROTECTION_GROUP_NAME

Table: csm_role

Columns

Image Removed

Icon1Key

Icon2

Name

Data type

Description / Attributes


Primary key

ROLE_ID

bigint(19, 0)

Identity / Auto increment


Image RemovedUnique key

ROLE_NAME

varchar(100)


Image Removed

_

ROLE_DESCRIPTION

varchar(200)

Nullable


Image RemovedUnique key

APPLICATION_ID

bigint(19, 0)

References: csm_application

Image Removed

_

ACTIVE_FLAG

tinyint(3, 0)

Image Removed


_

UPDATE_DATE

date

Default: 1950-01-01

Links to

IconRelationship

Table

Join

Title / Name / Description

csm_application

csm_role.APPLICATION_ID = csm_application.APPLICATION_ID

FK_APPLICATION_ROLE

Linked from

IconRelationship

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

IconKey

Columns

Name / Description


ROLE_ID

PRIMARY


Unique key

APPLICATION_ID, ROLE_NAME

UQ_ROLE_ROLE_NAME

Table: csm_role_privilege


Columns

Image Removed

Icon1Key

Icon2

Name

Data type

Description / Attributes


ROLE_PRIVILEGE_ID

bigint(19, 0)

Identity / Auto increment


Image RemovedUnique key

ROLE_ID

bigint(19, 0)

References: csm_role

Image Removed


Unique key

PRIVILEGE_ID

bigint(19, 0)

References: csm_privilege

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Links to

IconRelationship

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

IconKey

Columns

Name / Description


Primary key

ROLE_PRIVILEGE_ID

PRIMARY


Unique key

PRIVILEGE_ID, ROLE_ID

UQ_ROLE_PRIVILEGE_ROLE_ID

Table: csm_user


Columns

Image Removed

Icon1

Icon2Key

Name

Data type

Description / Attributes


Primary key

USER_ID

bigint(19, 0)

Identity / Auto increment

Image Removed

_

LOGIN_NAME

varchar(500)

Nullable

Image Removed

__

FIRST_NAME

varchar(100)

Image Removed


_

LAST_NAME

varchar(100)


Image Removed

__

ORGANIZATION

varchar(500)

Nullable

Image Removed

__

DEPARTMENT

varchar(100)

Nullable

Image Removed

_

TITLE

varchar(100)

Nullable

Image Removed

_

PHONE_NUMBER

varchar(100)

Nullable

Image Removed

_

PASSWORD

varchar(100)

Nullable

Image Removed

_

EMAIL_ID

varchar(100)

Nullable

Image Removed

_

START_DATE

date

Nullable

Image Removed

_

END_DATE

date

Nullable

Image Removed

_

UPDATE_DATE

date

Default: 1950-01-01

Image Removed

_

MIDDLE_NAME

varchar(100)

Nullable

Image Removed

_

FAX

varchar(20)

Nullable

Image Removed

_

ADDRESS

varchar(200)

Nullable

Image Removed

_

CITY

varchar(100)

Nullable

Image Removed

_

STATE

varchar(100)

Nullable

Image Removed

_

COUNTRY

varchar(100)

Nullable

Image Removed

_

POSTAL_CODE

varchar(10)

Nullable

Image Removed

_

MIGRATED_FLAG

tinyint(3, 0)

Default: 0

Image Removed

_

PREMGRT_LOGIN_NAME

varchar(100)

Nullable

Image Removed

_

PASSWORD_EXPIRED

tinyint(3, 0)

Nullable Default: 0

Image Removed

_

FIRST_TIME_LOGIN

tinyint(3, 0)

Nullable Default: 0

Image Removed

_

ACTIVE_FLAG

tinyint(3, 0)

Nullable Default: 1

Image Removed

_

PASSWORD_EXPIRY_DATE

date

Nullable
Default: 2012-10-10


Linked from

IconRelationship

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

IconKey

Columns

Name / Description


Primary key

USER_ID

PRIMARY

...