EVENTS_ORGANIZERS
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ROLE_ID | NUMBER(38) | N | NO | NO | NO | |
| EVENT_ID | NUMBER(38) | N | NO | NO | NO | |
| ROLE | VARCHAR2(200.0) | N | NO | NO | NO | |
| RESPONSIBILITIES | CLOB | Y | NO | NO | NO | |
| PUBLIC_ROLE_P | CHAR(1.0) | Y | NO | NO | NO | |
| USER_ID | NUMBER(38) | Y | NO | NO | NO | |
Query:
select eor.*, eom.user_id
from events_event_organizer_roles eor, events_organizers_map eom
where eor.role_id=eom.role_id(+)
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002