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

RHNVIRTUALINSTANCEEVENTLOG

DDL script

Columns

NameTypeNullableDefault valueComment
IDNUMBER(38)N  
VIRTUAL_INSTANCE_IDNUMBER(38)Y  
EVENT_TYPENUMBER(38)N  
EVENT_METADATAVARCHAR2(4000)Y  
OLD_STATENUMBER(38)N  
NEW_STATENUMBER(38)N  
OLD_MEMORY_SIZE_KNUMBER(38)Y  
NEW_MEMORY_SIZE_KNUMBER(38)Y  
OLD_VCPUSNUMBER(38)Y  
NEW_VCPUSNUMBER(38)Y  
OLD_HOST_SYSTEM_IDNUMBER(38)Y  
NEW_HOST_SYSTEM_IDNUMBER(38)Y  
OLD_HOST_SYSTEM_NAMEVARCHAR2(128)Y  
NEW_HOST_SYSTEM_NAMEVARCHAR2(128)Y  
LOCAL_TIMESTAMPTIMESTAMP(6) WITH LOCAL TIME ZONEN  
CREATEDTIMESTAMP(6) WITH LOCAL TIME ZONEN(current_timestamp)  
MODIFIEDTIMESTAMP(6) WITH LOCAL TIME ZONEN(current_timestamp)  

Primary key:

Constraint NameColumns
RHN_VIEL_ID_PKID

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
RHN_VIEL_ET_FKEVENT_TYPE RHNVIRTUALINSTANCEEVENTTYPE RHN_VIET_ID_PK NO ACTION
RHN_VIEL_NEW_STATE_FKNEW_STATE RHNVIRTUALINSTANCESTATE RHN_VIS_ID_PK NO ACTION
RHN_VIEL_OLD_STATE_FKOLD_STATE RHNVIRTUALINSTANCESTATE RHN_VIS_ID_PK NO ACTION
RHN_VIEL_VII_FKVIRTUAL_INSTANCE_ID RHNVIRTUALINSTANCE RHN_VI_ID_PK CASCADE

Options:

OptionSettings
TablespaceUSERS
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
RHN_VIEL_ID_PKNORMALUNIQUEID DDL script
RHN_VIEL_VII_IDXNORMALNONUNIQUEVIRTUAL_INSTANCE_ID DDL script