WEB_USER_PERSONAL_INFO
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| WEB_USER_ID | NUMBER(38) | N | | |
| PREFIX | VARCHAR2(12) | N | ' '
| |
| FIRST_NAMES | VARCHAR2(128) | N | | |
| LAST_NAME | VARCHAR2(128) | N | | |
| GENQUAL | VARCHAR2(12) | Y | | |
| PARENT_COMPANY | VARCHAR2(128) | Y | | |
| COMPANY | VARCHAR2(128) | Y | | |
| TITLE | VARCHAR2(128) | Y | | |
| PHONE | VARCHAR2(128) | Y | | |
| FAX | VARCHAR2(128) | Y | | |
| EMAIL | VARCHAR2(128) | Y | | |
| EMAIL_UC | VARCHAR2(128) | Y | | |
| PIN | NUMBER(38) | Y | | |
| CREATED | DATE | N | (sysdate)
| |
| MODIFIED | DATE | N | (sysdate)
| |
| FIRST_NAMES_OL | VARCHAR2(128) | Y | | |
| LAST_NAME_OL | VARCHAR2(128) | Y | | |
| GENQUAL_OL | VARCHAR2(12) | Y | | |
| PARENT_COMPANY_OL | VARCHAR2(128) | Y | | |
| COMPANY_OL | VARCHAR2(128) | Y | | |
| TITLE_OL | VARCHAR2(128) | Y | | |
Foreign Keys:
Options:
| Option | Settings |
|---|
| Tablespace | DATA_TBS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
Indexes:
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|
| WUPI_EMAIL_UC_IDX | NORMAL | NONUNIQUE | EMAIL_UC
| DDL script |
Triggers
WEB_USER_PI_TIMESTAMP
Legend: string keyword reserved word operator
CREATE TRIGGER
web_user_pi_timestamp
BEFORE INSERT OR UPDATE ON web_user_personal_info
FOR EACH ROW
REFERENCING NEW AS NEW OLD AS OLD
BEGIN
:new.modified := sysdate;
END;