RHNUSERRESERVED
DDL scriptColumns
Name | Type | Nullable | Default value | Comment |
---|
LOGIN | VARCHAR2(64) | N | | |
LOGIN_UC | VARCHAR2(64) | N | | |
PASSWORD | VARCHAR2(38) | N | | |
CREATED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
MODIFIED | TIMESTAMP(6) WITH LOCAL TIME ZONE | N | (current_timestamp) | |
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 |
---|
RHN_USER_RES_LOGIN_UC_UQ | NORMAL | UNIQUE | LOGIN_UC
| DDL script |
Triggers
RHN_USER_RES_MOD_TRIG
Legend: string keyword reserved word operator
CREATE TRIGGER
rhn_user_res_mod_trig
before insert or update on rhnUserreserved
for each row
REFERENCING NEW AS NEW OLD AS OLD
begin
:new.login_uc := upper(:new.login);
:new.modified := current_timestamp;
end;