USERS_SPAMMABLE
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 | |
| EMAIL_TYPE | VARCHAR2(64.0) | Y | NO | NO | NO | |
Query:
select u.*, up.email_type
from users u, users_preferences up
where u.user_id = up.user_id(+)
and user_state = 'authorized'
and (email_bouncing_p is null or email_bouncing_p = 'f')
and (dont_spam_me_p is null or dont_spam_me_p = 'f')
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002