| Name | Type | Nullable | Default value | Comment |
|---|---|---|---|---|
| ROLE_ID | NUMBER(38) | N | ||
| EVENT_ID | NUMBER(38) | N | ||
| ROLE | VARCHAR2(200.0) | N | ||
| RESPONSIBILITIES | CLOB | Y | ||
| PUBLIC_ROLE_P | CHAR(1.0) | Y | 'f' |
| Constraint Name | Columns |
|---|---|
| EVNT_EV_ORG_ROLES_ROLE_ID_PK | ROLE_ID |
| Constraint Name | Check Condition |
|---|---|
| EVNT_EV_ORG_ROLES_EVENT_ID_NN | "EVENT_ID" IS NOT NULL |
| EVNT_EV_ORG_ROLES_ROLE_NN | "ROLE" IS NOT NULL |
| EVNT_EV_ROLES_PUBLIC_ROLE_P | public_role_p in ('t', 'f') |
| Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
|---|---|---|---|---|
| EVNT_EV_ORG_ROLES_EVENT_ID_FK | EVENT_ID | EVENTS_EVENTS | SYS_C002088228 | NO ACTION |
| Option | Settings |
|---|---|
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
| Index Name | Type | Unuqueness | Columns |
|---|---|---|---|
| EVNT_EV_ORG_ROLES_ROLE_ID_PK | NORMAL | UNIQUE | ROLE_ID |
| SYS_IL0001976990C00004$$ | LOB | UNIQUE |
| Table | Constraint |
|---|---|
| EVENTS_ORGANIZERS_MAP | EVNT_ORG_MAP_ROLE_ID_FK |