This section provides descriptions and table columns for all Service Warehouse database tables.
For all tables in this section, the following column heading abbreviations are used:
- P = Primary Key
- M = Mandatory
- F = Foreign
The following sections contain the entity relationship diagram for the Service Warehouse database, as well as a section for all warehouse tables:
-
Section 3.1, Database Entity Relationship Diagram
-
Section 3.2, BSAAdapters Table
-
Section 3.3, BSAAlarmData Table
-
Section 3.4, BSAAlarmElements Table
-
Section 3.5, BSAAlarmMetaData Table
-
Section 3.6, BSAAlarmProperties Table
-
Section 3.7, BSAAlarmQueue Table
-
Section 3.8, BSAAlarmSeries Table
-
Section 3.9, BSAAlarmValues Table
-
Section 3.10, BSAAlarmValueTypes Table
-
Section 3.11, BSAConfigHistory Table
-
Section 3.12, BSADataTypes Table
-
Section 3.13, BSAElements Table
-
Section 3.14, BSAFactSeriesData Table
-
Section 3.15, BSAFactSeriesRootCauses Table
-
Section 3.16, BSAFactSeriesSummary Table
-
Section 3.17, BSAHosts Table
-
Section 3.18, BSARootCauseChains Table
-
Section 3.19, BSARootCauseHierarchy Table
-
Section 3.20, BSARootCauseReasons Table
-
Section 3.21, BSARootCauseTrees Table
-
Section 3.22, BSASeries Table
-
Section 3.23, BSATimeBand Table
-
Section 3.24, BSAVersionWarehouse Table