WEB_CUSTOMER
DDL scriptColumns
| Name | Type | Nullable | Default value | Comment |
|---|
| ID | NUMBER(38) | N | | |
| NAME | VARCHAR2(128) | N | | |
| CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
| MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
Primary key:
| Constraint Name | Columns |
|---|
| WEB_CUSTOMER_ID_PK | ID
|
Options:
| Option | Settings |
|---|
| Tablespace | USERS |
| Index Organized | No |
| Generated by Oracle | No |
| Clustered | No |
| Nested | No |
| Temporary | No |
Indexes:
| Index Name | Type | Unuqueness | Columns | DDL script |
|---|
| WEB_CUSTOMER_ID_PK | NORMAL | UNIQUE | ID
| DDL script |
| WEB_CUSTOMER_NAME_UQ_IDX | NORMAL | UNIQUE | NAME
| DDL script |
Referenced by:
Triggers
WEB_CUSTOMER_INSERT_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
web_customer_insert_trig
after insert on web_customer
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
insert into rhnOrgConfiguration (org_id) values (:new.id);
insert into rhnOrgAdminManagement (org_id) values (:new.id);
end;
WEB_CUSTOMER_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
web_customer_mod_trig
before insert or update on web_customer
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.modified := current_timestamp;
end;