| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| SESSION_ID | NUMBER(38) | N | ||
| MODULE | VARCHAR2(50.0) | N | ||
| PROPERTY_NAME | VARCHAR2(50.0) | N | ||
| PROPERTY_VALUE | CLOB | Y | ||
| SECURE_P | CHAR(1.0) | Y |
| Constraint Name | Columns |
|---|---|
| SYS_C002087398 | SESSION_ID , MODULE , PROPERTY_NAME |
| Constraint Name | Check Condition |
|---|---|
| SYS_C002087394 | "SESSION_ID" IS NOT NULL |
| SYS_C002087395 | "MODULE" IS NOT NULL |
| SYS_C002087396 | "PROPERTY_NAME" IS NOT NULL |
| SYS_C002087397 | secure_p in ('t','f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| SYS_C002087399 | SESSION_ID | SEC_SESSIONS | SYS_C002087387 | NO ACTION |
| SYS_C002087400 | SESSION_ID | SEC_SESSIONS | SYS_C002087387 | CASCADE |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| SYS_C002087398 | NORMAL | UNIQUE | SESSION_ID , MODULE , PROPERTY_NAME |
| SYS_IL0001976428C00004$$ | LOB | UNIQUE |