Spacewalk DB Schema - Table-RHNISSMASTER

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

RHNISSMASTER

Columns

Name	Type	Nullable	Default value	Comment
ID	NUMBER(38)	N
LABEL	VARCHAR2(256)	N
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
IS_CURRENT_MASTER	CHAR(1)	N	'N'
CA_CERT	VARCHAR2(1024)	Y

Primary key:

Constraint Name	Columns
RHN_ISS_MASTER_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_ISSM_MASTER_YN	is_current_master in ('Y', 'N')

Unique Keys:

Constraint name	Columns
RHN_ISS_MASTER_LABEL_UQ	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_ISSM_ONLY_ONE_DEFAULT	FUNCTION-BASED NORMAL	UNIQUE	CASE WHEN "IS_CURRENT_MASTER"='Y' THEN "IS_CURRENT_MASTER" END	DDL script
RHN_ISS_MASTER_ID_PK	NORMAL	UNIQUE	ID	DDL script
RHN_ISS_MASTER_LABEL_UQ	NORMAL	UNIQUE	LABEL	DDL script

Referenced by:

Table	Constraint
RHNISSMASTERORGS	RHN_ISSMASTERORGS_CID_FK