Spacewalk DB Schema - Table-RHNKICKSTARTCOMMANDNAME

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

RHNKICKSTARTCOMMANDNAME

Columns

Name	Type	Nullable	Default value	Comment
ID	NUMBER(38)	N
NAME	VARCHAR2(128)	N
USES_ARGUMENTS	CHAR(1)	N
SORT_ORDER	NUMBER(38)	N
REQUIRED	CHAR(1)	N	('N')

Primary key:

Constraint Name	Columns
RHN_KSCOMMANDNAME_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_KSCOMMANDNAME_REQRD_CK	required in ('Y', 'N')
RHN_KSCOMMANDNAME_USES_ARGS_CK	uses_arguments in ('Y','N')

Unique Keys:

Constraint name	Columns
RHN_KSCOMMANDNAME_NAME_UQ	NAME

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_KSCOMMANDNAME_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_KSCOMMANDNAME_NAME_ID_IDX	NORMAL	NONUNIQUE	NAME , ID	DDL script

Referenced by:

Table	Constraint
RHNKICKSTARTCOMMAND	RHN_KSCOMMAND_KCNID_FK