Table ocum.event Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigint 19
alert_script_audit.eventId alert_script_audit_eventId_FK C
clienteventdetails.event_id ClientEventDetails_event_id_FK C
event.obsoleteCauseEvent_id Event_obsoleteCauseEvent_id_FK N
eventnote.event_id EventNote_event_id_FK C
eventontapsystemhealthalertmapping.event_id EventOntapSystemHealthAlertMapping_event_id_FK C
trap.event_id Trap_event_id_FK C
objVersion int 10
source_id bigint 19
source_type varchar 100
source_fullName varchar 2000
source_resourceKey varchar 512
source_resourceType varchar 40
value_id bigint 19
eventtypevalue.id Event_value_id_FK C
cluster_id bigint 19  √  null
clusterNode_id bigint 19  √  null
vserver_id bigint 19  √  null
obsoleteCauseValue_id bigint 19  √  null
eventtypevalue.id Event_obsoleteCauseValue_id_FK C
obsoleteCauseEvent_id bigint 19  √  null
event.id Event_obsoleteCauseEvent_id_FK N
encodedArguments longtext 2147483647  √  null
obsoleteCauseEncodedArguments longtext 2147483647  √  null
eventTimestamp timestamp 19  √  null
impactArea varchar 60  √  null
state varchar 16
resolvedTimestamp timestamp 19  √  null
resolvedBy varchar 128  √  null
isChecked bit 1  √  null
obsoleteTimestamp timestamp 19  √  null
acknowledgedTimestamp timestamp 19  √  null
acknowledgedBy varchar 128  √  null
assignedTimestamp timestamp 19  √  null
assignedTo varchar 128  √  null
obsoleteCause varchar 60  √  null
subType smallint 5  √  null
targetType smallint 5  √  null
targetId bigint 19  √  null
lastObservedTime bigint 19  √  null
thresholdPolicyId bigint 19  √  null
isContinuous bit 1 b'1'
maintenance bit 1 b'0'

Table contained 1,690 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
cluster_id Performance Asc Event_cluster_IX
clusterNode_id Performance Asc Event_clusterNode_IX
obsoleteCauseEvent_id Performance Asc Event_obsoleteCauseEvent_IX
obsoleteCauseValue_id Performance Asc Event_obsoleteCauseValue_IX
source_id + source_type Performance Asc/Asc Event_source_IX
state Performance Asc Event_state_IX
value_id Performance Asc Event_value_IX
vserver_id Performance Asc Event_vserver_IX

Close relationships  within of separation: