Name | Type | Nullable | Default value | Comment |
---|---|---|---|---|
USER_ID | NUMBER(38) | N | ||
FIRST_NAMES | VARCHAR2(100.0) | N | ||
LAST_NAME | VARCHAR2(100.0) | N | ||
SCREEN_NAME | VARCHAR2(100.0) | Y | ||
PRIV_NAME | NUMBER(38) | Y | 0 | |
VARCHAR2(100.0) | N | |||
PRIV_EMAIL | NUMBER(38) | Y | 5 | |
EMAIL_BOUNCING_P | CHAR(1.0) | Y | 'f' | |
CONVERTED_P | CHAR(1.0) | Y | 'f' | |
PASSWORD | VARCHAR2(30.0) | N | ||
URL | VARCHAR2(200.0) | Y | ||
ON_VACATION_UNTIL | DATE | Y | ||
LAST_VISIT | DATE | Y | ||
SECOND_TO_LAST_VISIT | DATE | Y | ||
N_SESSIONS | NUMBER(38) | Y | 1 | |
REGISTRATION_DATE | DATE | Y | ||
REGISTRATION_IP | VARCHAR2(50.0) | Y | ||
USER_STATE | VARCHAR2(100.0) | Y | ||
APPROVED_DATE | DATE | Y | ||
APPROVING_USER | NUMBER(38) | Y | ||
APPROVING_NOTE | VARCHAR2(4000.0) | Y | ||
EMAIL_VERIFIED_DATE | DATE | Y | ||
REJECTED_DATE | DATE | Y | ||
REJECTING_USER | NUMBER(38) | Y | ||
REJECTING_NOTE | VARCHAR2(4000.0) | Y | ||
DELETED_DATE | DATE | Y | ||
DELETING_USER | NUMBER(38) | Y | ||
DELETING_NOTE | VARCHAR2(4000.0) | Y | ||
BANNED_DATE | DATE | Y | ||
BANNING_USER | NUMBER(38) | Y | ||
BANNING_NOTE | VARCHAR2(4000.0) | Y | ||
CRM_STATE | VARCHAR2(50.0) | Y | ||
CRM_STATE_ENTERED_DATE | DATE | Y | ||
BIO | VARCHAR2(4000.0) | Y |
Constraint Name | Columns |
---|---|
SYS_C002087135 | USER_ID |
Constraint Name | Check Condition |
---|---|
SYS_C002087127 | "USER_ID" IS NOT NULL |
SYS_C002087128 | "FIRST_NAMES" IS NOT NULL |
SYS_C002087129 | "LAST_NAME" IS NOT NULL |
SYS_C002087130 | "EMAIL" IS NOT NULL |
SYS_C002087131 | "PASSWORD" IS NOT NULL |
SYS_C002087132 | email_bouncing_p in ('t','f') |
SYS_C002087133 | converted_p in ('t','f') |
SYS_C002087134 | user_state in ('need_email_verification_and_admin_approv', 'need_admin_approv', 'need_email_verification', 'rejected', 'authorized', 'banned', 'deleted') |
Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
SYS_C002087138 | APPROVING_USER | USERS | SYS_C002087135 | NO ACTION |
SYS_C002087139 | REJECTING_USER | USERS | SYS_C002087135 | NO ACTION |
SYS_C002087140 | DELETING_USER | USERS | SYS_C002087135 | NO ACTION |
SYS_C002087141 | BANNING_USER | USERS | SYS_C002087135 | NO ACTION |
Constraint name | Columns |
---|---|
SYS_C002087137 | |
USERS_SCREEN_NAME_UNIQUE | SCREEN_NAME |
Option | Settings |
---|---|
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns |
---|---|---|---|
SYS_C002087135 | NORMAL | UNIQUE | USER_ID |
SYS_C002087137 | NORMAL | UNIQUE | |
USERS_BY_CRM_STATE | NORMAL | NONUNIQUE | CRM_STATE |
USERS_BY_LAST_VISIT | NORMAL | NONUNIQUE | LAST_VISIT |
USERS_SCREEN_NAME_UNIQUE | NORMAL | UNIQUE | SCREEN_NAME |
USERS_USER_STATE | NORMAL | NONUNIQUE | USER_STATE |
Table | Constraint |
---|---|
CONTEST_VOTES | CONTEST_VOTES_USER_ID_FK |
EVENTS_ORGANIZERS_MAP | EVNT_ORG_MAP_USER_ID_FK |
GENERAL_PORTRAITS | GP_UPOAD_USER_ID_FK |
IM_OFFICE_LINKS | IOL_USERS_ID_FK |
USERS | SYS_C002087138 |
USERS | SYS_C002087139 |
USERS | SYS_C002087140 |
USERS | SYS_C002087141 |
USER_VACATIONS | SYS_C002087146 |
USERS_PREFERENCES | SYS_C002087150 |
USERS_DEMOGRAPHICS | SYS_C002087153 |
USERS_DEMOGRAPHICS | SYS_C002087155 |
USERS_CONTACT | SYS_C002087158 |
USER_REQUIREMENTS | SYS_C002087164 |
USERS_INTERESTS | SYS_C002087186 |
STATIC_PAGES | SYS_C002087202 |
STATIC_PAGE_AUTHORS | SYS_C002087208 |
STATIC_PAGE_INDEX_EXCLUSION | SYS_C002087217 |
COMMENTS | SYS_C002087225 |
LINKS | SYS_C002087234 |
LINK_KILL_PATTERNS | SYS_C002087240 |
USER_CONTENT_MAP | SYS_C002087245 |
QUERY_STRINGS | SYS_C002087255 |
EMAIL_LOG | SYS_C002087259 |
USER_USER_BOZO_FILTER | SYS_C002087271 |
USER_USER_BOZO_FILTER | SYS_C002087272 |
USER_GROUPS | SYS_C002087308 |
USER_GROUPS | SYS_C002087309 |
USER_GROUP_MAP | SYS_C002087318 |
USER_GROUP_MAP | SYS_C002087319 |
USER_GROUP_MAP_QUEUE | SYS_C002087322 |
USER_GROUP_ROLES | SYS_C002087329 |
USER_GROUP_ACTIONS | SYS_C002087336 |
USER_GROUP_ACTION_ROLE_MAP | SYS_C002087345 |
USER_GROUP_MEMBER_FIELD_MAP | SYS_C002087363 |
GROUP_MEMBER_EMAIL_PREFERENCES | SYS_C002087374 |
GROUP_SPAM_HISTORY | SYS_C002087382 |
SEC_SESSIONS | SYS_C002087388 |
SEC_LOGIN_TOKENS | SYS_C002087393 |
CONTENT_SECTIONS | SYS_C002087417 |
GENERAL_PERMISSIONS | SYS_C002087440 |
NEWS_ITEMS | SYS_C002087461 |
NEWS_ITEMS | SYS_C002087462 |
CALENDAR_CATEGORIES | SYS_C002087470 |
CALENDAR | SYS_C002087486 |
BBOARD_TOPICS | SYS_C002087516 |
BBOARD_BOZO_PATTERNS | SYS_C002087529 |
BBOARD | SYS_C002087540 |
BBOARD_EMAIL_ALERTS | SYS_C002087545 |
BBOARD_THREAD_EMAIL_ALERTS | SYS_C002087549 |
BBOARD_UNIFIED | SYS_C002087559 |
AD_DOMAINS | SYS_C002087570 |
CLASSIFIED_ADS | SYS_C002087585 |
CLASSIFIED_AUCTION_BIDS | SYS_C002087591 |
CLASSIFIED_EMAIL_ALERTS | SYS_C002087599 |
CONTEST_DOMAINS | SYS_C002087610 |
CSS_SIMPLE | SYS_C002087622 |
CSS_COMPLETE | SYS_C002087631 |
PAGE_LOGOS | SYS_C002087641 |
DOWNLOADS | SYS_C002087655 |
DOWNLOAD_VERSIONS | SYS_C002087665 |
DOWNLOAD_LOG | SYS_C002087678 |
ADV_USER_MAP | SYS_C002087689 |
QUERIES | SYS_C002087709 |
STOLEN_REGISTRY | SYS_C002087730 |
SPAM_HISTORY | SYS_C002087736 |
SPAM_HISTORY | SYS_C002087737 |
N_TO_N_PRIMARY_CATEGORIES | SYS_C002087745 |
NEIGHBOR_TO_NEIGHBOR | SYS_C002087761 |
NEIGHBOR_TO_NEIGHBOR_AUDIT | SYS_C002087765 |
ADDRESS_BOOK | SYS_C002087768 |
CHAT_MSGS | SYS_C002087791 |
CHAT_MSGS | SYS_C002087792 |
CONTENT_TAGS | SYS_C002087797 |
NAUGHTY_EVENTS | SYS_C002087800 |
GLOSSARY | SYS_C002087810 |
USERS_PAYMENT | SYS_C002087816 |
USERS_ORDERS | SYS_C002087823 |
USERS_CHARGES | SYS_C002087828 |
USERS_CHARGES | SYS_C002087829 |
FS_FILES | SYS_C002087848 |
FS_VERSIONS | SYS_C002087855 |
BM_LIST | SYS_C002087869 |
GENERAL_COMMENTS | SYS_C002087882 |
GENERAL_LINKS | SYS_C002087893 |
GENERAL_LINKS | SYS_C002087894 |
GENERAL_LINKS | SYS_C002087895 |
SITE_WIDE_LINK_MAP | SYS_C002087906 |
SITE_WIDE_LINK_MAP | SYS_C002087907 |
SITE_WIDE_LINK_MAP | SYS_C002087908 |
GENERAL_LINK_USER_RATINGS | SYS_C002087914 |
TICKET_PROJECTS | SYS_C002087946 |
TICKET_DOMAINS | SYS_C002087962 |
TICKET_DOMAINS | SYS_C002087963 |
TICKET_DOMAIN_PROJECT_MAP | SYS_C002087971 |
TICKET_ASSIGNMENTS | SYS_C002087977 |
TICKET_ISSUES_I | SYS_C002087990 |
TICKET_ISSUES_I | SYS_C002087998 |
TICKET_ISSUES_I | SYS_C002087999 |
TICKET_EMAIL_ALERTS | SYS_C002088016 |
TICKET_ISSUE_ASSIGNMENTS | SYS_C002088025 |
TICKET_ISSUE_NOTIFICATIONS | SYS_C002088032 |
PORTAL_TABLES | SYS_C002088035 |
PORTAL_PAGES | SYS_C002088038 |
PORTAL_TABLES_AUDIT | SYS_C002088044 |
USER_CUSTOM | SYS_C002088062 |
USER_CURRICULUM_MAP | SYS_C002088071 |
PRESS | SYS_C002088087 |
WP_STYLES | SYS_C002088118 |
WP_PRESENTATIONS | SYS_C002088134 |
WP_USER_ACCESS_TICKET | SYS_C002088179 |
POLL_USER_CHOICES | SYS_C002088196 |
EVENT_INFO | SYS_C002088199 |
EVENTS_ACTIVITIES | SYS_C002088207 |
EVENTS_ACTIVITIES | SYS_C002088208 |
EVENTS_EVENTS | SYS_C002088232 |
EVENTS_ORDERS | SYS_C002088274 |
EVENTS_REGISTRATIONS | SYS_C002088287 |
EVENTS_FILE_STORAGE | SYS_C002088292 |
USERS_HOMEPAGES | SYS_C002088297 |
USERS_SPECIAL_QUOTAS | SYS_C002088302 |
USERS_CONTENT_TYPES | SYS_C002088307 |
USERS_FILES | SYS_C002088319 |
USERS_FILES_ACCESS_LOG | SYS_C002088326 |
IM_CUSTOMERS | SYS_C002088351 |
IM_PROJECTS | SYS_C002088369 |
IM_PROJECTS | SYS_C002088370 |
IM_EMPLOYEE_INFO | SYS_C002088396 |
IM_EMPLOYEE_INFO | SYS_C002088397 |
IM_EMPLOYEE_INFO | SYS_C002088398 |
IM_EMPLOYEE_INFO | SYS_C002088399 |
IM_EMPLOYEE_INFO | SYS_C002088400 |
IM_HOURS | SYS_C002088410 |
IM_FACILITIES | SYS_C002088414 |
IM_EMPLOYEE_PERCENTAGE_TIME | SYS_C002088433 |
IM_PROJECT_PAYMENTS | SYS_C002088442 |
IM_PROJECT_PAYMENTS_AUDIT | SYS_C002088450 |
IM_ALLOCATIONS | SYS_C002088459 |
IM_ALLOCATIONS | SYS_C002088461 |
IM_ALLOCATIONS_AUDIT | SYS_C002088469 |
IM_ALLOCATIONS_AUDIT | SYS_C002088471 |
IM_PROCEDURES | SYS_C002088484 |
IM_PROCEDURES | SYS_C002088485 |
IM_PROCEDURE_USERS | SYS_C002088492 |
IM_PROCEDURE_USERS | SYS_C002088493 |
IM_PROCEDURE_EVENTS | SYS_C002088501 |
IM_PROCEDURE_EVENTS | SYS_C002088502 |
IM_EMP_CHECKPOINT_CHECKOFFS | SYS_C002088510 |
IM_EMP_CHECKPOINT_CHECKOFFS | SYS_C002088511 |
IM_EMPLOYEE_PIPELINE | SYS_C002088514 |
IM_EMPLOYEE_PIPELINE | SYS_C002088522 |
IM_EMPLOYEE_PIPELINE | SYS_C002088523 |
INTRANET_TASK_BOARD | SYS_C002088528 |
SURVSIMP_SURVEYS | SYS_C002088561 |
SURVSIMP_QUESTIONS | SYS_C002088574 |
SURVSIMP_RESPONSES | SYS_C002088587 |
MANUALS | SYS_C002088622 |
MANUAL_SECTIONS | SYS_C002088635 |
MANUAL_SECTIONS | SYS_C002088636 |
WAP_USER_AGENTS | WAP_USER_AGT_CREATE_USER_FK |
WAP_USER_AGENTS | WAP_USER_AGT_DELETE_USER_FK |
Name: GUESS_EMAIL_PREF_TR |
---|
CREATE TRIGGER guess_email_pref_tr AFTER INSERT ON users FOR each row REFERENCING NEW AS NEW OLD AS OLD BEGIN UPDATE users_preferences set email_type = guess_user_email_type(:new.email) where user_id = :new.user_id; IF SQL%NOTFOUND THEN INSERT INTO users_preferences (user_id, email_type) VALUES (:new.user_id, guess_user_email_type(:new.email)); END IF; END; |
Name: USERS_UPDATE_LOGIN_TOKEN |
---|
CREATE TRIGGER users_update_login_token before update on users for each row REFERENCING NEW AS NEW OLD AS OLD begin delete from sec_login_tokens where user_id = :new.user_id and password != :new.password; end; |