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