Spacewalk DB Schema - Table-RHN_SAT_NODE

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_NODE

Description:

satnd satellite node

Columns

Name	Type	Nullable	Default value	Comment
RECID	NUMBER(12)	N
SERVER_ID	NUMBER(38)	Y
TARGET_TYPE	VARCHAR2(10)	N	'node'
LAST_UPDATE_USER	VARCHAR2(40)	Y
LAST_UPDATE_DATE	DATE	Y
MAC_ADDRESS	VARCHAR2(17)	N
MAX_CONCURRENT_CHECKS	NUMBER(4)	Y
SAT_CLUSTER_ID	NUMBER(12)	N
IP	VARCHAR2(15)	Y
SCHED_LOG_LEVEL	NUMBER(4)	N	(0)
SPUT_LOG_LEVEL	NUMBER(4)	N	(0)
DQ_LOG_LEVEL	NUMBER(4)	N	(0)
SCOUT_SHARED_KEY	VARCHAR2(64)	N

Primary key:

Constraint Name	Columns
RHN_SATND_RECID_PK	RECID

Check Constraints:

Constraint Name	Check Condition
RHN_SATND_TARGET_TYPE_CK	target_type in ('node')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_SATND_CMDTG_RID_TAR_TY_FK	RECID , TARGET_TYPE	RHN_COMMAND_TARGET	RHN_CMDTG_RECID_TARGET_TYPE_PK	CASCADE
RHN_SATND_SATCL_SAT_CL_ID_FK	SAT_CLUSTER_ID	RHN_SAT_CLUSTER	RHN_SATCL_RECID_PK	CASCADE
RHN_SATND_SID_FK	SERVER_ID	RHNSERVER	RHN_SERVER_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_SATND_RECID_PK	NORMAL	UNIQUE	RECID	DDL script
RHN_SAT_NODE_SCID_IDX	NORMAL	NONUNIQUE	SAT_CLUSTER_ID	DDL script
RHN_SAT_NODE_SID_IDX	NORMAL	NONUNIQUE	SERVER_ID	DDL script

Referenced by:

Table	Constraint
RHN_SAT_NODE_PROBE	RHN_SNDPB_SATND_SAT_ND_ID_FK