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