Spacewalk DB Schema - Table-RHN_CONTACT_GROUP_MEMBERS

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

RHN_CONTACT_GROUP_MEMBERS

Description:

cntgm contact group membership records

Columns

Name	Type	Nullable	Default value	Comment
CONTACT_GROUP_ID	NUMBER(38)	N
ORDER_NUMBER	NUMBER(38)	N
MEMBER_CONTACT_METHOD_ID	NUMBER(38)	Y
MEMBER_CONTACT_GROUP_ID	NUMBER(38)	Y
LAST_UPDATE_USER	VARCHAR2(40)	N
LAST_UPDATE_DATE	DATE	N

Primary key:

Constraint Name	Columns
RHN_CNTGM_CGID_ORDER_PK	CONTACT_GROUP_ID , ORDER_NUMBER

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_CNTGM_CGID_FK	CONTACT_GROUP_ID	RHN_CONTACT_GROUPS	RHN_CNTGP_RECID_PK	CASCADE
RHN_CNTGM_MCGID_FK	MEMBER_CONTACT_GROUP_ID	RHN_CONTACT_GROUPS	RHN_CNTGP_RECID_PK	CASCADE
RHN_CNTGM_MCMID_FK	MEMBER_CONTACT_METHOD_ID	RHN_CONTACT_METHODS	RHN_CMETH_RECID_PK	CASCADE

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_CNTGM_CGID_ORDER_IDX	NORMAL	NONUNIQUE	CONTACT_GROUP_ID , ORDER_NUMBER	DDL script
RHN_CNTGM_MCGID_IDX	NORMAL	NONUNIQUE	MEMBER_CONTACT_GROUP_ID	DDL script
RHN_CNTGM_MCMID_IDX	NORMAL	NONUNIQUE	MEMBER_CONTACT_METHOD_ID	DDL script