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_CUSTOMER

DDL script

Columns

Name	Type	Nullable	Default value
ID	NUMBER(38)	N
NAME	VARCHAR2(128)	N
PASSWORD	VARCHAR2(48)	N
ORACLE_CUSTOMER_ID	NUMBER(38)	Y
ORACLE_CUSTOMER_NUMBER	NUMBER(38)	Y
CUSTOMER_TYPE	CHAR(1)	N	('P')
CREDIT_APPLICATION_COMPLETED	VARCHAR2(1)	Y
CREATED	DATE	N	(sysdate)
MODIFIED	DATE	N	(sysdate)

Primary key:

Constraint Name	Columns
WEB_CUSTOMER_ID_PK	ID

Check Constraints:

Constraint Name	Check Condition
WEB_CUSTOMER_TYPE_LIST	customer_type in ('B', 'P')

Unique Keys:

Constraint name	Columns
WEB_CUSTOMER_OCID_UNQ	ORACLE_CUSTOMER_ID
WEB_CUSTOMER_OCN_UNQ	ORACLE_CUSTOMER_NUMBER

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_CUSTOMER_ID_PK	NORMAL	UNIQUE	ID	DDL script
WEB_CUSTOMER_NAME_UQ_IDX	NORMAL	UNIQUE	NAME	DDL script
WEB_CUSTOMER_OCID_UNQ	NORMAL	UNIQUE	ORACLE_CUSTOMER_ID	DDL script
WEB_CUSTOMER_OCN_UNQ	NORMAL	UNIQUE	ORACLE_CUSTOMER_NUMBER	DDL script

Referenced by:

Table	Constraint
RHNACTION	RHN_ACTION_OID_FK
RHNCUSTOMDATAKEY	RHN_CDATAKEY_OID_FK
RHNCHANNELFAMILY	RHN_CHANNEL_FAMILY_ORG_FK
RHNCHANNEL	RHN_CHANNEL_ORG_FK
RHN_CHECK_SUITES	RHN_CKSUT_CSTMR_CUSTOMER_ID_FK
RHN_COMMAND_TARGET	RHN_CMDTG_CSTMR_CUSTOMER_ID_FK
RHN_CONTACT_GROUPS	RHN_CNTGP_CSTMR_CUSTOMER_ID_FK
RHNCONFIGCHANNEL	RHN_CONFCHAN_OID_FK
RHNCRYPTOKEY	RHN_CRYPTOKEY_OID_FK
RHNDAILYSUMMARYQUEUE	RHN_DSQUEUE_OID_FK
RHNERRATANOTIFICATIONQUEUE	RHN_ENQUEUE_OID_FK
RHNERRATATMP	RHN_ERRATATMP_OID_FK
RHNERRATA	RHN_ERRATA_OID_FK
RHNFILELIST	RHN_FILELIST_OID_FK
RHNFILE	RHN_FILE_OID_FK
RHNKICKSTARTIPRANGE	RHN_KSIP_OID_FK
RHNKICKSTARTABLETREE	RHN_KSTREE_OID_FK
RHNKSDATA	RHN_KS_OID_FK
RHNKICKSTARTSESSION	RHN_KS_SESSION_OID_FK
RHN_NOTIFICATION_FORMATS	RHN_NTFMT_CUSTOMER_FK
RHNORGERRATACACHEQUEUE	RHN_OECQ_OID_FK
RHNORGCHANNELSETTINGS	RHN_ORGCSETTINGS_OID_FK
RHNORGINFO	RHN_ORGINFO_OID_FK
RHNORGQUOTA	RHN_ORGQUOTA_OID_FK
RHNORGENTITLEMENTS	RHN_ORG_ENT_FK
RHNPACKAGESYNCBLACKLIST	RHN_PACKAGESYNCBL_OID_FK
RHNPACKAGE	RHN_PACKAGE_OID_FK
RHNPACKAGESOURCE	RHN_PKGSRC_OID_FK
RHNPRIVATECHANNELFAMILY	RHN_PRIVCF_OID_FK
RHN_PROBE	RHN_PROBE_CSTMR_CUSTOMER_ID_FK
RHN_REDIRECTS	RHN_RDRCT_CSTMR_CUSTOMER_ID_FK
RHNREGTOKENORGDEFAULT	RHN_REG_TOKEN_DEF_OID_FK
RHNREGTOKEN	RHN_REG_TOKEN_OID_FK
RHN_SAT_CLUSTER	RHN_SATCL_CSTMR_CUSTOMER_ID_FK
RHN_SCHEDULES	RHN_SCHED_CSTMR_CUST_ID_FK
RHNSERVERGROUP	RHN_SERVERGROUP_OID_FK
RHNSERVER	RHN_SERVER_OID_FK
RHNSERVERPROFILE	RHN_SERVER_PROFILE_OID_FK
RHNSNAPSHOT	RHN_SNAPSHOT_OID_FK
RHNSERVERNEEDEDPACKAGECACHE	RHN_SNCP_OID_FK
RHNSERVERNEEDEDERRATACACHE	RHN_SNEC_OID_FK
RHNTAG	RHN_TAG_OID_FK
RHNTASKQUEUE	RHN_TASK_QUEUE_ORG_ID_FK
RHNUSERGROUP	RHN_USER_GROUP_ORG_FK
WEB_CONTACT	WEB_CONTACT_ORG_FK
WEB_CUSTOMER_NOTIFICATION	WEB_CUST_NOT_OID_FK

Triggers

WEB_CUSTOMER_MOD_TRIG

Legend: comment string keyword reserved word operator

CREATE TRIGGER 
web_customer_mod_trig
before insert or update on web_customer
for each row

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