Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SERVERAS_RESULT_ASID_FK | ACTION_SCRIPT_ID | RHNACTIONSCRIPT | RHN_ACTSCRIPT_ID_PK | CASCADE |
RHN_SERVERAS_RESULT_SID_FK | SERVER_ID | RHNSERVER | RHN_SERVER_ID_PK | NO ACTION |
Option | Settings |
---|---|
Tablespace | USERS |
Index Organized | No |
Generated by Oracle | No |
Clustered | No |
Nested | No |
Temporary | No |
Index Name | Type | Unuqueness | Columns | DDL script |
---|---|---|---|---|
RHN_SERVERAS_RESULT_ASID_IDX | NORMAL | NONUNIQUE | ACTION_SCRIPT_ID | DDL script |
RHN_SERVERAS_RESULT_SAS_UQ | NORMAL | UNIQUE | SERVER_ID , ACTION_SCRIPT_ID | DDL script |
SYS_IL0000020793C00003$$ | LOB | UNIQUE | DDL script |
Legend: comment string keyword reserved word operator
CREATE TRIGGER rhn_serveras_result_mod_trig before insert or update on rhnServerActionScriptResult for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modified := current_timestamp; end;