EVENTS_REG_CANCELED
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| REG_ID | NUMBER(38) | N | YES | YES | YES | |
| ORDER_ID | NUMBER(38) | N | YES | YES | YES | |
| PRICE_ID | NUMBER(38) | N | YES | YES | YES | |
| USER_ID | NUMBER(38) | N | YES | YES | YES | |
| REG_STATE | VARCHAR2(50.0) | N | YES | YES | YES | |
| REG_DATE | DATE | Y | YES | YES | YES | |
| SHIPPED_DATE | DATE | Y | YES | YES | YES | |
| ORG | VARCHAR2(500.0) | Y | YES | YES | YES | |
| TITLE_AT_ORG | VARCHAR2(500.0) | Y | YES | YES | YES | |
| ATTENDING_REASON | CLOB | Y | YES | YES | YES | |
| WHERE_HEARD | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| NEED_HOTEL_P | CHAR(1.0) | Y | YES | YES | YES | |
| NEED_CAR_P | CHAR(1.0) | Y | YES | YES | YES | |
| NEED_PLANE_P | CHAR(1.0) | Y | YES | YES | YES | |
| COMMENTS | CLOB | Y | YES | YES | YES | |
Query:
select "REG_ID","ORDER_ID","PRICE_ID","USER_ID","REG_STATE","REG_DATE","SHIPPED_DATE","ORG","TITLE_AT_ORG","ATTENDING_REASON","WHERE_HEARD","NEED_HOTEL_P","NEED_CAR_P","NEED_PLANE_P","COMMENTS"
from events_registrations
where reg_state = 'canceled'
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002