USERS_ALERTABLE
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| USER_ID | NUMBER(38) | N | YES | YES | YES | |
| FIRST_NAMES | VARCHAR2(100.0) | N | YES | YES | YES | |
| LAST_NAME | VARCHAR2(100.0) | N | YES | YES | YES | |
| SCREEN_NAME | VARCHAR2(100.0) | Y | YES | YES | YES | |
| PRIV_NAME | NUMBER(38) | Y | YES | YES | YES | |
| EMAIL | VARCHAR2(100.0) | N | YES | YES | YES | |
| PRIV_EMAIL | NUMBER(38) | Y | YES | YES | YES | |
| EMAIL_BOUNCING_P | CHAR(1.0) | Y | YES | YES | YES | |
| CONVERTED_P | CHAR(1.0) | Y | YES | YES | YES | |
| PASSWORD | VARCHAR2(30.0) | N | YES | YES | YES | |
| URL | VARCHAR2(200.0) | Y | YES | YES | YES | |
| ON_VACATION_UNTIL | DATE | Y | YES | YES | YES | |
| LAST_VISIT | DATE | Y | YES | YES | YES | |
| SECOND_TO_LAST_VISIT | DATE | Y | YES | YES | YES | |
| N_SESSIONS | NUMBER(38) | Y | YES | YES | YES | |
| REGISTRATION_DATE | DATE | Y | YES | YES | YES | |
| REGISTRATION_IP | VARCHAR2(50.0) | Y | YES | YES | YES | |
| USER_STATE | VARCHAR2(100.0) | Y | YES | YES | YES | |
| APPROVED_DATE | DATE | Y | YES | YES | YES | |
| APPROVING_USER | NUMBER(38) | Y | YES | YES | YES | |
| APPROVING_NOTE | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| EMAIL_VERIFIED_DATE | DATE | Y | YES | YES | YES | |
| REJECTED_DATE | DATE | Y | YES | YES | YES | |
| REJECTING_USER | NUMBER(38) | Y | YES | YES | YES | |
| REJECTING_NOTE | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| DELETED_DATE | DATE | Y | YES | YES | YES | |
| DELETING_USER | NUMBER(38) | Y | YES | YES | YES | |
| DELETING_NOTE | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| BANNED_DATE | DATE | Y | YES | YES | YES | |
| BANNING_USER | NUMBER(38) | Y | YES | YES | YES | |
| BANNING_NOTE | VARCHAR2(4000.0) | Y | YES | YES | YES | |
| CRM_STATE | VARCHAR2(50.0) | Y | YES | YES | YES | |
| CRM_STATE_ENTERED_DATE | DATE | Y | YES | YES | YES | |
| BIO | VARCHAR2(4000.0) | Y | YES | YES | YES | |
Query:
select u.*
from users u
where (u.on_vacation_until is null or
u.on_vacation_until < sysdate)
and u.user_state = 'authorized'
and (u.email_bouncing_p is null or u.email_bouncing_p = 'f')
and not exists (select 1
from user_vacations v
where v.user_id = u.user_id
and sysdate between v.start_date and v.end_date
and receive_email_p = 'f')
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002