Instance Reporting Database Schema
The ActiveBatch Reporting Database consists of 24 tables. Among these tables, ProductHistory is reserved for internal use and can be changed between releases. In addition, the Sequence, AuditsForStaging, InstanceForStaging, ObjectsForStaging, UpdatedDimensions, JobSchedulerMachines, MachineTags, and TagUsers tables are auxiliary and should not be altered. The overall database schema for SQL is provided in the figure below. (The UpdatedDimensions, JobschedulerMachines, MachineTags and TagUsers tables do not exist in the schema for Oracle).
/Figure 43 Template Properties_1.jpg)
Within this database schema, the following primary and foreign keys are used:
List of primary keys
| Table Name | Primary Key |
|---|---|
|
ActiveInstances |
ActiveInstance |
|
AuditsForStaging |
Id |
|
Dates |
DateValue |
|
EventAudits |
EventAudits |
|
JobSchedulers |
Id |
|
JobSchedulerMachines |
JobSchedulerId, MachineId |
|
States |
Id |
|
Messages |
Messages |
|
Machines |
Id |
|
MachineTags |
MachineId, TagId |
|
Tags |
Id |
|
TagUsers |
TagId, UserId |
|
InstancesForStaging |
Id |
|
Instances |
Id |
|
Users |
Id |
|
Times |
TimeValue |
|
ObjectTags |
ObjectId, TagId |
|
ObjectPaths |
ObjectId |
|
Objects |
Id |
|
ObjectsForStaging |
Id |
|
Severities |
Severities |
|
UpdatedDimensions |
DimensionName |
List of Foreign Keys
| Foreign Key Name | Id Table | Foreign Table |
|---|---|---|
|
FK_ObjectTag_Object |
Objects |
ObjectTags |
|
FK_ObjectTag_Tag |
Tags |
ObjectTags |
|
FK_Object_User |
Users |
Objects |
|
FK_ObjectPath_Object |
Objects |
ObjectPaths |
|
FK_Instance_Object |
Objects |
Instances |
|
FK_Instance_State |
States |
Instances |
|
FK_Instance_CreationDate |
Dates |
Instances |
|
FK_Instance_CreationTime |
Times |
Instances |
|
FK_Instance_Machine |
Machines |
Instances |
|
FK_JobschedulerMachine_Jss |
JobSchedulers |
JobSchedulerMachines |
|
FK_JobschedulerMachine_Machine |
Machines |
JobSchedulerMachines |
|
FK_MachineTags_Machine |
Machines |
MachineTags |
|
FK_MachineTags_Tag |
Tags |
MachineTags |
|
FK_TagUsers_Tag |
Tags |
TagUsers |
|
FK_TagUsers_User |
Users |
TagUsers |
|
FK_EventAudits_Date |
Dates |
EventAudits |
|
FK_EventAudits_Message |
Messages |
EventAudits |
|
FK_EventAudits_Object |
Objects |
EventAudits |
|
FK_EventAudits_Time |
Times |
EventAudits |
|
FK_Messages_Severity |
Severities |
Messages |