Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

ALERT_GROUP

Col #

Column Name

Data Type

Field Length

Not Null?

Data Def.

Comments

1

ID

NUMBER

22

N

 

Primary key

2

DESCRIPTION

VARCHAR2

800

Y

 

Description of the alert group

3

ALERT_TYPE_ID

NUMBER

22

Y

 

Reference to the alert type

4CURRENCY_CODEVARCHAR212Y Currency used
5STATUSNUMBER Y Maps to the enum AlertGroupStatus, ACTIVE(0), DEPRECATED(1).
Column
width33%

An alert group is a logical grouping of ALERT_LEVEL-records - each subscription is associated with an alert group.