Spacewalk DB Schema - View-RHNHISTORYVIEW

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

Description Columns Query Constraints Triggers

RHNHISTORYVIEW

DDL script

Columns

Name	Type	Nullable	Insertable	Updatable	Deletable
EVENT_ID	NUMBER(38)	Y	NO	NO	NO
SERVER_ID	NUMBER(38)	Y	NO	NO	NO
SUMMARY	VARCHAR2(256)	Y	NO	NO	NO
DETAILS	VARCHAR2(4000)	Y	NO	NO	NO
CREATED	DATE	Y	NO	NO	NO
MODIFIED	DATE	Y	NO	NO	NO

Query:

Legend: comment string keyword reserved word operator

select
    id event_id, server_id, summary, details, created, modified
from
    rhnServerHistory
UNION
select EVENT_ID,SERVER_ID,SUMMARY,DETAILS,CREATED,MODIFIED from rhnHistoryView_refresh
UNION
select EVENT_ID,SERVER_ID,SUMMARY,DETAILS,CREATED,MODIFIED from rhnHistoryView_packages
UNION
select EVENT_ID,SERVER_ID,SUMMARY,DETAILS,CREATED,MODIFIED from rhnHistoryView_errata
with
    read only

Constraints:

Constraint Name	Type
SYS_C005684	With read only on view