Spacewalk DB Schema - View-RHNWEBCONTACTDISABLED

Main Tables Views Materialized Views Indexes Constraints Triggers Procedures Functions Packages Sequences Java Sources Jobs Sanity Check Index DDL scrips

Description Columns Query Constraints Triggers

RHNWEBCONTACTDISABLED

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
ID	NUMBER(38)	N	NO	NO	NO
ORG_ID	NUMBER(38)	N	NO	NO	NO
LOGIN	VARCHAR2(64)	N	NO	NO	NO
LOGIN_UC	VARCHAR2(64)	N	NO	NO	NO
PASSWORD	VARCHAR2(110)	N	NO	NO	NO
ORACLE_CONTACT_ID	NUMBER(38)	Y	NO	NO	NO
CREATED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	NO	NO	NO
MODIFIED	TIMESTAMP(6) WITH LOCAL TIME ZONE	N	NO	NO	NO
IGNORE_FLAG	CHAR(1)	N	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
   wcon.id,
   wcon.org_id,
   wcon.login,
   wcon.login_uc,
   wcon.password,
   wcon.oracle_contact_id,
   wcon.created,
   wcon.modified,
   wcon.ignore_flag
from
   rhnWebContactChangeLog   wccl,
   rhnWebContactChangeState wccs,
   web_contact              wcon
where wccl.change_state_id = wccs.id
   and wccs.label = 'disabled'
   and wccl.web_contact_id = wcon.id
   and wccl.date_completed =
              (select max(wccl_exists.date_completed)
                 from rhnWebContactChangeLog   wccl_exists
                where wccl.web_contact_id = wccl_exists.web_contact_id)