Schema for database 'logguard'

logguard

action
action_email
action_http
action_jdbc
action_jms
action_propriatery
action_snmp
action_soap
action_type
alarm
alarm_mapto_action
alarm_type
application_log
matching_rule
parsed_result
parsed_result_archived
parsed_result_tmp
priority
triggered_action
triggered_action_email
triggered_action_http
triggered_action_jdbc
triggered_action_jms
triggered_action_propriatery
triggered_action_snmp
triggered_action_soap
triggered_alarm
unparsed_result
value_type

action

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

PK AI

type_id

int(4)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION_TYPE.id

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action

0

PRIMARY

1

id

A

0

(NULL)

(NULL)

BTREE

action

0

id

1

id

A

0

(NULL)

(NULL)

BTREE

action_email

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

FK to ACTION.ID

recipient_addresses

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

sender_address

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

subject

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

user

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

password

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

smtp_server

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

mail_priority

int(4)

(NULL)

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_email

0

idx_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_http

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

arguments

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_http

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_jdbc

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

conn_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

target_procedure

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

procedure_params

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_jdbc

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_jms

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

application_server_address

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

mbean_class_name

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_jms

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_propriatery

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

server_ip

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

server_port

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

protocol

varchar(4)

utf8_general_ci

NO

(NULL)

select,insert,update,references

UDP/TCP

class_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_propriatery

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_snmp

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

community_string

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

server

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

pass

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

oid

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

snmp_type

int(4)

(NULL)

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_snmp

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_soap

Fields

Field Type Collation Null Key Default Extra Privileges Comment

action_id

int(10)

(NULL)

NO

PRI

(NULL)

select,insert,update,references

bind

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_soap

0

action_id

1

action_id

A

0

(NULL)

(NULL)

BTREE

action_type

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

description

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

action_type

0

PRIMARY

1

id

A

0

(NULL)

(NULL)

BTREE

alarm

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

description

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

type

int(2)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

fk to ALARM_TYPE.ID

value_type

int(2)

(NULL)

NO

MUL

(NULL)

select,insert,update,references

fk to VALUE_TYPE.ID

matching_rule

int(2)

(NULL)

NO

(NULL)

select,insert,update,references

fk to MATCHING_RULE.ID

priority

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

fk to PRIORITY.ID

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

alarm

0

PRIMARY

1

id

A

0

(NULL)

(NULL)

BTREE

alarm

0

id

1

id

A

0

(NULL)

(NULL)

BTREE

alarm

1

fk_type

1

type

A

(NULL)

(NULL)

(NULL)

BTREE

alarm

1

fk_value_type

1

value_type

A

(NULL)

(NULL)

(NULL)

BTREE

alarm_mapto_action

Fields

Field Type Collation Null Key Default Extra Privileges Comment

alarm_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

fk to ALARM.ID

action_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

fk to ACTION.ID

Indexes

alarm_type

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(2)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

description

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Description of Alarm Severity

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

alarm_type

0

PRIMARY

1

id

A

4

(NULL)

(NULL)

BTREE

application_log

Fields

Field Type Collation Null Key Default Extra Privileges Comment

idx

int(20) unsigned

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

PK

event_datetime

datetime

(NULL)

NO

(NULL)

select,insert,update,references

when

caller

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

System issued log message. Optional

request_id

int(32)

(NULL)

YES

(NULL)

select,insert,update,references

type of the request.Optional

severity

varchar(16)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

Log severity. Optional

description

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

Logging Message

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

application_log

0

idx_idx

1

idx

A

12

(NULL)

(NULL)

BTREE

matching_rule

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(2)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

description

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

matching_rule

0

PRIMARY

1

id

A

5

(NULL)

(NULL)

BTREE

parsed_result

Fields

Field Type Collation Null Key Default Extra Privileges Comment

token_name

varchar(32)

utf8_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

Log file's token

section_name

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Log file's section

task_name

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Log file parser or system

file_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

Log file name

parsed_value

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

the parsed value

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

when this was entered

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

parsed_result

1

token_name

1

token_name

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result

1

token_name

2

task_name

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result

1

token_name

3

created

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result_archived

Fields

Field Type Collation Null Key Default Extra Privileges Comment

token_name

varchar(32)

utf8_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

section_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

task_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

file_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

parsed_value

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

parsed_result_archived

1

token_name

1

token_name

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result_archived

1

token_name

2

task_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

parsed_result_archived

