EVENTS_ORDERS_STATES
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| ORDER_ID | NUMBER(38) | N | NO | NO | NO | |
| USER_ID | NUMBER(38) | N | NO | NO | NO | |
| PAID_P | CHAR(1.0) | Y | NO | NO | NO | |
| PAYMENT_METHOD | VARCHAR2(50.0) | Y | NO | NO | NO | |
| CONFIRMED_DATE | DATE | Y | NO | NO | NO | |
| PRICE_CHARGED | NUMBER(38) | Y | NO | NO | NO | |
| REFUNDED_DATE | DATE | Y | NO | NO | NO | |
| PRICE_REFUNDED | NUMBER(38) | Y | NO | NO | NO | |
| IP_ADDRESS | VARCHAR2(50.0) | N | NO | NO | NO | |
| ORDER_STATE | VARCHAR2(10.0) | Y | NO | NO | NO | |
Query:
select o.*,
o_states.order_state
from events_orders o,
(select
order_id,
decode (floor(avg (decode (reg_state,
'canceled', 0,
'waiting', 1,
'pending', 2,
'shipped', 3,
0))),
0, 'canceled',
1, 'incomplete',
2, 'incomplete',
3, 'fulfilled',
'void') as order_state
from events_registrations
group by order_id) o_states
where o_states.order_id = o.order_id
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002