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 | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
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 | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Indexes:
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 := current_timestamp;
END;