Skip to end of metadata
Go to start of metadata

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        
Labels:
None
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.