Spacewalk DB Schema - Table-RHN_SAT_CLUSTER

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

RHN_SAT_CLUSTER

Description:

satcl satellite cluster

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
TARGET_TYPE	VARCHAR2(10)	N	'cluster'
CUSTOMER_ID	NUMBER(12)	N
DESCRIPTION	VARCHAR2(255)	N
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y
PHYSICAL_LOCATION_ID	NUMBER(12)	N
PUBLIC_KEY	VARCHAR2(2000)	Y
VIP	VARCHAR2(15)	Y
DEPLOYED	CHAR(1)	N	'0'
PEM_PUBLIC_KEY	VARCHAR2(2000)	Y
PEM_PUBLIC_KEY_HASH	VARCHAR2(20)	Y

Primary key:

Constraint Name	Columns
RHN_SATCL_RECID_PK	RECID

Check Constraints:

Constraint Name	Check Condition
RHN_SATCL_DEPLOYED_CK	deployed in ('0','1')
RHN_SATCL_TARGET_TYPE_CK	target_type in ('cluster')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_SATCL_CMDTG_RECID_TAR_FK	RECID , TARGET_TYPE	RHN_COMMAND_TARGET	RHN_CMDTG_RECID_TARGET_TYPE_PK	CASCADE
RHN_SATCL_CSTMR_CUSTOMER_ID_FK	CUSTOMER_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	NO ACTION
RHN_SATCL_PHSLC_PHYS_LOC_FK	PHYSICAL_LOCATION_ID	RHN_PHYSICAL_LOCATION	RHN_PHSLC_RECID_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_SATCL_CID_IDX	NORMAL	NONUNIQUE	CUSTOMER_ID	DDL script
RHN_SATCL_RECID_PK	NORMAL	UNIQUE	RECID	DDL script

Referenced by:

Table	Constraint
RHN_CHECK_PROBE	RHN_CHKPB_SATCL_SAT_CL_ID_FK
RHN_CONTACT_METHODS	RHN_CMETH_SENDER_SAT_CLUS_FK
RHN_HOST_PROBE	RHN_HSTPB_SATCL_ID_FK
RHN_LL_NETSAINT	RHN_LLNTS_SAT_CLUSTER_IDFK
RHN_SAT_NODE	RHN_SATND_SATCL_SAT_CL_ID_FK
RHN_SAT_CLUSTER_PROBE	RHN_SCLPB_SATCL_SAT_CL_ID_FK
RHN_SNMP_ALERT	RHN_SNMP_ALERT_SAT_CLUSTER_FK