USERS_ACTIVE
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 "USER_ID","FIRST_NAMES","LAST_NAME","SCREEN_NAME","PRIV_NAME","EMAIL","PRIV_EMAIL","EMAIL_BOUNCING_P","CONVERTED_P","PASSWORD","URL","ON_VACATION_UNTIL","LAST_VISIT","SECOND_TO_LAST_VISIT","N_SESSIONS","REGISTRATION_DATE","REGISTRATION_IP","USER_STATE","APPROVED_DATE","APPROVING_USER","APPROVING_NOTE","EMAIL_VERIFIED_DATE","REJECTED_DATE","REJECTING_USER","REJECTING_NOTE","DELETED_DATE","DELETING_USER","DELETING_NOTE","BANNED_DATE","BANNING_USER","BANNING_NOTE","CRM_STATE","CRM_STATE_ENTERED_DATE","BIO"
from users
where user_state = 'authorized'
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002