Main Tables Views Indexes Constraints Triggers Procedures Functions Packages Sanity check Index

ACS3 Data Model

Description Columns Query Constraints Triggers

EVENTS_REG_CANCELED

Columns

NameTypeNullableInsertableUpdatableDeletableComment
REG_IDNUMBER(38)NYESYESYES 
ORDER_IDNUMBER(38)NYESYESYES 
PRICE_IDNUMBER(38)NYESYESYES 
USER_IDNUMBER(38)NYESYESYES 
REG_STATEVARCHAR2(50.0)NYESYESYES 
REG_DATEDATEYYESYESYES 
SHIPPED_DATEDATEYYESYESYES 
ORGVARCHAR2(500.0)YYESYESYES 
TITLE_AT_ORGVARCHAR2(500.0)YYESYESYES 
ATTENDING_REASONCLOBYYESYESYES 
WHERE_HEARDVARCHAR2(4000.0)YYESYESYES 
NEED_HOTEL_PCHAR(1.0)YYESYESYES 
NEED_CAR_PCHAR(1.0)YYESYESYES 
NEED_PLANE_PCHAR(1.0)YYESYESYES 
COMMENTSCLOBYYESYESYES 

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