| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ROLE_ID | NUMBER(38) | N | ||
| ACTIVITY_ID | NUMBER(38) | N | ||
| ROLE | VARCHAR2(200.0) | N | ||
| RESPONSIBILITIES | CLOB | Y | ||
| PUBLIC_ROLE_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Columns |
|---|---|
| EVNT_ACT_ORG_ROLES_ROLE_ID_PK | ROLE_ID |
| Constraint Name | Check Condition |
|---|---|
| EVNT_ACT_ORG_ROLES_ROLE_NN | "ROLE" IS NOT NULL |
| EVNT_ACT_ROLE_ACTIVITY_ID_NN | "ACTIVITY_ID" IS NOT NULL |
| EVNT_ACT_ROLE_PUBLIC_ROLE_P | public_role_p in ('t', 'f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| EVNT_ACT_ROLE_ACTIVITY_ID_FK | ACTIVITY_ID | EVENTS_ACTIVITIES | SYS_C002088205 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| EVNT_ACT_ORG_ROLES_ROLE_ID_PK | NORMAL | UNIQUE | ROLE_ID |
| SYS_IL0001976985C00004$$ | LOB | UNIQUE |