Spacewalk DB Schema - Table-RHNACTIONTYPE

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

RHNACTIONTYPE

Columns

Name	Type	Nullable	Default value	Comment
ID	NUMBER(38)	N
LABEL	VARCHAR2(48)	N
NAME	VARCHAR2(100)	N
TRIGGER_SNAPSHOT	CHAR(1)	N	('N')
UNLOCKED_ONLY	CHAR(1)	N	('N')

Primary key:

Constraint Name	Columns
RHN_ACTION_TYPE_PK	ID

Check Constraints:

Constraint Name	Check Condition
RHN_ACTION_TYPE_TRIGSNAP_CK	trigger_snapshot in ('Y','N')
RHN_ACTION_TYPE_UNLCK_CK	unlocked_only in ('Y','N')

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_ACTION_TYPE_LABEL_UQ	NORMAL	UNIQUE	LABEL	DDL script
RHN_ACTION_TYPE_NAME_UQ	NORMAL	UNIQUE	NAME	DDL script
RHN_ACTION_TYPE_PK	NORMAL	UNIQUE	ID	DDL script

Referenced by:

Table	Constraint
RHNACTION	RHN_ACTION_AT_FK
RHNARCHTYPEACTIONS	RHN_ARCHTYPEACTS_ACTID_FK