Constraint Name | Columns | Referenced table | Referenced Constraint | On Delete Rule |
---|---|---|---|---|
RHN_SACTIONVR_AID_FK | ACTION_ID | RHNACTION | RHN_ACTION_PK | CASCADE |
RHN_SACTIONVR_PAID_FK | PACKAGE_ARCH_ID | RHNPACKAGEARCH | RHN_PARCH_ID_PK | NO ACTION |
RHN_SACTIONVR_PCID_FK | PACKAGE_CAPABILITY_ID | RHNPACKAGECAPABILITY | RHN_PKG_CAPABILITY_ID_PK | NO ACTION |
RHN_SACTIONVR_PEID_FK | PACKAGE_EVR_ID | RHNPACKAGEEVR | RHN_PE_ID_PK | NO ACTION |
RHN_SACTIONVR_PNID_FK | PACKAGE_NAME_ID | RHNPACKAGENAME | RHN_PN_ID_PK | NO ACTION |
RHN_SACTIONVR_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_SACTIONVR_SANEC_UQ | NORMAL | UNIQUE | SERVER_ID , ACTION_ID , PACKAGE_NAME_ID , PACKAGE_EVR_ID , PACKAGE_ARCH_ID , PACKAGE_CAPABILITY_ID | DDL script |
Legend: comment string keyword reserved word operator
CREATE TRIGGER rhn_sactionvr_mod_trig before insert or update on rhnServerActionVerifyResult for each row REFERENCING NEW AS NEW OLD AS OLD begin :new.modified := current_timestamp; end;