Below is the list of all tables in the schema.
V indicates if, on Postgres, this table is periodically vacuumed
TR indicates if, on Postgres, the table is reindexed
OR indicates if, on Oracle, some or all of the table's indexes are reindexed
(SystemManagerBean is where V, TR and OR info is found)
Tablename |
V |
TR |
OR |
Description |
RHQ_AFFINITY_GROUP |
|
|
|
|
RHQ_AGENT |
|
|
|
|
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 |
|
|
|
|
RHQ_CALLTIME_DATA_KEY |
|
|
|
|
RHQ_CALLTIME_DATA_VALUE |
|
|
|
|
RHQ_CHANNEL |
|
|
|
|
RHQ_CHANNEL_CONTENT_SRC_MAP |
|
|
|
|
RHQ_CHANNEL_PKG_VERSION_MAP |
|
|
|
|
RHQ_CHANNEL_RESOURCE_MAP |
|
|
|
|
RHQ_CONF_PROP_DEF_ENUM |
|
|
|
|
RHQ_CONFIG |
|
|
|
|
RHQ_CONFIG_DEF |
|
|
|
|
RHQ_CONFIG_GROUP_UPDATE |
|
|
|
|
RHQ_CONFIG_PROP_CONSTR |
|
|
|
|
RHQ_CONFIG_PROP_DEF |
|
|
|
|
RHQ_CONFIG_PROP_GRP_DEF |
|
|
|
|
RHQ_CONFIG_PROPERTY |
|
|
|
|
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 |
|
|
|
|
RHQ_MEASUREMENT_DATA_NUM_1D |
|
|
|
|
RHQ_MEASUREMENT_DATA_NUM_1H |
|
|
|
|
RHQ_MEASUREMENT_DATA_NUM_6H |
|
|
|
|
RHQ_MEASUREMENT_DATA_TRAIT |
|
|
|
|
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 |
|
|
|
|
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 |
|
|
|
|