Spacewalk DB Schema - Table-RHNSERVER

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Sanity Check Index DDL scrips

Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

RHNSERVER

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	N
DIGITAL_SERVER_ID	VARCHAR2(64)	N
SERVER_ARCH_ID	NUMBER(38)	N
OS	VARCHAR2(64)	N
RELEASE	VARCHAR2(64)	N
NAME	VARCHAR2(128)	Y
DESCRIPTION	VARCHAR2(256)	Y
INFO	VARCHAR2(128)	Y
SECRET	VARCHAR2(32)	N
CREATOR_ID	NUMBER(38)	Y
AUTO_DELIVER	CHAR(1)	N	'N'
AUTO_UPDATE	CHAR(1)	N	'N'
RUNNING_KERNEL	VARCHAR2(64)	Y
LAST_BOOT	NUMBER(38)	N	0
PROVISION_STATE_ID	NUMBER(38)	Y
CHANNELS_CHANGED	DATE	Y
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)

Primary key:

Constraint Name	Columns
RHN_SERVER_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_SERVER_DELIVER_CK	auto_deliver in ('Y', 'N')
RHN_SERVER_UPDATE_CK	auto_update in ('Y', 'N')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_SERVER_CREATOR_FK	CREATOR_ID	WEB_CONTACT	WEB_CONTACT_PK	SET NULL
RHN_SERVER_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE
RHN_SERVER_PSID_FK	PROVISION_STATE_ID	RHNPROVISIONSTATE	RHN_PROVSTATE_ID_PK	NO ACTION
RHN_SERVER_SAID_FK	SERVER_ARCH_ID	RHNSERVERARCH	RHN_SARCH_ID_PK	NO ACTION

Options:

Option	Settings
Tablespace	DATA_TBS
Index Organized	No
Generated by Oracle	No
Clustered	No
Nested	No
Temporary	No

Indexes:

Index Name	Type	Unuqueness	Columns	DDL script
RHN_SERVER_CREATED_ID_IDX	NORMAL	NONUNIQUE	CREATED , ID	DDL script
RHN_SERVER_CREATOR_IDX	NORMAL	NONUNIQUE	CREATOR_ID	DDL script
RHN_SERVER_DSID_UQ	NORMAL	UNIQUE	DIGITAL_SERVER_ID	DDL script
RHN_SERVER_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_SERVER_OID_ID_IDX	NORMAL	NONUNIQUE	ORG_ID , ID	DDL script

Referenced by:

Table	Constraint
RHNACTIONCONFIGCHANNEL	RHN_ACTIONCC_SID_FK
RHNACTIONCONFIGREVISION	RHN_ACTIONCR_SID_FK
RHNAPPINSTALLSESSION	RHN_APPINST_SESSION_SID_FK
RHNACTIONPACKAGEREMOVALFAILURE	RHN_APR_FAILURE_SID_FK
RHNCHANNELFAMILYLICENSECONSENT	RHN_CFL_CONSENT_SID_FK
RHN_CHECK_PROBE	RHN_CHKPB_HOST_ID_FK
RHNCLIENTCAPABILITY	RHN_CLIENTCAP_SID_FK
RHNCPU	RHN_CPU_SERVER_FK
RHNDEVICE	RHN_DEVICE_SID_FK
RHN_SERVER_MONITORING_INFO	RHN_HOST_SERVER_ID_FK
RHN_HOST_PROBE	RHN_HSTPB_HOST_ID_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_HSID_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_NSID_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_OSID_FK
RHNMONITOR	RHN_MONITOR_SID_FK
RHNPROXYINFO	RHN_PROXY_INFO_SID_FK
RHNRAM	RHN_RAM_SERVER_FK
RHNREGTOKEN	RHN_REG_TOKEN_SID_FK
RHNSERVERACTIONVERIFYMISSING	RHN_SACTIONVM_SID_FK
RHNSERVERACTIONVERIFYRESULT	RHN_SACTIONVR_SID_FK
RHNSERVERACTIONPACKAGERESULT	RHN_SAP_RESULT_SID_FK
RHNSATELLITEINFO	RHN_SATELLITE_INFO_SID_FK
RHN_SAT_NODE	RHN_SATND_SID_FK
RHNSATELLITECHANNELFAMILY	RHN_SAT_CF_SID_FK
RHNSERVERCUSTOMDATAVALUE	RHN_SCDV_SID_FK
RHNSERVERCHANNEL	RHN_SC_SID_FK
RHNSNPSERVERQUEUE	RHN_SEC_NP_SID_FK
RHNSERVERACTIONSCRIPTRESULT	RHN_SERVERAS_RESULT_SID_FK
RHNSERVERCONFIGCHANNEL	RHN_SERVERCC_SID_FK
RHNSERVERHISTORY	RHN_SERVERHISTORY_SID_FK
RHNSERVERLOCATION	RHN_SERVERLOCATION_SID_FK
RHNSERVERNETWORK	RHN_SERVERNETWORK_SID_FK
RHNSERVERNOTES	RHN_SERVERNOTES_SID_FK
RHNSERVERPACKAGE	RHN_SERVERPACKAGE_SID_FK
RHNSERVERPATH	RHN_SERVERPATH_PSID_FK
RHNSERVERPATH	RHN_SERVERPATH_SID_FK
RHNSERVERPRESERVEFILELIST	RHN_SERVERPFL_KSID_FK
RHNSERVERACTION	RHN_SERVER_ACTION_SID_FK
RHNSERVERCACHEINFO	RHN_SERVER_CACHE_INFO_SID_FK
RHNSERVERDMI	RHN_SERVER_DMI_SID_FK
RHNSERVERINFO	RHN_SERVER_INFO_SID_FK
RHNSERVERINSTALLINFO	RHN_SERVER_INSTALL_INFO_SID_FK
RHNSERVERLOCK	RHN_SERVER_LOCK_SID_FK
RHNSERVERUUID	RHN_SERVER_UUID_SID_FK
RHNSERVEREVENT	RHN_SE_SERVER_ID_FK
RHNSERVERGROUPMEMBERS	RHN_SG_MEMBERS_FK
RHNSERVERMESSAGE	RHN_SM_SERVER_ID_FK
RHNSNAPSHOT	RHN_SNAPSHOT_SID_FK
RHNSERVERNEEDEDPACKAGECACHE	RHN_SNCP_SID_FK
RHNSERVERNEEDEDERRATACACHE	RHN_SNEC_SID_FK
RHNSOLARISPATCHEDPACKAGE	RHN_SOLARIS_PATCHEDP_SID_FK
RHNSERVERNETINTERFACE	RHN_SRV_NET_IFACE_SID_FK
RHNSERVERTOKENREGS	RHN_SRV_REG_TOK_SID_FK
RHNSNAPSHOTTAG	RHN_ST_SID_FK
RHNTRANSACTION	RHN_TRANS_SID_FK
RHNUSERSERVERPREFS	RHN_USERSERVERPREFS_SID_FK
RHNUSERSERVERPERMS	RHN_USPERMS_SID_FK
RHNVIRTUALINSTANCE	RHN_VI_HSI_FK
RHNVIRTUALINSTANCE	RHN_VI_VSI_FK

Triggers

RHN_SERVER_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_server_mod_trig
before insert or update on rhnServer
for each row

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