Spacewalk DB Schema - Table-RHNKSDATA

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

RHNKSDATA

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
KS_TYPE	VARCHAR2(8)	N
ORG_ID	NUMBER(38)	N
IS_ORG_DEFAULT	CHAR(1)	N	('N')
LABEL	VARCHAR2(64)	N
COMMENTS	VARCHAR2(4000)	Y
ACTIVE	CHAR(1)	N	('Y')
POSTLOG	CHAR(1)	N	('N')
PRELOG	CHAR(1)	N	('N')
KSCFG	CHAR(1)	N	('N')
COBBLER_ID	VARCHAR2(64)	Y
PRE	BLOB	Y
POST	BLOB	Y
NOCHROOT_POST	BLOB	Y
PARTITION_DATA	BLOB	Y
STATIC_DEVICE	VARCHAR2(32)	Y
KERNEL_PARAMS	VARCHAR2(128)	Y
VERBOSEUP2DATE	CHAR(1)	N	('N')
NONCHROOTPOST	CHAR(1)	N	('N')
NO_BASE	CHAR(1)	N	('N')
IGNORE_MISSING	CHAR(1)	N	('N')
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
UPDATE_TYPE	VARCHAR2(7)	N	('none')

Primary key:

Constraint Name	Columns
RHN_KS_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_KS_ACTIVE_CK	active in ('Y','N')
RHN_KS_CFG_SAVE_CK	kscfg in ('Y','N')
RHN_KS_DEFAULT_CK	is_org_default in ('Y','N')
RHN_KS_IGNORE_MISSING_CK	ignore_missing in ( 'Y' , 'N' )
RHN_KS_NOBASE_CK	no_base in ( 'Y' , 'N' )
RHN_KS_NONCHROOT_POST_CK	nonchrootpost in ('Y','N')
RHN_KS_POST_LOG_CK	postLog in ('Y','N')
RHN_KS_PRE_LOG_CK	preLog in ('Y','N')
RHN_KS_TYPE_CK	ks_type in ('wizard','raw')
RHN_KS_UPDATE_TYPE	update_type in ('all', 'red_hat', 'none')
RHN_KS_VERBOSE_UP2DATE_CK	verboseup2date in ('Y','N')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_KS_OID_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	CASCADE

Unique Keys:

Constraint name	Columns
RHN_KS_OID_LABEL_UQ	ORG_ID , LABEL

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_KS_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_KS_OID_LABEL_ID_IDX	NORMAL	NONUNIQUE	ORG_ID , LABEL , ID	DDL script
SYS_IL0000020233C00012$$	LOB	UNIQUE		DDL script
SYS_IL0000020233C00013$$	LOB	UNIQUE		DDL script
SYS_IL0000020233C00014$$	LOB	UNIQUE		DDL script
SYS_IL0000020233C00015$$	LOB	UNIQUE		DDL script

Referenced by:

Table	Constraint
RHNCRYPTOKEYKICKSTART	RHN_CKEY_KS_KSD_FK
RHNKICKSTARTCOMMAND	RHN_KSCOMMAND_KSID_FK
RHNKICKSTARTDEFAULTREGTOKEN	RHN_KSDRT_KSID_FK
RHNKICKSTARTDEFAULTS	RHN_KSD_KSID_FK
RHNKICKSTARTIPRANGE	RHN_KSIP_KSID_FK
RHNKICKSTARTPACKAGE	RHN_KSPACKAGE_KSID_FK
RHNKICKSTARTPRESERVEFILELIST	RHN_KSPRESERVEFL_KSID_FK
RHNKICKSTARTSCRIPT	RHN_KSSCRIPT_KSID_FK
RHNKICKSTARTCHILDCHANNEL	RHN_KS_CC_KSD_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_KSID_FK

Triggers

RHN_KS_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_ks_mod_trig
before insert or update on rhnKSData
for each row

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