Spacewalk DB Schema - Table-WEB

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

WEB_CONTACT

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
ORG_ID	NUMBER(38)	N
LOGIN	VARCHAR2(64)	N
LOGIN_UC	VARCHAR2(64)	N
PASSWORD	VARCHAR2(38)	N
OLD_PASSWORD	VARCHAR2(38)	Y
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)
ORACLE_CONTACT_ID	NUMBER(38)	Y
IGNORE_FLAG	CHAR(1)	N	('N')

Primary key:

Constraint Name	Columns
WEB_CONTACT_PK	ID

Check Constraints:

Constraint Name	Check Condition
WEB_CONTACT_IGNORE_CK	ignore_flag in ('N','Y')

Foreign Keys:

Constraint Name	Columns	Referenced table	Referenced Constraint	On Delete Rule
WEB_CONTACT_ORG_FK	ORG_ID	WEB_CUSTOMER	WEB_CUSTOMER_ID_PK	NO ACTION

Unique Keys:

Constraint name	Columns
WEB_CONTACT_LOGIN_UC_UNQ	LOGIN_UC
WEB_CONTACT_OCID_UNQ	ORACLE_CONTACT_ID

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
WEB_CONTACT_ID_OID_CUST_LUC	NORMAL	NONUNIQUE	ID , ORACLE_CONTACT_ID , ORG_ID , LOGIN_UC	DDL script
WEB_CONTACT_LOGIN_UC_UNQ	NORMAL	UNIQUE	LOGIN_UC	DDL script
WEB_CONTACT_OCID_UNQ	NORMAL	UNIQUE	ORACLE_CONTACT_ID	DDL script
WEB_CONTACT_OID_ID	NORMAL	NONUNIQUE	ORG_ID , ID	DDL script
WEB_CONTACT_PK	NORMAL	UNIQUE	ID	DDL script

Referenced by:

Table	Constraint
WEB_USER_CONTACT_PERMISSION	CONTPERM_WBUSERID_FK
WEB_USER_PERSONAL_INFO	PERSONAL_INFO_WEB_USER_ID_FK
PXTSESSIONS	PXTSESSIONS_USER
RHNACTION	RHN_ACTION_SCHEDULER_FK
RHNAPPINSTALLSESSION	RHN_APPINST_SESSION_UID_FK
RHNCUSTOMDATAKEY	RHN_CDATAKEY_CB_FK
RHNCUSTOMDATAKEY	RHN_CDATAKEY_LMB_FK
RHNCHANNELFAMILYLICENSECONSENT	RHN_CFL_CONSENT_UID_FK
RHN_CONTACT_METHODS	RHN_CMETH_CONTACT_ID_FK
RHNCONFIGREVISION	RHN_CONFREVISION_CID_FK
RHNCHANNELPERMISSION	RHN_CPERM_UID_FK
RHN_COMMAND_QUEUE_SESSIONS	RHN_CQSES_CNTCT_CONTACT_IDFK
RHNEMAILADDRESSLOG	RHN_EADDRESSLOG_UID_FK
RHNEMAILADDRESS	RHN_EADDRESS_UID_FK
RHNFILEDOWNLOAD	RHN_FILEDL_UID_FK
RHNGRAILCOMPONENTCHOICES	RHN_GRAIL_COMP_CH_USER_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_SCHED_FK
RHN_REDIRECTS	RHN_RDRCT_CNTCT_CONTACT_ID_FK
RHNREGTOKEN	RHN_REG_TOKEN_UID_FK
RHNSAVEDSEARCH	RHN_SAVEDSEARCH_WCID_FK
RHNSERVERCUSTOMDATAVALUE	RHN_SCDV_CB_FK
RHNSERVERCUSTOMDATAVALUE	RHN_SCDV_LMB_FK
RHNSERVERGROUPNOTES	RHN_SERVERGRP_NOTE_CREATOR_FK
RHNSERVERNOTES	RHN_SERVERNOTES_CREATOR_FK
RHNSERVER	RHN_SERVER_CREATOR_FK
RHNSERVERLOCK	RHN_SERVER_LOCK_LID_FK
RHNSET	RHN_SET_USER_FK
RHNUSERDEFAULTSYSTEMGROUPS	RHN_UDSG_UID_FK
RHNUSERGROUPMEMBERS	RHN_UGMEMBERS_UID_FK
RHNUSERMESSAGE	RHN_UM_USER_ID_FK
RHNUSERSERVERPREFS	RHN_USERSERVERPREFS_UID_FK
RHNUSERINFO	RHN_USER_INFO_USER_FK
RHNUSERSERVERGROUPPERMS	RHN_USGP_USER_FK
RHNUSERSERVERPERMS	RHN_USPERMS_UID_FK
RHNUSERINFOPANE	RHN_USR_INFO_PANE_UID_FK
RHNWEBCONTACTCHANGELOG	RHN_WCON_CL_WCON_FROM_ID_FK
RHNWEBCONTACTCHANGELOG	RHN_WCON_CL_WCON_ID_FK
WEB_USER_SITE_INFO	WUSI_WUID_FK

Triggers

WEB_CONTACT_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
web_contact_mod_trig
before insert or update on web_contact
for each row

REFERENCING NEW AS NEW OLD AS OLD
begin
        :new.modified := sysdate;
        :new.login_uc := UPPER(:new.login);
        IF :new.password lt;gt; :old.password THEN
                :new.old_password := :old.password;
        END IF;
end;