 |
Page History
...
| Icon | Description |
|---|---|
| Primary key |
| Primary key disabled |
| User-defined primary key |
| Unique key |
| Unique key disabled |
| User-defined unique key |
| Active trigger |
| Disabled trigger Many to one relation |
| User-defined many to one relation One to many relation |
| User-defined one to many relation One to one relation |
| Â User-defined one to one relation |
| Input |
| Output |
| Input/Output |
| Uses dependency |
| User-defined uses dependency |
| Used by dependency |
| User-defined used by dependency |
Tables
Columns for Table: collection_descriptions
...
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_group.APPLICATION_ID = csm_application.APPLICATION_ID | FK_APPLICATION_GROUP |
Linked from
Table | Join | Title / Name / Description | |
| csm_group.GROUP_ID = csm_user_group.GROUP_ID | FK_UG_GROUP | |
| 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_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_ |
...
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_pg_pe.PROTECTION_ELEMENT_I D = | FK_PROTECTION_ELEMENT_PROTECTION_GROUP | |
| csm_pg_pe.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_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_protection_element.PROTECTION | FK_PROTECTION_ELEMENT_PROTECTION_GROUP | |
Table | Join | Title / Name / Description | |
| csm_protection_element.PROTECTION | 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 |
...
