My Oracle Support Banner

What is the Entity Relationship Diagram for NMS Facilities? (Doc ID 2012648.1)

Last updated on JUNE 03, 2024

Applies to:

Oracle Utilities Network Management System - Version 1.12.0.1 and later
Oracle Network Management for Utilities - DMS - Version 1.12.0.1 and later
Information in this document applies to any platform.

Purpose

 What is the Entity Relationship Diagram (ERD) for the facilities (network model) component of the Network Management System (NMS) application?

Scope

The attached Facilities-ERD.pdf document provides an overview of the various database tables used for the facilities, or network model, component of NMS. 

This does not cover any custom tables or views that have been added beyond the product configuration.

Tables in the ERD: NETWORK_COMPONENTS, NETWORK_NODES, OBJECT_INSTANCES, ALIAS_MAPPING, LOCATIONS, PARTITIONS, CONTROL_ZONES, DIAGRAM_OBJECTS, ALTERNATE_VIEWS, POINT_COORDINATES, ALTERNATE_DIAGRAMS, CES_CUSTOMERS, SUPPLY_NODES, FEEDERS, ATT_* [Facility Attribute Tables] (eg. ATT_BREAKER, ATT_TRANSFORMER).

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Purpose
Scope
Details

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.