EventConstants.java

/*****************************************************************************
 * 
 * Copyright (C) Zenoss, Inc. 2010, all rights reserved.
 * 
 * This content is made available according to terms specified in
 * License.zenoss under the directory where your Zenoss product is installed.
 * 
 ****************************************************************************/


package org.zenoss.zep.dao.impl;

public class EventConstants {
    // Table names
    public static final String TABLE_EVENT_ARCHIVE = "event_archive";
    public static final String TABLE_EVENT_SUMMARY = "event_summary";
    public static final String TABLE_EVENT_TIME = "event_time";
    public static final String TABLE_EVENT_SUMMARY_INDEX = TABLE_EVENT_SUMMARY+"_index";

    // Shared column names
    public static final String COLUMN_ELEMENT_SUB_IDENTIFIER = "element_sub_identifier";
    public static final String COLUMN_ELEMENT_SUB_TITLE = "element_sub_title";
    public static final String COLUMN_ELEMENT_SUB_TYPE_ID = "element_sub_type_id";
    public static final String COLUMN_ELEMENT_SUB_UUID = "element_sub_uuid";
    public static final String COLUMN_ELEMENT_IDENTIFIER = "element_identifier";
    public static final String COLUMN_ELEMENT_TITLE = "element_title";
    public static final String COLUMN_ELEMENT_TYPE_ID = "element_type_id";
    public static final String COLUMN_ELEMENT_UUID = "element_uuid";
    public static final String COLUMN_DETAILS_JSON = "details_json";
    public static final String COLUMN_TAGS_JSON = "tags_json";
    public static final String COLUMN_MESSAGE = "message";
    public static final String COLUMN_SUMMARY = "summary";
    public static final String COLUMN_NT_EVENT_CODE = "nt_event_code";
    public static final String COLUMN_SYSLOG_PRIORITY = "syslog_priority";
    public static final String COLUMN_SYSLOG_FACILITY = "syslog_facility";
    public static final String COLUMN_AGENT_ID = "agent_id";
    public static final String COLUMN_MONITOR_ID = "monitor_id";
    public static final String COLUMN_SEVERITY_ID = "severity_id";
    public static final String COLUMN_EVENT_CLASS_MAPPING_UUID = "event_class_mapping_uuid";
    public static final String COLUMN_EVENT_CLASS_KEY_ID = "event_class_key_id";
    public static final String COLUMN_EVENT_CLASS_ID = "event_class_id";
    public static final String COLUMN_EVENT_GROUP_ID = "event_group_id";
    public static final String COLUMN_EVENT_KEY_ID = "event_key_id";
    public static final String COLUMN_FINGERPRINT = "fingerprint";
    public static final String COLUMN_FINGERPRINT_HASH = "fingerprint_hash";
    public static final String COLUMN_UUID = "uuid";

    // Only in Event_Time
    public static final String COLUMN_SUMMARY_UUID = "summary_uuid";
    public static final String COLUMN_CREATED = "created";
    public static final String COLUMN_PROCESSED = "processed";

    // Summary / Archive fields
    public static final String COLUMN_STATUS_ID = "status_id";
    public static final String COLUMN_CLOSED_STATUS = "closed_status";
    public static final String COLUMN_UPDATE_TIME = "update_time";
    public static final String COLUMN_FIRST_SEEN = "first_seen";
    public static final String COLUMN_STATUS_CHANGE = "status_change";
    public static final String COLUMN_LAST_SEEN = "last_seen";
    public static final String COLUMN_EVENT_COUNT = "event_count";
    public static final String COLUMN_CURRENT_USER_UUID = "current_user_uuid";
    public static final String COLUMN_CURRENT_USER_NAME = "current_user_name";
    public static final String COLUMN_CLEAR_FINGERPRINT_HASH = "clear_fingerprint_hash";
    public static final String COLUMN_CLEARED_BY_EVENT_UUID = "cleared_by_event_uuid";
    public static final String COLUMN_NOTES_JSON = "notes_json";
    public static final String COLUMN_AUDIT_JSON = "audit_json";

    // Maximum lengths for CHAR/VARCHAR columns
    public static final int MAX_FINGERPRINT = 255;
    public static final int MAX_ELEMENT_IDENTIFIER = 255;
    public static final int MAX_ELEMENT_SUB_IDENTIFIER = MAX_ELEMENT_IDENTIFIER;
    public static final int MAX_ELEMENT_TITLE = 255;
    public static final int MAX_ELEMENT_SUB_TITLE = MAX_ELEMENT_TITLE;
    public static final int MAX_EVENT_CLASS = 128;
    public static final int MAX_EVENT_CLASS_KEY = 128;
    public static final int MAX_EVENT_KEY = 128;
    public static final int MAX_MONITOR = 128;
    public static final int MAX_AGENT = 64;
    public static final int MAX_EVENT_GROUP = 64;
    public static final int MAX_SUMMARY = 255;
    public static final int MAX_MESSAGE = 4096;
    public static final int MAX_CURRENT_USER_NAME = 32;
}