Table ocum.alert 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_emailaddressrecipients.alert_id Alert_emailAddressRecipients_alert_id_FK C
alert_emailadminrecipients.alert_id Alert_emailAdminRecipients_alert_id_FK C
alert_eventseverities.alert_id Alert_eventSeverities_alert_id_FK C
alerteventtypevalues.alert_id AlertEventTypeValues_alert_id_FK C
alertresourceobjects.alert_id AlertResourceObjects_alert_id_FK C
name varchar 255
objVersion int 10
eventTypeRegex varchar 255  √  null
eventSeverity varchar 16  √  null
disabled bit 1
repeatDuration bigint 19  √  null
timeFrom bigint 19  √  null
timeTo bigint 19  √  null
description varchar 1024  √  null
resourceTypes longtext 2147483647  √  null
excludeFilter longtext 2147483647  √  null
includeFilter longtext 2147483647  √  null
sendSnmpTrap bit 1
scriptId bigint 19  √  null
script.id Alert_scriptId_FK N

Table contained 0 rows at Tue Apr 23 05:29 EDT 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
disabled Performance Asc Alert_disabled_IX
name Must be unique Asc Alert_name_UQ
scriptId Performance Asc Alert_scriptId_FK

Close relationships  within of separation: