What is the Entity Relationship Diagram for NMS Facilities?
(Doc ID 2012648.1)
Last updated on DECEMBER 03, 2019
Applies to:Oracle Utilities Network Management System - Version 220.127.116.11 and later
Oracle Network Management for Utilities - DMS - Version 18.104.22.168 and later
Information in this document applies to any platform.
What is the Entity Relationship Diagram (ERD) for the facilities (network model) component of the Network Management System (NMS) application?
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).
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