EventType Table

The EventType table stores details about the different types of Events.

Table 1. Database columns for EventType table

Database Column

Details

EventTypeID

Type: integer. Key. Generated ID

Synthetic key for this table.

EventTypeName

Type: text (max 256 characters). Key

Short text representing the Event Type. Internal use only- not to be displayed to the operator.

EventSeverityID

Type: integer

The severity of the Event. 1 = information, 2 = warning, 3 = error, 4 = critical.

EventMessageResource

Type: text (max 256 characters)

A resource name used to look up a description for this Event

EventTypeStatusID

Type: integer. Key

Foreign key to the EventTypeStatus table

ActivityTypeID

Type: integer. Key

Foreign key to the ActivityType table