APM_RGX_OP_STORES
Details
-
Schema: FUSION
-
Object owner: APM
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
APM_RGX_OP_STORES_PK |
ROLE_CODE, TEMPLATE_ID |
Columns
| Name | Datatype | Length | Not-null | Comments |
|---|---|---|---|---|
| ROLE_CODE | VARCHAR2 | 1000 | Yes | ROLE_CODE |
| TEMPLATE_ID | NUMBER | Yes | TEMPLATE_ID | |
| CREATOR | VARCHAR2 | 1000 | Yes | CREATOR |
| CREATION_DATE | DATE | Yes | Who column: indicates the date and time of the creation of the row. | |
| MODIFIER | VARCHAR2 | 1000 | MODIFIER | |
| MODIFICATION_DATE | DATE | MODIFICATION_DATE | ||
| STATUS_CODE | VARCHAR2 | 30 | Yes | STATUS_CODE |
| DIMENSION_VALUE | VARCHAR2 | 1000 | DIMENSION_VALUE | |
| DIMENSION_ALIAS_COLUMN | VARCHAR2 | 1000 | DIMENSION_ALIAS_COLUMN | |
| LDAP_GUID | VARCHAR2 | 255 | LDAP_GUID | |
| BASE_ROLE | VARCHAR2 | 1000 | BASE_ROLE | |
| CREATED_BY | VARCHAR2 | 64 | Who column: indicates the user who created the row. | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| APM_RGX_OP_STORES_INDEX1 | Non Unique | Default | ROLE_CODE |
| APM_RGX_OP_STORES_U1 | Unique | Default | ROLE_CODE, TEMPLATE_ID |