Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNACTIONCONFIGFILENAME

DDL script

Columns

NameTypeNullableDefault valueComment
ACTION_IDNUMBER(38)N  
SERVER_IDNUMBER(38)N  
CONFIG_FILE_NAME_IDNUMBER(38)N  
CONFIG_REVISION_IDNUMBER(38)Y  
FAILURE_IDNUMBER(38)Y  
CREATEDTIMESTAMP(6) WITH LOCAL TIME ZONEN(current_timestamp)  
MODIFIEDTIMESTAMP(6) WITH LOCAL TIME ZONEN(current_timestamp)  

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_ACTIONCF_FAILURE_ID_FKFAILURE_ID RHNCONFIGFILEFAILURE RHN_CONFFILE_FAIL_ID_PK NO ACTION
RHN_ACTIONCF_NAME_AID_SID_FKSERVER_ID , ACTION_ID RHNSERVERACTION RHN_SERVER_ACTION_SID_AID_UQ CASCADE
RHN_ACTIONCF_NAME_CFNID_FKCONFIG_FILE_NAME_ID RHNCONFIGFILENAME RHN_CFNAME_ID_PK NO ACTION
RHN_ACTIONCF_NAME_CRID_FKCONFIG_REVISION_ID RHNCONFIGREVISION RHN_CONFREVISION_ID_PK SET NULL

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_ACTIONCF_NAME_ASC_UQNORMALUNIQUEACTION_ID , SERVER_ID , CONFIG_FILE_NAME_ID DDL script
RHN_ACTIONCF_NAME_SID_IDXNORMALNONUNIQUESERVER_ID DDL script
RHN_ACT_CNFG_FN_CRID_IDXNORMALNONUNIQUECONFIG_REVISION_ID DDL script

Triggers

RHN_ACTIONCF_NAME_MOD_TRIG

Legend: comment string keyword reserved word operator
CREATE TRIGGER 
rhn_actioncf_name_mod_trig
before insert or update on rhnActionConfigFileName
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
	:new.modified := current_timestamp;
end;