Spacewalk DB Schema - Table-RHNCHANNELFAMILYVIRTSUBLEVEL

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

RHNCHANNELFAMILYVIRTSUBLEVEL

Columns

Name	Type	Nullable	Default value	Comment
CHANNEL_FAMILY_ID	NUMBER(38)	N
VIRT_SUB_LEVEL_ID	NUMBER(38)	N
CREATED	DATE	N	sysdate
MODIFIED	DATE	N	sysdate

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CFVSL_CFID_FK	CHANNEL_FAMILY_ID	RHNCHANNELFAMILY	RHN_CHANNEL_FAMILY_ID_PK	NO ACTION
RHN_CFVSL_VSLID_FK	VIRT_SUB_LEVEL_ID	RHNVIRTSUBLEVEL	RHN_VSL_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_CFVSL_CFID_VSLID_IDX	NORMAL	NONUNIQUE	CHANNEL_FAMILY_ID , VIRT_SUB_LEVEL_ID	DDL script
RHN_CFVSL_VSLID_CFID_IDX	NORMAL	NONUNIQUE	VIRT_SUB_LEVEL_ID , CHANNEL_FAMILY_ID	DDL script