WEB_USER_SITE_INFO
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| ID | NUMBER(38) | N | | |
| WEB_USER_ID | NUMBER(38) | Y | | |
| EMAIL | VARCHAR2(128) | Y | | |
| EMAIL_UC | VARCHAR2(128) | Y | | |
| ALT_FIRST_NAMES | VARCHAR2(128) | Y | | |
| ALT_LAST_NAME | VARCHAR2(128) | Y | | |
| ADDRESS1 | VARCHAR2(128) | N | | |
| ADDRESS2 | VARCHAR2(128) | Y | | |
| ADDRESS3 | VARCHAR2(128) | Y | | |
| ADDRESS4 | VARCHAR2(128) | Y | | |
| CITY | VARCHAR2(128) | N | | |
| STATE | VARCHAR2(64) | Y | | |
| ZIP | VARCHAR2(64) | Y | | |
| COUNTRY | CHAR(2) | N | | |
| PHONE | VARCHAR2(32) | Y | | |
| FAX | VARCHAR2(32) | Y | | |
| URL | VARCHAR2(128) | Y | | |
| IS_PO_BOX | CHAR(1) | Y | ('0')
| |
| TYPE | CHAR(1) | Y | | |
| ORACLE_SITE_ID | VARCHAR2(32) | Y | | |
| NOTES | VARCHAR2(2000) | Y | | |
| CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | (current_timestamp) | |
| MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | Y | (current_timestamp) | |
| ALT_FIRST_NAMES_OL | VARCHAR2(128) | Y | | |
| ALT_LAST_NAME_OL | VARCHAR2(128) | Y | | |
| ADDRESS1_OL | VARCHAR2(128) | Y | | |
| ADDRESS2_OL | VARCHAR2(128) | Y | | |
| ADDRESS3_OL | VARCHAR2(128) | Y | | |
| CITY_OL | VARCHAR2(128) | Y | | |
| STATE_OL | VARCHAR2(32) | Y | | |
| ZIP_OL | VARCHAR2(32) | Y | | |
Primary key:
| Constraint Name | Columns |
|---|
| WUSI_ID_PK | ID
|
Check Constraints:
| Constraint Name | Check Condition |
|---|
| WUSI_IPB_CK | is_po_box in ('1','0') |
Foreign Keys:
Options:
| Option | Settings |
|---|
| Tablespace | USERS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
Indexes:
Triggers
WEB_USER_SI_TIMESTAMP
Legend: string keyword reserved word operator
CREATE TRIGGER
web_user_si_timestamp
before insert or update on web_user_site_info
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.email_uc := upper(:new.email);
:new.modified := current_timestamp;
end;