Spacewalk DB Schema - Table-RHNACTION

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

RHNACTION

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	N
ACTION_TYPE	NUMBER(38)	N
NAME	VARCHAR2(128)	Y
SCHEDULER	NUMBER(38)	Y
EARLIEST_ACTION	TIMESTAMP(6) WITH LOCAL TIME ZONE	N
VERSION	NUMBER(38)	N	(0)
ARCHIVED	NUMBER(38)	N	(0)
PREREQUISITE	NUMBER(38)	Y
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
RHN_ACTION_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_ACTION_ARCHIVED_CK	archived in (0, 1)

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_ACTION_AT_FK	ACTION_TYPE	RHNACTIONTYPE	RHN_ACTION_TYPE_PK	NO ACTION
RHN_ACTION_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE
RHN_ACTION_PREREQ_FK	PREREQUISITE	RHNACTION	RHN_ACTION_PK	CASCADE
RHN_ACTION_SCHEDULER_FK	SCHEDULER	WEB_CONTACT	WEB_CONTACT_PK	SET NULL

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_ACTION_OID_IDX	NORMAL	NONUNIQUE	ORG_ID	DDL script
RHN_ACTION_PK	NORMAL	UNIQUE	ID	DDL script
RHN_ACTION_PREREQ_ID_IDX	NORMAL	NONUNIQUE	PREREQUISITE , ID	DDL script
RHN_ACTION_SCHEDULER_IDX	NORMAL	NONUNIQUE	SCHEDULER	DDL script

Referenced by:

Table	Constraint
RHNACTIONCHAINENTRY	RHN_ACTCHAINENT_AID_FK
RHNACTIONCONFIGCHANNEL	RHN_ACTIONCC_AID_FK
RHNACTIONCONFIGDATE	RHN_ACTIONCD_AID_FK
RHNACTIONCONFIGDATEFILE	RHN_ACTIONCD_FILE_AID_FK
RHNACTIONCONFIGREVISION	RHN_ACTIONCR_AID_FK
RHNACTIONDAEMONCONFIG	RHN_ACTIONDC_AID_FK
RHNACTIONKICKSTART	RHN_ACTIONKS_AID_FK
RHNACTIONKICKSTARTGUEST	RHN_ACTIONKS_XENGUEST_AID_FK
RHNACTION	RHN_ACTION_PREREQ_FK
RHNACTIONSCRIPT	RHN_ACTSCRIPT_AID_FK
RHNACTIONERRATAUPDATE	RHN_ACT_EU_ACT_FK
RHNACTIONIMAGEDEPLOY	RHN_ACT_IDP_ACT_FK
RHNACTIONPACKAGEDELTA	RHN_ACT_PD_AID_FK
RHNACTIONPACKAGE	RHN_ACT_P_ACT_FK
RHNACTIONSCAP	RHN_ACT_SCAP_ACT_FK
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_AID_FK
RHNACTIONVIRTVCPU	RHN_AVCPU_AID_FK
RHNACTIONVIRTDESTROY	RHN_AVD_AID_FK
RHNACTIONVIRTREBOOT	RHN_AVREBOOT_AID_FK
RHNACTIONVIRTREFRESH	RHN_AVREFRESH_AID_FK
RHNACTIONVIRTRESUME	RHN_AVRESUME_AID_FK
RHNACTIONVIRTSHUTDOWN	RHN_AVSHUTDOWN_AID_FK
RHNACTIONVIRTSETMEMORY	RHN_AVSM_AID_FK
RHNACTIONVIRTSCHEDULEPOLLER	RHN_AVSP_AID_FK
RHNACTIONVIRTSUSPEND	RHN_AVSUSPEND_AID_FK
RHNKICKSTARTSESSIONHISTORY	RHN_KS_SESSIONHIST_AID_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_AID_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_AID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_AID_FK
RHNSERVERACTION	RHN_SERVER_ACTION_AID_FK

Triggers

RHN_ACTION_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_action_mod_trig
before insert or update on rhnAction
for each row

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