1

token_name

3

created

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result_tmp

Fields

Field Type Collation Null Key Default Extra Privileges Comment

token_name

varchar(32)

utf8_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

section_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

task_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

file_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

parsed_value

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

parsed_result_tmp

1

token_name

1

token_name

A

(NULL)

(NULL)

(NULL)

BTREE

parsed_result_tmp

1

token_name

2

task_name

A

(NULL)

(NULL)

(NULL)

YES

BTREE

parsed_result_tmp

1

token_name

3

created

A

(NULL)

(NULL)

(NULL)

BTREE

priority

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(2)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

Priority ID refered ALARM.PRIORITY

description

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Description

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

priority

0

PRIMARY

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

PK

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

action_type_id

int(4)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION_TYPE.ID

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action

0

PRIMARY

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action

0

id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_email

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

recipient_addresses

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

where this email goes

sender_address

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

who sends this email

subject

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

subject of the email

user

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

password

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

smtp_server

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

mail_priority

int(4)

(NULL)

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_email

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_http

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

arguments

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_http

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_jdbc

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

conn_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

target_procedure

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

procedure_params

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_jdbc

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_jms

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

application_server_address

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

mbean_class_name

varchar(128)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_jms

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_propriatery

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

server_ip

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

server_port

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

protocol

varchar(4)

utf8_general_ci

NO

(NULL)

select,insert,update,references

UDP/TCP

class_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_propriatery

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_snmp

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

community_string

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

server

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

pass

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

oid

varchar(64)

utf8_general_ci

NO

(NULL)

select,insert,update,references

snmp_type

int(4)

(NULL)

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_snmp

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_action_soap

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(10)

(NULL)

NO

PRI

0

select,insert,update,references

FK to triggered_action.id

log_entry_name

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_general_ci

NO

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

The log file where alarm originated

parsing_dt

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Datetime of parsing

alarm_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

action_id

int(10)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ACTION.ID

message

varchar(256)

utf8_general_ci

YES

(NULL)

select,insert,update,references

Comes from ACTION

bind

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_name

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

class_url

varchar(256)

utf8_general_ci

NO

(NULL)

select,insert,update,references

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_action_soap

0

idx_id

1

id

A

0

(NULL)

(NULL)

BTREE

triggered_alarm

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(11)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

PK

log_entry_name

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Log parsed token name

log_section

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Log section name

system_id

varchar(32)

utf8_unicode_ci

NO

MUL

(NULL)

select,insert,update,references

Log processor or LogAgent or Task name

log_value

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

The parsed value

log_file_name

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Log file name that where alarm created

alarm_id

int(11)

(NULL)

NO

(NULL)

select,insert,update,references

FK to ALARM.ID

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

triggered_alarm

0

PRIMARY

1

id

A

6

(NULL)

(NULL)

BTREE

triggered_alarm

0

id_idx

1

id

A

6

(NULL)

(NULL)

BTREE

triggered_alarm

1

alarm_idx

1

system_id

A

(NULL)

(NULL)

(NULL)

BTREE

triggered_alarm

1

alarm_idx

2

log_section

A

(NULL)

(NULL)

(NULL)

BTREE

triggered_alarm

1

alarm_idx

3

log_entry_name

A

(NULL)

(NULL)

(NULL)

BTREE

triggered_alarm

1

alarm_idx

4

alarm_id

A

(NULL)

(NULL)

(NULL)

BTREE

unparsed_result

Fields

Field Type Collation Null Key Default Extra Privileges Comment

token_name

varchar(32)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

section_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

task_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

file_name

varchar(32)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

line

varchar(256)

utf8_unicode_ci

YES

(NULL)

select,insert,update,references

create_date

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

value_type

Fields

Field Type Collation Null Key Default Extra Privileges Comment

id

int(2)

(NULL)

NO

PRI

(NULL)

auto_increment

select,insert,update,references

PK, referenced from ALARM.VALUE_TYPE

description

varchar(256)

utf8_unicode_ci

NO

(NULL)

select,insert,update,references

Description

created

datetime

(NULL)

NO

(NULL)

select,insert,update,references

updated

datetime

(NULL)

YES

(NULL)

select,insert,update,references

Indexes

Table Non
unique Key
name Seq
in
index Column
name Collation Cardinality Sub
part Packed Null Index
type Comment

value_type

0

PRIMARY

1

id

A

4

(NULL)

(NULL)

BTREE