| 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;
|