JBoss Community Archive (Read Only)

RHQ 4.9

Design-AllDBTables

Below is the list of all tables in the schema.

(SystemManagerBean is where V, TR and OR info is found)

Tablename

V

TR

OR

Description

RHQ_AFFINITY_GROUP

 

 

 

 

RHQ_AGENT

images/author/images/icons/emoticons/check0.gif

 

 

 

RHQ_ALERT

 

 

 

 

RHQ_ALERT_CONDITION

 

 

 

 

RHQ_ALERT_CONDITION_LOG

 

 

 

 

RHQ_ALERT_DAMPEN_EVENT

 

 

 

 

RHQ_ALERT_DEFINITION

 

 

 

 

RHQ_ALERT_NOTIF_LOG

 

 

 

 

RHQ_ALERT_NOTIFICATION

 

 

 

 

RHQ_ARCHITECTURE

 

 

 

 

RHQ_AVAILABILITY

 

images/author/images/icons/emoticons/check0.gif

 

 

RHQ_CALLTIME_DATA_KEY

 

images/author/images/icons/emoticons/check0.gif

 

 

RHQ_CALLTIME_DATA_VALUE

 

images/author/images/icons/emoticons/check0.gif

 

 

RHQ_CHANNEL

 

 

 

 

RHQ_CHANNEL_CONTENT_SRC_MAP

 

 

 

 

RHQ_CHANNEL_PKG_VERSION_MAP

 

 

 

 

RHQ_CHANNEL_RESOURCE_MAP

 

 

 

 

RHQ_CONF_PROP_DEF_ENUM

 

 

 

 

RHQ_CONFIG

images/author/images/icons/emoticons/check0.gif

 

 

 

RHQ_CONFIG_DEF

 

 

 

 

RHQ_CONFIG_GROUP_UPDATE

 

 

 

 

RHQ_CONFIG_PROP_CONSTR

 

 

 

 

RHQ_CONFIG_PROP_DEF

 

 

 

 

RHQ_CONFIG_PROP_GRP_DEF

 

 

 

 

RHQ_CONFIG_PROPERTY

images/author/images/icons/emoticons/check0.gif

 

 

 

RHQ_CONFIG_TEMPLATE

 

 

 

 

RHQ_CONFIG_UPDATE

 

 

 

 

RHQ_CONTENT_REQ

 

 

 

 

RHQ_CONTENT_SOURCE

 

 

 

 

RHQ_CONTENT_SOURCE_TYPE

 

 

 

 

RHQ_CONTENT_SRC_SYNC

 

 

 

 

RHQ_CREATE_RES_HIST

 

 

 

 

RHQ_DELETE_RES_HIST

 

 

 

 

RHQ_EVENT

 

 

 

 

RHQ_EVENT_DEF

 

 

 

 

RHQ_EVENT_SOURCE

 

 

 

 

RHQ_FAILOVER_DETAILS

 

 

 

 

RHQ_FAILOVER_LIST

 

 

 

 

RHQ_GROUP_DEF

 

 

 

 

RHQ_INSTALLED_PACKAGE

 

 

 

 

RHQ_INSTALLED_PKG_HIST

 

 

 

 

RHQ_MEAS_DATA_NUM_R00

 

 

 

 

RHQ_MEAS_DATA_NUM_R01

 

 

 

 

RHQ_MEAS_DATA_NUM_R02

 

 

 

 

RHQ_MEAS_DATA_NUM_R03

 

 

 

 

RHQ_MEAS_DATA_NUM_R04

 

 

 

 

RHQ_MEAS_DATA_NUM_R05

 

 

 

 

RHQ_MEAS_DATA_NUM_R06

 

 

 

 

RHQ_MEAS_DATA_NUM_R07

 

 

 

 

RHQ_MEAS_DATA_NUM_R08

 

 

 

 

RHQ_MEAS_DATA_NUM_R09

 

 

 

 

RHQ_MEAS_DATA_NUM_R10

 

 

 

 

RHQ_MEAS_DATA_NUM_R11

 

 

 

 

RHQ_MEAS_DATA_NUM_R12

 

 

 

 

RHQ_MEAS_DATA_NUM_R13

 

 

 

 

RHQ_MEAS_DATA_NUM_R14

 

 

 

 

RHQ_MEASUREMENT_BLINE

 

 

images/author/images/icons/emoticons/check0.gif

 

RHQ_MEASUREMENT_DATA_NUM_1D

 

