Spacewalk DB Schema - Table-RHNUSERINFO

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

RHNUSERINFO

DDL script

Columns

Name	Type	Nullable	Default value
USER_ID	NUMBER(38)	N
NO_CLEAR_SETS	NUMBER(38)	N	(0)
PAGE_SIZE	NUMBER(38)	N	(20)
EMAIL_NOTIFY	NUMBER(38)	N	(1)
TASKO_NOTIFY	CHAR(1)	N	('Y')
BAD_EMAIL	NUMBER(38)	N	(0)
TZ_OFFSET	NUMBER(38)	N	(-5)
TIMEZONE_ID	NUMBER(38)	Y
SHOW_APPLIED_ERRATA	CHAR(1)	N	('N')
SHOW_SYSTEM_GROUP_LIST	CHAR(1)	N	('N')
AGREED_TO_TERMS	CHAR(1)	N	('N')
USE_PAM_AUTHENTICATION	CHAR(1)	N	('N')
LAST_LOGGED_IN	TIMESTAMP(6) WITH LOCAL TIME ZONE	Y
AGREED_TO_WS_TERMS	CHAR(1)	Y
AGREED_TO_ES_TERMS	CHAR(1)	Y
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	(current_timestamp)
PREFERRED_LOCALE	VARCHAR2(8)	Y
CSV_SEPARATOR	CHAR(1)	N	(',')

Check Constraints:

Constraint Name	Check Condition
RHN_USER_INFO_AGREED_CK	agreed_to_terms in ('Y','N')
RHN_USER_INFO_CSV_CK	csv_separator in (',',';')
RHN_USER_INFO_ES_CK	agreed_to_es_terms is null or agreed_to_es_terms in ('Y','N')
RHN_USER_INFO_PAM_CK	use_pam_authentication in ('Y','N')
RHN_USER_INFO_SEA_CK	show_applied_errata in ('Y','N')
RHN_USER_INFO_SSGL_CK	show_system_group_list in ('Y','N')
RHN_USER_INFO_TASKO_CK	tasko_notify in ('Y', 'N')
RHN_USER_INFO_TZOFFSET_CK	tz_offset >= -11 and tz_offset <= 13
RHN_USER_INFO_WS_CK	agreed_to_ws_terms is null or agreed_to_ws_terms in ('Y','N')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
RHN_USER_INFO_TZID_FK	TIMEZONE_ID	RHNTIMEZONE	RHN_TIMEZONE_ID_PK	CASCADE
RHN_USER_INFO_USER_FK	USER_ID	WEB_CONTACT	WEB_CONTACT_PK	CASCADE

Unique Keys:

Constraint name	Columns
RHN_USER_INFO_UID_UQ	USER_ID

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_USER_INFO_UID_EMAIL_IDX	NORMAL	NONUNIQUE	USER_ID , EMAIL_NOTIFY	DDL script

Triggers

RHN_USER_INFO_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
rhn_user_info_mod_trig
before insert or update on rhnUserInfo
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
	:new.modified := current_timestamp;
end rhn_user_info_mod_trig;