Design-AllDBTables

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

Design-AllDBTables

Labels