images/author/images/icons/emoticons/check0.gif

images/author/images/icons/emoticons/check0.gif

 

RHQ_MEASUREMENT_DATA_NUM_1H

 

images/author/images/icons/emoticons/check0.gif

images/author/images/icons/emoticons/check0.gif

 

RHQ_MEASUREMENT_DATA_NUM_6H

 

images/author/images/icons/emoticons/check0.gif

images/author/images/icons/emoticons/check0.gif

 

RHQ_MEASUREMENT_DATA_TRAIT

 

images/author/images/icons/emoticons/check0.gif

images/author/images/icons/emoticons/check0.gif

 

RHQ_MEASUREMENT_DEF

 

 

 

 

RHQ_MEASUREMENT_OOB

 

 

 

 

RHQ_MEASUREMENT_SCHED

 

 

 

 

RHQ_NUMBERS

 

 

 

 

RHQ_OPERATION_DEF

 

 

 

 

RHQ_OPERATION_HISTORY

 

 

 

 

RHQ_OPERATION_SCHEDULE

 

 

 

 

RHQ_PACKAGE

 

 

 

 

RHQ_PACKAGE_BITS

 

 

 

 

RHQ_PACKAGE_INST_STEP

 

 

 

 

RHQ_PACKAGE_TYPE

 

 

 

 

RHQ_PACKAGE_VERSION

 

 

 

 

RHQ_PARTITION_DETAILS

 

 

 

 

RHQ_PARTITION_EVENT

 

 

 

 

RHQ_PERMISSION

 

 

 

 

RHQ_PKG_PRD_MAP

 

 

 

 

RHQ_PKG_VER_CONTENT_SRC_MAP

 

 

 

 

RHQ_PLUGIN

 

 

 

 

RHQ_PRD_VER

 

 

 

 

RHQ_PRINCIPAL

 

 

 

 

RHQ_PROCESS_SCAN

 

 

 

 

RHQ_QRTZ_BLOB_TRIGGERS

 

 

 

 

RHQ_QRTZ_CALENDARS

 

 

 

 

RHQ_QRTZ_CRON_TRIGGERS

 

 

 

 

RHQ_QRTZ_FIRED_TRIGGERS

 

 

 

 

RHQ_QRTZ_JOB_DETAILS

 

 

 

 

RHQ_QRTZ_JOB_LISTENERS

 

 

 

 

RHQ_QRTZ_LOCKS

 

 

 

 

RHQ_QRTZ_PAUSED_TRIGGER_GRPS

 

 

 

 

RHQ_QRTZ_SCHEDULER_STATE

 

 

 

 

RHQ_QRTZ_SIMPLE_TRIGGERS

 

 

 

 

RHQ_QRTZ_TRIGGER_LISTENERS

 

 

 

 

RHQ_QRTZ_TRIGGERS

 

 

 

 

RHQ_RESOURCE

images/author/images/icons/emoticons/check0.gif

 

 

 

RHQ_RESOURCE_AVAIL

 

 

 

 

RHQ_RESOURCE_ERROR

 

 

 

 

RHQ_RESOURCE_GROUP

 

 

 

 

RHQ_RESOURCE_GROUP_RES_EXP_MAP

 

 

 

 

RHQ_RESOURCE_GROUP_RES_IMP_MAP

 

 

 

 

RHQ_RESOURCE_SUBCAT

 

 

 

 

RHQ_RESOURCE_TYPE

 

 

 

 

RHQ_RESOURCE_TYPE_PARENTS

 

 

 

 

RHQ_ROLE

 

 

 

 

RHQ_ROLE_RESOURCE_GROUP_MAP

 

 

 

 

RHQ_SERVER

 

 

 

 

RHQ_SUBJECT

 

 

 

 

RHQ_SUBJECT_ROLE_MAP

 

 

 

 

RHQ_SYSTEM_CONFIG

 

 

 

 

There are additional tables auto-created for us by the JMS system:

Tablename

V

TR

OR

Description

JMS_MESSAGES

 

 

 

Contains persisted JMS messages that need to be sent

JMS_ROLES

 

 

 

 

JMS_SUBSCRIPTIONS

 

 

 

 

JMS_TRANSACTIONS

 

 

 

Contains persisted transactions that have not completed yet

JMS_USERS

 

 

 

 

JBoss.org Content Archive (Read Only), exported from JBoss Community Documentation Editor at 2020-03-13 08:00:06 UTC, last content change 2013-09-18 19:41:33 UTC.